View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
willem willem is offline
external usenet poster
 
Posts: 14
Default copy refered cells

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