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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi!

One way:

In F4:

=INDIRECT("Calender!G"&COLUMN()+11)

Copy across as needed.

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help for Excel 97 6
How do I make this display a "0" value 4
Drag & Drop 1
Ignore Blank in Validation not working 4
How do I get an IS and IF statement to work together in excel? 3
Top 4 scores in excel 4
Excel Excel help with drag and reference cell option 1
I can no longer 'drag and drop' text. 6

Back
Top