I do not know why this does this. But I was able to work around the problem. Please try this...
Maybe try declaring the FSO as Object. "Dim FSO" without a declaration declares the FSO as a variant. Just a...
Each block is a named range. There are 6 Key colors which are based on the information in column “Y”(Rental...
I cleaned up the code. This will place next month and year in cell A1. So today is Sep30 2018...
This was tested in a blank worksheet (no data). The macro will place next Month and Year in cell A1....
Updated the code to include the possibility of blank cells in the raw data. If a blank cell is found...
Lets try this again. You will need 3 sheets. Sheet1, Sheet 2 and Sheet3 Sheet1 your raw data Sheet2 is...
Hey Thank you so much. Apologies for not been very clear on the question. Using your example, in the output...
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).