ExcelBanter - Help please simple drop and drag I can't make work

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help please simple drop and drag I can't make work (https://www.excelbanter.com/excel-worksheet-functions/34614-help-please-simple-drop-drag-i-cant-make-work.html)

Anthony

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

Biff

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

Anthony

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

All times are GMT +1. The time now is 03:41 PM.