Path not found, but the folders do exist
[code] Sub toPDF() ' This will copy a specified range('s) from ws1 & ws2 to ws3. ' Now you can...
I believe the problem is that you are not getting the sFileName from the original workbook. So I have added ActiveWorkbook.Save...
Hello Ready2go This may only answer some of your question. The macro below will create a PDF file of Sheet2....
Dear Hyside2, I really appreciate your cooperation and helpful answer. Thanks so much.
Try this instead =IFERROR(LEFT(B1,FIND(" ",B1)-1),B1) [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/08/givenname.png[/img]
I am not sure if this is what you are looking for but test it out anyway. [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/08/1-2.png[/img]...
Oh! Please try this. You will need to change "Book1" on the line that reads (oFilename="Book1") to the name of...
I have problem coding between two columns and third with result
Column E = Destination
And Column G Should contain RP/ARRIVAL
Or SPOT TIME It depends from the destination
You can create similar file with dummy data I don’t think it is difficult
Can you point to the line that the error occurs at?
Yes!! I’ll try dummy I think it’s going to be more easy to get what I need! Thanks!!! 🙂
Can you give more details and attach sample of your workbook with some desired output?
Column E is Origin
Column F is Destination
Column G may be RP TIME/SPOT TIME/TMR RELEASE
G depends of which is the origin and what I have to track.
G should be RP TIME
Origin = Macedonia
G should be SPOT TIME
I hope am easy to understand now 🙂
And thank you! 🙂
Try this code
Dim i As Long
Dim m As Long
m = Cells(Rows.Count, 5).End(xlUp).Row
For i = 2 To m '2 First Row Of Data. I Supposed Row 1 For Headers
If Cells(i, 5) = "Kuwait" And Cells(i, 6) = "Macedonia" Then
Cells(i, 7) = "RP TIME"
ElseIf Cells(i, 5) = "Macedonia" And Cells(i, 6) = "Majami" Then
Cells(i, 7) = "SPOT TIME"
Cells(i, 7) = ""
Thank you!! I will and I’ll let you know 🙂
Glad I can offer some help
Thank you! It runs, Ill try some others stuff that I need to add for matching, but I have another problem now, I had a diffrent code I set the macro to run whenever I open the work book but now it gives me error of function or variable on my mobule 🙁 so I have to run it manual
It will be better to upload sample of your workbook to see the error ..
Try to declare all the variables in your codes so as to avoid errors
I cannot upload a file, at least I don’t see permission for that 🙂
I can’t help you anymore. Hope you can find the cause of error on your own
I am trying dummy now so I hope I’ll get what I need. Thanks!!
Please share using the share button above.
If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.
Found the answer useful and wants to credit the user, then vote the answer (vote up).