use multiple worksheets
 

I have a spreadsheet with 12 worksheets, one for each month. I would like to
have cell names on each sheet that are identical to the others. I was able
to create one sheet and then copy it entirely and the cells names copied
properly, however, now I need to add new information, with new cell names and
when I try to copy that portion of the worksheet to another, the name
references change and won't be absolute to each worksheet.

Help Please!

Mike

on the sheet you want to copy from do editreplace, replace = with r=
(replace the equal sign with lett_equal sign),
that makes the formulas/links into text strings, now copy them over to the
new sheets, when you are done reverse the replace and find r= and replace
with =
on all sheets involved
that will make them refer to the same sheet as opposed to refering back to
the original sheet

Regards,

Peo Sjoblom

"Mike In Norcross" wrote:

I have a spreadsheet with 12 worksheets, one for each month. I would like to
have cell names on each sheet that are identical to the others. I was able
to create one sheet and then copy it entirely and the cells names copied
properly, however, now I need to add new information, with new cell names and
when I try to copy that portion of the worksheet to another, the name
references change and won't be absolute to each worksheet.

Help Please!

Mike

Have you tried Linking all the worksheets together then adding new
information to the first one? That works for me.

Skip Bisconer

"Peo Sjoblom" wrote:

on the sheet you want to copy from do editreplace, replace = with r=
(replace the equal sign with lett_equal sign),
that makes the formulas/links into text strings, now copy them over to the
new sheets, when you are done reverse the replace and find r= and replace
with =
on all sheets involved
that will make them refer to the same sheet as opposed to refering back to
the original sheet

Regards,

Peo Sjoblom

"Mike In Norcross" wrote:

I have a spreadsheet with 12 worksheets, one for each month. I would like to
have cell names on each sheet that are identical to the others. I was able
to create one sheet and then copy it entirely and the cells names copied
properly, however, now I need to add new information, with new cell names and
when I try to copy that portion of the worksheet to another, the name
references change and won't be absolute to each worksheet.

Help Please!

Mike