HI,
I have the following set up
ColK ColL ColM Col S
Week 6 Week 7 Week 8 up to week 13 I'm summing all weeks

Every week, I'm inserting a Vlookup. Is there a way I can do this with a
macro?
Since i'm summing all weeks, I can't copy the vlookup to next column.
The vlookup will always be in Specific week column row2. I have to insert the
vlookup in a few sheets, so trying to see if there is a faster way than
doing
this manually.

Hope I'm making sense.
ANy help wold be really appreciated.
Thanks,
Juan