D
Dominic Vella
I'm trying to copy formula's from one excel workbook sheet to another
workbook but whether I do a special paste value, or special paste formula,I
still end up with a link. Mind you, the sheet I'm copying does refer to
other sheets in the workbook.
Eg, book one has sheet called "totals", in it has a link to a sheet called
"Station1".
Book two already has a sheet called "Station1". When I copy the book 1
"totals" sheet into book 2, I want the pasted information to reference
books.Station1 sheet.
Can someone explain how I can do just a straight paste without it referring
back to book1?
Tnx
workbook but whether I do a special paste value, or special paste formula,I
still end up with a link. Mind you, the sheet I'm copying does refer to
other sheets in the workbook.
Eg, book one has sheet called "totals", in it has a link to a sheet called
"Station1".
Book two already has a sheet called "Station1". When I copy the book 1
"totals" sheet into book 2, I want the pasted information to reference
books.Station1 sheet.
Can someone explain how I can do just a straight paste without it referring
back to book1?
Tnx