Replicating data from one sheet to another without extracting Formula

[sneakyla]

Hello!

I don't know if such feature exist but I'm currently using a sheet to create a large list of data and importing it into a system to be read by column.

I've created an automated data sheet that I can easily use by copy and pasting a few steps. However, the main sheet that the system reads data from is collecting formula as a result instead of the value it presents. So my work around this is to just manually copy + special paste to another sheet without formula.

My question is, is there a way to have all the data in one sheet moved to another sheet without any formula inside automatically?

Thank you!

 

[ekrause]

Yes, you can do this with VBA. This code will copy the data from a completed worksheet to a new workbook as Values Only

Sub CopyWorksheet()

ActiveSheet.Copy
Range(Range("A1"), Range("A1").SpecialCells(xlCellTypeLastCell)).Copy
Range("A1").PasteSpecial xlPasteValues

End Sub