Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
want to copy formula, only change one number in formula
I am using a main worksheet in a workbook to capture information from other
worksheets within the workbook. I want to copy formulas without changing all the formula. I only want to change 1 value when copying. Example: ='PO#6601'!F7 The only number I want to change when copying this formula is the "6601" I want it to increase by one each time the formula is copied. I want everything else to stay the same especially the "F7". This program is a purchase order program with a ledger which saves all the information with each new purchase order I record on a separtate worksheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy a formula that does not change the column or row number? | Excel Discussion (Misc queries) | |||
copy a formula into multiple worksheets and change 1 row down each | Excel Discussion (Misc queries) | |||
Copy a formula down a set number of times | Excel Worksheet Functions | |||
how to copy just the number that a formula creates | Excel Worksheet Functions | |||
how do i copy formula and change worksheet instead of cell | Excel Worksheet Functions |