| 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) | |||
Linear Mode
