use multiple worksheets

M

Mike In Norcross

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
 
P

Peo Sjoblom

on the sheet you want to copy from do edit>replace, 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
 
S

Skip Bisconer

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

Skip Bisconer
 
Top