duplicate table just values not formulas in the table

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Copy Charts/formulas will not adjust? 0
adding rows into the table 1
Copying charts with automatic change of data source 1
Delete Rows with Conditions 1
Excel Drag autofill only part of formula 3
Scrabble Value calculation for Welsh words 0
Conditional formatting 9

Top