Save As

[Pat]

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.

 

[Gord Dibben]

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

 

[FSt1]

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