copy refered cells

W

willem

Hi,

I'm bussy summarizing a whole bunch o claims for 4 similar projects, 36
claims x 4. Now I have cells refering for let say column A to claim 1
(=C:\long adress... claim 1, $D$49) Now when I copy (pull down) the reference
excel doesn't automaticaly number up the claim from 1 to 36. Now I access
everey cell and change the number by hand. Is there any way I can skip this
and let excell do it for me. Have about 30 cells i refer to from the summary
for each certificate and its frustrating to change it all by hand.

Thanks

Willem
 

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

indirect function 4
Hand Work 1
Automating skipping rows between selected cells. Please Help 3
formatting cells fractions - HELP 7
copy/paste won't refer to the appropriate range of cells 1
How to map cells to a reference then copy adjacent ones 4
copy cells from one file to another file 3
Macro to copy cells to rows below 1

Top