What is the best way to copy or extract columns from one sheet to another sheet?
My web site back end creates a transaction export csv file but it has 240 columns and I only need information from 10 columns. The back end does not allow column selection.
I created a new Excel file with three sheets. Summary, Filtered and Data. The CSV file will be updated and downloaded often with new data so number of rows will increase.
I imported the CSV file into the Data Sheet. From the Data Sheet I highlighted and copied each column I wanted to view and pasted the link into the Filtered Sheet. Then created a Summary sheet with totals etc.
The spreadsheet worked great except, the file size was over 115 MB. This file size caused a very slow start. I couldn't figure out the issue until I unfiltered the Filtered Sheet and had 1,048,576 rows and any unused cells had 0's. I deleted the rows with 0's and the file size was reduced to 2.6 MB. But, as soon as the CSV file was refreshed all the 0 rows returned. My CSV file does not have the additional rows with zero they only appear in my filtered sheet.
I receive suggestions from this site but was advised to resubmit my question since the issue seems to be how I copied each column and pasted the link from one sheet to another sheet.
I've tried many other steps but still stuck. Any help would be greatly appreciated.
Thank you