Hello,
I would like to copy cell values from Datawrksht to other worksheets by
clicking one button.
Like this:
Select A1 from Datawrksht and copy the value (not the formating) to cell C9
on Worksheet1, then select B1 from Datawrksht and copy the value to cell c10
in Worksheet2, Now, I will have to repeat this over and over later to select
many other cells that have to be copied to different sheets.
Here is the complication, once it is done copying and pasting, I would like
it to Delete Datawrksht and to open up the SAVE AS dialog box so that I can
save this as a new file.

Regards

Memphis