LinkBack URL
About LinkBacks
clundeen 
I made a quick exanple to demonstrate what I need
wk1 has a group of cell filled in red and named "Shiftschedule"
The defined cells in wk1 look at ws "ScheduleTablet" for information. I am looking for a macro to take the reference cells and shift down 21 rows each - I am open to options - but this one is beyond my experience - THANKS!!!
in otherwords wk1
Before Macro
A3=ScheduleTablet!B3
A4=ScheduleTablet!B4
A5=ScheduleTablet!B5
A6=ScheduleTablet!B6
After Macro
A3=ScheduleTablet!B24
A4=ScheduleTablet!B25
A5=ScheduleTablet!B26
A6=ScheduleTablet!B27
A3=ScheduleTablet!B45......
Register To Reply
Bookmarks