One way ..
Place this in the starting cell, eg in B2:
=INDIRECT("'PO#"&ROW(A1)+6600&"'!F7")
Copy down as far as required
If you are copying it across, use instead in B2:
=INDIRECT("'PO#"&COLUMN(A1)+6600&"'!F7")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"cac1966" wrote:
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.