Hi, I am trying to set a macro to select visible cells in certain columns of a table after I filter the table.
The table header is in row 10 (the columns are E, I & O). Sheet Name: MedComp Sheet Number: Sheet30 Table Name: TBL_MedComp
How can I select then copy only the visible cells in these columns after the table data has been filtered and displays only the data entries I am concerned with?
Any help would be appreciated.
I can deidentify and simplify my workbook but it will take a lot of time so I tried to provide details above that do not need an example workbook to run off. I am sure this is adaptable for any sheet and table.
Thank you.
Bookmarks