export selected data, without formulae

  • Thread starter Thread starter sales
  • Start date Start date
S

sales

I have a spread sheet with two worksheets, one containing the main
information the other with a discount percentage.
Once a month I need to export 9 columns of information for management in
CSV form.
Column 8 contains a formulae which relates to column 10 and worksheet 2
I need to show CSV report with data from column 8 but not from column 10
or worksheet 2.

HELP HOW do I do this...........
 
Create a new workbook.
copy your range from the first workbook
edit|paste special|values to the worksheet in that new workbook.
Save that new workbook as a .csv file
(then close without saving)
 
sales said:
I have a spread sheet with two worksheets, one containing the main
information the other with a discount percentage.
Once a month I need to export 9 columns of information for management in
CSV form.
Column 8 contains a formulae which relates to column 10 and worksheet 2
I need to show CSV report with data from column 8 but not from column 10
or worksheet 2.
Click to expand...

If you do this every month, you may prefer to create another .XLS workbook
containing a single worksheet, then select the data in the original workbook
that you want to appear in the CSV file, Edit > Copy, switch to the new
workbook, move to where you want the data to appear, then Edit > Paste
Special, and click the Paste Link button in the Paste Special dialog. Repeat
this process for other information in the original workbook that you want to
appear in the CSV file. When done copying linked data, save the new workbook
with a descriptive filename like MonthlyExtractToCSV.XLS. When you reopen
this the next month, it'll pull updated data from the original workbook.

When you open the new workbook and refrech the data, just save it as a CSV
file (with a different filename), then close it without saving it again.
 
Back
Top