Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help please simple drop and drag I can't make work
Want to drag this across a page so that G4 will be G18, H4 will be G19 etc
Cell F4=Calender!$G17 I know its simple but I've got a mental blank on it. How do I get it to work please thanks anthony |
#2
|
|||
|
|||
Hi!
One way: In F4: =INDIRECT("Calender!G"&COLUMN()+11) Copy across as needed. Biff "Anthony" wrote in message ... Want to drag this across a page so that G4 will be G18, H4 will be G19 etc Cell F4=Calender!$G17 I know its simple but I've got a mental blank on it. How do I get it to work please thanks anthony |
#3
|
|||
|
|||
Thanks
much appreciated "Biff" wrote: Hi! One way: In F4: =INDIRECT("Calender!G"&COLUMN()+11) Copy across as needed. Biff "Anthony" wrote in message ... Want to drag this across a page so that G4 will be G18, H4 will be G19 etc Cell F4=Calender!$G17 I know its simple but I've got a mental blank on it. How do I get it to work please thanks anthony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell drop and drag | Excel Worksheet Functions | |||
drag and drop to get a lot of wordarts? | Excel Discussion (Misc queries) | |||
drag and drop to get a lot of wordarts? | Excel Discussion (Misc queries) |