I have Text Values going down column D (starting in Row 13) on sheets("TRAVEL INFORMATION")
WHEN THERE IS A VALUE IN THE ROW FO COLUMN D I WANT TO COPY COLUMNS B:C ON SHEETS("TRAVEL CALCULATIONS") OVER TO THE NEXT AVAILABLE THREE COLUMNS. THEN I WANT TO TAKE THE VALUE THAT WAS IN THE ROW ON...
The Code doesn't like: If Sheets("TRAVEL INFORMATION").Cells(p, 3).Value <> """"
I want it to create a tab if that cell is not null. Not sure why it doesn't like this
Dim p As Integer
Dim LastRow As Long
With Sheets("TRAVEL INFORMATION")...