| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy a Formula down with a Twist Q
I would appreciate any heply in solving what seems a simple problem.
I wish to copy down a formula in Cell AA1, that contains a reference to B1 down to AA6, but instead of it showing B6 I want it to show B7. I have an extended formula in AA1 but only the reference to B1 is the critical part as I just want to simplify my post. I scanned the Groups for an answer and I'm getting more confused. I've to copy this formula 400 times so that why I don't want to do it manually! Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
| How do I copy a formula in excel where part remains absolute the . | Excel Discussion (Misc queries) | |||
| Copy Formula But Keep 1 Common Cell | Excel Discussion (Misc queries) | |||
| How do I copy a formula? | Excel Worksheet Functions | |||
| Copy formula to every 12th cell | Excel Worksheet Functions | |||
Threaded Mode
