Hi Guys!
I have a Table of data:
Headers - DATE(A1), VENUE(B1), TIME(C1)
I then Filter the data and Sort thus returning the Cell Values i require to work with.
Im trying to get the Visible cells only after Filtering and Sorting to display in another table where by the Cell References of the visible cells are moved to the top of the other table.
How can i achieve this??
Any help appreciated guys, thanks!
Hi,
A macro that copied the Visible cells with the
Formula:
Please Login or Register to view this content.
is probably the easiest.
There's no standard Excel function that will return the height of a row which would be one way of establishing whether a row is visible or not (although oddly one of the CELL parameters does allows a column width to be returned). There's an old Excel 4 GET.CELL sheet "macro" which will return the height of a row but even then once you know a row height it will probably need some complicated array formula to be able to use it to generate a list of only those visible values.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard!
Sorry for late acknowledgment. Yes! Exactly what i did after scouring the Inter Web
Good to have this confirmed though!.. Thank you for taking the time. Appreciate your effort!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks