duplicate table just values not formulas in the table

R

Rob

duplicate a table with the just values not formulas in the table so that I
don't have to readjust the formulas as when they are copied and pasted they
are often meaning less ie referring to the wrong cells
 
D

Del Cotter

Rob said:
duplicate a table with the just values not formulas in the table so that I
don't have to readjust the formulas as when they are copied and pasted they
are often meaning less ie referring to the wrong cells
Click to expand...

a) it's in the manual, Copy, Paste Special, Values.
b) wrong newsgroup, this is microsoft.public.excel.charting. try
microsoft.public.excel.misc
 
Top