View Single Post
 
Old 10-30-2015, 01:03 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Oct 2015
Posts: 79
Officer_Bierschnitt is on a distinguished road
Default VBA: Find a column by its date

Hi,

I am just learning Excel and VBA again after some years with other tools.
Now I have a task that I have already solved to a good part.
Right now, I have the value I want in a variable and I just have to paste that in the "adressee_table" in a specific row (fixed value depending on the type of value) and a specific column (dependent on the date, the date is across the entire table in line 3).
I always have yesterday's data, so my macro should always look for the column with yesterday's date in line 3 and just paste the variable in that cell.

I guess I need that FIND command, but I don't know the exact syntax and what I have to write in the parameters and I haven't yet got fluent in using the integrated help.
Can anybody tell me how to do that?
Thanks a lot!

Best regards,

Officer_Bierschnitt
Reply With Quote