Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
How to Count values inside a cell when refered elsewhere? | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions |