C.R.
03-19-2013, 10:45 AM
Hello,
I am stuck today.
In E12:J12 I have some formulas that pull data from an order info sheet.
Each time I get a new order, I’d like to copy the formulas in E12:J12 down just one row to E13:J13. Then…PasteSpecial>>> Values in E12:J12.
Next time there’s a new order, E13:J13 formulas would copy down to E14:J14.
Then PasteSpecial>>> Values in E13:J13.
This will go on as more orders come in…
I have many sheets like this with other products on them.
Thanks in advance for any help on this.
Spreadsheet is attached.
C.R.
I am stuck today.
In E12:J12 I have some formulas that pull data from an order info sheet.
Each time I get a new order, I’d like to copy the formulas in E12:J12 down just one row to E13:J13. Then…PasteSpecial>>> Values in E12:J12.
Next time there’s a new order, E13:J13 formulas would copy down to E14:J14.
Then PasteSpecial>>> Values in E13:J13.
This will go on as more orders come in…
I have many sheets like this with other products on them.
Thanks in advance for any help on this.
Spreadsheet is attached.
C.R.