I would like to open and edit several worksheets (compare side by side) at
the same time to make changes and use formulas from one to the other. I know
that this is possible when you work on two separately named workbooks (i.e.
book1.xls and book2.xls) but can it be done from same workbook. In order to
complete a summary sheet, I had to rename the file so both will open at the
same time. Is there a way to open sheet one, delete sheet called Product and
replace it with Product1 one from another workbook without loosing the link
and formulas between Product1 (new workbook) and the original workbook
Summary sheet? I know this is convulted sorry...