K
Kathryn
Hi all - I think this should be rather simple.
Unfortunately, I have not been able to figure it out & I'm
getting frustrated! Put simply, this is what I want to do:
I have two spreadsheets (ss1 & ss2). Range("b10:b25") of
ss1 is linked to a column (which contains current week
stats) in ss2. Each week new data is added to ss2,
resulting in the column containing the current week stats
being adjusted one column to the right, i.e., prior week
stats are now in column "AA" and current week stats in
column "AB" - row numbers stay constant.
I would like a macro to open ss1, select range("b10:b25"),
and automatically change the link to ss2 from column "AA"
to column "AB" (maybe using R1C1 reference ??).
Any help would be greatly appreciated
Thx, Kathryn
Unfortunately, I have not been able to figure it out & I'm
getting frustrated! Put simply, this is what I want to do:
I have two spreadsheets (ss1 & ss2). Range("b10:b25") of
ss1 is linked to a column (which contains current week
stats) in ss2. Each week new data is added to ss2,
resulting in the column containing the current week stats
being adjusted one column to the right, i.e., prior week
stats are now in column "AA" and current week stats in
column "AB" - row numbers stay constant.
I would like a macro to open ss1, select range("b10:b25"),
and automatically change the link to ss2 from column "AA"
to column "AB" (maybe using R1C1 reference ??).
Any help would be greatly appreciated
Thx, Kathryn