Hi all,
I'm 50% through writing some vba that's used for updating a master sales tracker with new data each week.
They key to this bit of vba is that it has to be dynamic, working out which sales it already has and checking if the input data is in the correct tabs and is the weeks data it is expecting.
The bit I'm stuck on is getting the macro to insert the vlookup into the correct cell:
I'm using a tag "lastweek" so the vba knows which week it has data up to, and I need to start the vlookup from the green cell.
Now I know I can offset one column and two rows down to get there, but I don't know how to get the address of where "lastweek" is.
Any help appreciated
I'm 50% through writing some vba that's used for updating a master sales tracker with new data each week.
They key to this bit of vba is that it has to be dynamic, working out which sales it already has and checking if the input data is in the correct tabs and is the weeks data it is expecting.
The bit I'm stuck on is getting the macro to insert the vlookup into the correct cell:
I'm using a tag "lastweek" so the vba knows which week it has data up to, and I need to start the vlookup from the green cell.
Now I know I can offset one column and two rows down to get there, but I don't know how to get the address of where "lastweek" is.
Any help appreciated
