Save As
 

I have a spreadsheet with 3 sheets. The first sheet contains original data.
The third sheets contains lookup data. The second sheet has formulas in
several rows that CONCATENATE data from several cells in sheet one into a
single cell in sheet two or have LOOKUP formulas that convert data from sheet
one based on a look-up in sheet three.

Question: Is it possible to export sheet two as a csv file without formulas
so only the replaced text strings show? If so, how?

Thanks, your help has been great with my previous two issues on this project.

Save As
 

You cannot save just one sheet.

Copy the cells to a new sheet in a new workbook.

Paste Special as Values.

Save that workbook as *.CSV


Gord Dibben MS Excel MVP

On Wed, 13 Aug 2008 15:52:00 -0700, Pat
wrote:

I have a spreadsheet with 3 sheets. The first sheet contains original data.
The third sheets contains lookup data. The second sheet has formulas in
several rows that CONCATENATE data from several cells in sheet one into a
single cell in sheet two or have LOOKUP formulas that convert data from sheet
one based on a look-up in sheet three.

Question: Is it possible to export sheet two as a csv file without formulas
so only the replaced text strings show? If so, how?

Thanks, your help has been great with my previous two issues on this project.

Save As
 

hi
what do you mean by export? just save as?
perhaps copy sheet 2 and paste as values in a new workbook then save the new
workbook as a cvs. you could ever automate the process if you need to do it
on a regular basis....
Sub PatSaveAsCVS()
Application.DisplayAlerts = fale
Sheets("sheet2").Activate
Cells.Copy
Workbooks.Add
ActiveSheet.Paste
ActiveWorkbook.SaveAs Filename:= _
"C:\Your\flie\path\PatSaveAsCVS.csv", FileFormat _
:=xlCSV, CreateBackup:=False
ActiveWindow.Close
Application.DisplayAlerts = True

End Sub

regards
FSt1

"Pat" wrote:

I have a spreadsheet with 3 sheets. The first sheet contains original data.
The third sheets contains lookup data. The second sheet has formulas in
several rows that CONCATENATE data from several cells in sheet one into a
single cell in sheet two or have LOOKUP formulas that convert data from sheet
one based on a look-up in sheet three.

Question: Is it possible to export sheet two as a csv file without formulas
so only the replaced text strings show? If so, how?

Thanks, your help has been great with my previous two issues on this project.