R
Ray
Hello -
Forgive if this ends up as a 're-post' ... I tried an hour ago to post
this question and while that attempt appeared to be successful, I
don't see it on the board at all ....
I have two WBs ... let's call them MONTHLY and SUMMARY. The setup of
each WB is like this:
MONTHLY - contains just one sheet (uses the calendar month as tab
name);
store names start in at C3 and go across to approx
GA3;
there are 4 columns between store #'s (so C3, G3,
K3, etc)
source range is Row 7:100 (so C7:C100, G7:G100)
Summary - one tab for each Store;
each tab has a column for each month again starting
at C3, but in consecutive rows
destination range is Row 7:100 (so, C7:C100, D7
100,
etc)
I need to programatically open the MONTHLY file, get the first range
(c7:100), switch to the SUMMARY file, find the correct tab (which is
the same name is value in C3 of MONTHLY file) and then paste in the
appropriate column (by month). Then, back to MONTHLY and over 4
columns to the next store ... and repeat the steps.
Can someone help me with this code?
TIA,
Ray
Forgive if this ends up as a 're-post' ... I tried an hour ago to post
this question and while that attempt appeared to be successful, I
don't see it on the board at all ....
I have two WBs ... let's call them MONTHLY and SUMMARY. The setup of
each WB is like this:
MONTHLY - contains just one sheet (uses the calendar month as tab
name);
store names start in at C3 and go across to approx
GA3;
there are 4 columns between store #'s (so C3, G3,
K3, etc)
source range is Row 7:100 (so C7:C100, G7:G100)
Summary - one tab for each Store;
each tab has a column for each month again starting
at C3, but in consecutive rows
destination range is Row 7:100 (so, C7:C100, D7
100,etc)
I need to programatically open the MONTHLY file, get the first range
(c7:100), switch to the SUMMARY file, find the correct tab (which is
the same name is value in C3 of MONTHLY file) and then paste in the
appropriate column (by month). Then, back to MONTHLY and over 4
columns to the next store ... and repeat the steps.
Can someone help me with this code?
TIA,
Ray