I'd like an opinion on the best way to do this:
I have a worksheet with 60 columns of raw data. I want to be able to take only certain columns from that sheet and display them into worksheet 2. I just used the "=" formula to replicate what was in the first worksheet to the second one on my first attempt.
Here's my dilemma. When the necessary data is populated in worksheet 2, I need to filter that by the headers which then forces the "=" formula to get rearranged. So whatever was looking for cell A4 on sheet 1 is now in a totally different location after filtering. But in the same column at least. Skip ahead to a new week with additional data. Once I add the new raw data, worksheet 2 needs to display the raw data from sheet 1 as it appears in sheet 1 as if no filtering took place. Eventually that will be filtered but is there a way to return a filtered spreadsheet back to pre-filtered status after it's been saved and closed out of?
Would there be a VBA macro that would make replicating and filtering data over and over any easier? Doing this on my phone and work stations are locked down so I can't access this site to upload a sample.
Any help would be greatly appreciated.
I have a worksheet with 60 columns of raw data. I want to be able to take only certain columns from that sheet and display them into worksheet 2. I just used the "=" formula to replicate what was in the first worksheet to the second one on my first attempt.
Here's my dilemma. When the necessary data is populated in worksheet 2, I need to filter that by the headers which then forces the "=" formula to get rearranged. So whatever was looking for cell A4 on sheet 1 is now in a totally different location after filtering. But in the same column at least. Skip ahead to a new week with additional data. Once I add the new raw data, worksheet 2 needs to display the raw data from sheet 1 as it appears in sheet 1 as if no filtering took place. Eventually that will be filtered but is there a way to return a filtered spreadsheet back to pre-filtered status after it's been saved and closed out of?
Would there be a VBA macro that would make replicating and filtering data over and over any easier? Doing this on my phone and work stations are locked down so I can't access this site to upload a sample.
Any help would be greatly appreciated.