jw01
12-21-2010, 04:34 PM
im not to familiar with the indirect and skipping rows and applying it into a formula.
my formula is as follows or reference
='J:\Sales Analyst\SWAT\Archieve 2011\P1W1\[New York.xls]G.S Branch'!$D$6
-the period/week starts on column C7, and after every 21 rows a new week starts, so I would like the italic "P1W1" to sequentially look off that cell ...keep in mind it skips every 21 cells.
-also, the city named can be locked down to $C$5.
can anyone help me with incorporating an indirect/skipping function or one that seems feasible to execute it in the formula; so it's referencing to the correct cell? PLS AND THX YOU very much!
my formula is as follows or reference
='J:\Sales Analyst\SWAT\Archieve 2011\P1W1\[New York.xls]G.S Branch'!$D$6
-the period/week starts on column C7, and after every 21 rows a new week starts, so I would like the italic "P1W1" to sequentially look off that cell ...keep in mind it skips every 21 cells.
-also, the city named can be locked down to $C$5.
can anyone help me with incorporating an indirect/skipping function or one that seems feasible to execute it in the formula; so it's referencing to the correct cell? PLS AND THX YOU very much!