R
Ray
Hello -
I have two spreadsheets, call them MONTHLY and YTD. These files are
set-up like this:
MONTHLY file has ONE tab (sheet name=name of the month)
-- row 3 contains store numbers, approx 4 columns between store
numbers
-- first store number is in column C
-- target data is in rows 7:100
YTD has approx 30 tabs (sheet name = store number)
-- row 3 contains months (same format as 'name of month' above)
-- target data to be pasted in rows 7:100
My users will select a month and the appropriate MONTHLY file will
open. The code then needs to find each column where a value exists in
row 3 (the store number), copy the range 7:100 and then switch to the
YTD file, find the right tab (store number) and paste the data in the
correct column (month name) in row 7:100.
What would the code look like to do this?
TIA,
Ray
I have two spreadsheets, call them MONTHLY and YTD. These files are
set-up like this:
MONTHLY file has ONE tab (sheet name=name of the month)
-- row 3 contains store numbers, approx 4 columns between store
numbers
-- first store number is in column C
-- target data is in rows 7:100
YTD has approx 30 tabs (sheet name = store number)
-- row 3 contains months (same format as 'name of month' above)
-- target data to be pasted in rows 7:100
My users will select a month and the appropriate MONTHLY file will
open. The code then needs to find each column where a value exists in
row 3 (the store number), copy the range 7:100 and then switch to the
YTD file, find the right tab (store number) and paste the data in the
correct column (month name) in row 7:100.
What would the code look like to do this?
TIA,
Ray