| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How would I implement this cell increment?
I have a reference to another sheet and I need to copy the reference like this:
sheet 2 A B 1 ='sheet1'B1 ='sheet1'B2 2 ='sheet1'E1 ='sheet1'E2 if I try to copy/paste or fill I get b1, b2, b3 going down which I don't want - I know I can do this manually but I have about 100 rows each approx 10 columns to fill like this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| number cell increment +1 when dragging down box | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| how to make cell address reference increment? | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Threaded Mode
