View Single Post
  #3   Report Post  
Anthony
 
Posts: n/a
Default

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