Copying formulas from/to monthly spreadsheets

G

Guest

I've asked this question last month, but couldn't use the answer.

Excel 2003

I want to copy my September workbook to an October workbook. Several
formulas in the September workbook reference a table within that workbook.
When I copy and rename the workbook to October, the formulas still reference
the September table. There is a table by the same name for October, which is
the table I want referenced. I just want the formulas to look exactly like
September (=SUMIF(' SHIFT 1 '!$L$1:$L$200,"BB",' SHIFT 1 '!$X$1:$X$200).
When I copy September's formula and paste special, formulas and format, I get
this:

=SUMIF('[09 Daily Shift Template.xls]SHIFT 1'!$K$1:$K$200,"BB",'[09 Daily
Shift Template.xls]SHIFT 1'!$X$1:$X$200)

Any ideas?

TIA,

Carole O
 
P

Paul Corrado

Carole,

You should be able to open the September File and then use Save As to create
the October version instead of copying the worksheets. That should resolve
the issues.

HATH

PC
 
G

Guest

Thanks, Paul. I had a 50/50 chance of choosing Save As vs copying! Your
suggestion works!

Carole

Paul Corrado said:
Carole,

You should be able to open the September File and then use Save As to create
the October version instead of copying the worksheets. That should resolve
the issues.

HATH

PC


Carole O said:
I've asked this question last month, but couldn't use the answer.

Excel 2003

I want to copy my September workbook to an October workbook. Several
formulas in the September workbook reference a table within that workbook.
When I copy and rename the workbook to October, the formulas still reference
the September table. There is a table by the same name for October, which is
the table I want referenced. I just want the formulas to look exactly like
September (=SUMIF(' SHIFT 1 '!$L$1:$L$200,"BB",' SHIFT 1 '!$X$1:$X$200).
When I copy September's formula and paste special, formulas and format, I get
this:

=SUMIF('[09 Daily Shift Template.xls]SHIFT 1'!$K$1:$K$200,"BB",'[09 Daily
Shift Template.xls]SHIFT 1'!$X$1:$X$200)

Any ideas?

TIA,

Carole O
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapping strings to integers 5
copying formulas 7
Re: Convert Array Formulas to Regular Formulas 0
SUMPRODUCT CAPTURING DATA FROM ANOTHER SPREADSHEET 6
Macro for Adding Lines to Linked Spreadsheets 1
COPYING FORMULAE 1
Copying Excel formulas from one Workbook to another 3
combining data from multiple worksheets into one 6

Top