P
Paul Watkins
Hi
I have a spreadsheet with 2 sheets in it.
Sheet 1 has merged cells, single cells and links on it to data contained in
other workbooks.
at the end of the working day i want to be able to click a macro to copy
this information onto 'Sheet2' which has the same formats on it (merged
cells, single cells) but no links. In other words i want the macro to copy
and paste 'values' only.Thus retaining the information.
When i try to record this macro i get a message telling me that 'The cells
need to be the same size' which they are.
If i just paste this information from sheet 1 to sheet 2 there is no
problem, it's just when i select 'Paste Special' and try to paste just the
'Values' i get the message.
Is there any way around this problem?
Thanks in advance
Paul
I have a spreadsheet with 2 sheets in it.
Sheet 1 has merged cells, single cells and links on it to data contained in
other workbooks.
at the end of the working day i want to be able to click a macro to copy
this information onto 'Sheet2' which has the same formats on it (merged
cells, single cells) but no links. In other words i want the macro to copy
and paste 'values' only.Thus retaining the information.
When i try to record this macro i get a message telling me that 'The cells
need to be the same size' which they are.
If i just paste this information from sheet 1 to sheet 2 there is no
problem, it's just when i select 'Paste Special' and try to paste just the
'Values' i get the message.
Is there any way around this problem?
Thanks in advance
Paul