Forum Discussion
Solved
Excel Function
Hi Everyone, Hope everyone doing alright, Appreciate your advice and support with this one, As I have a sheet containing 5020 rows and all in filter mode so in the picture I want whenever I sel...
Here is a version that doesn't require the FILTER function. You do need the dummy formula; it forces Excel to recalculate, triggering the code. You can hide the cell with the formula if you like.
Any Ideas, Please?
I don't know about others, but I don't understand your question. Could you try to explain it as clearly as you can?
HansVogelaar Once I select ATM id from the filter I want the data from the red box above to be copied the same in the red box below in cells A5021& B5021.
What appears up I want it to appear below
Here is a sample workbook. It is a macro-enabled workbook, so you'll have to allow macros.