Log In
Register
Home
October 7, 2021
Offline
Hi,
I'm trying to find a way to delete a table's content (table created with the Ctrl+T), but not the table.
The only way I was able to accomplish it is by selecting everything but the header (or any column).
To avoid questions, I need it for the following scenarios: I need to compare weekly reports between themselves, but only the first 2 columns are constant, the rest of the columns might change place or even replaced by new column's content & header.
To solve it, I have workbook with 3 sheets, (CurrentWeek, LastWeek, TwoWeeks[ago]), and a 4th sheet which contains the formulas that compare these sheets using INDEX...MATCH.
Each week we copy the content of LastWeek to TwoWeeks, CurrentWeek to LastWeek, and current week's data into CurrentWeek, so the formulas in the 4th sheet will work regardless of data and columns.
Regards,
Ayal Telem.
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Have you considered using Power Query to load your data? You don't mention how your data is coming in to the workbook, other than you want to copy it from some source (current week's data) and paste it into a table and so forth.
And I don't see the need to copy the data to different sheets/tables, it can all fit in the same table and it makes it even easier to compare. You just need a date or week column that you can base on when comparing.
Br,
Anders
October 7, 2021
Offline
Dear Anders,
The data is coming from Google forms.
I can't use PQ, or paste everything in the same sheet since columns keep changing on a weekly basis.
Regards,
Ayal Telem.
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Check out the tip from Catalin in this post, it should help you to load data into Power Query regardless.
https://www.myonlinetraininghu.....der#p16593
Br,
Anders
October 7, 2021
Offline
Dear Anders,
It will not work since not only the header wording is different, but the content of the columns.
you can have new columns compare to last weeks, and some columns might not appear at all.
Regrads,
Ayal Telem.
Trusted Members
October 17, 2018
Offline
My Online Training hub has most of the answers and works all the time.
Long before I found this site I found the spreadsheet Guru with some great tutorials and code.
The VBA Guide To ListObject Excel Tables (thespreadsheetguru.com)
It's a great place to understand the working or tables, deleting resizing etc etc.
1 Guest(s)
