Forum Discussion
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 select ATM Id ( Any Id ) and whatever appears in this area ( Row number will differ ) I want it to be copied, reflected connected or even linked exactly the same in cell A5021.
Kindly note that there is a filter so the row number might differ even if it does I still want it to appear in A5021.
Any idea, please??
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.
8 Replies
- 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
