kirangb2000
New Member
- Joined
- Feb 16, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello All,
Mr. Excel has been a life saver for so many times but this time for some reason am unable to find the code I am looking for. I am sure it is available but unable to find it.
Usually I find codes, tinker them a bit and it works but this time unable to find the suitable code.
Thank you in advance, specially @fluff and @MyAswerIsThis, for so many codes you guys have given, has helped me.
I have 2 sheets, "Requirement" and "All data"
Requirement has multiple columns out of which 3 columns are of interest to us Cat # (A), Price(J), Tax(L)
All data sheet also has these three columns Cat # (A), Price(F), Tax(H)
So I want a macro to search Cat # from Requirement in All Data and then copy All Data F, H to Requirement J, L respectively.
Mr. Excel has been a life saver for so many times but this time for some reason am unable to find the code I am looking for. I am sure it is available but unable to find it.
Usually I find codes, tinker them a bit and it works but this time unable to find the suitable code.
Thank you in advance, specially @fluff and @MyAswerIsThis, for so many codes you guys have given, has helped me.
I have 2 sheets, "Requirement" and "All data"
Requirement has multiple columns out of which 3 columns are of interest to us Cat # (A), Price(J), Tax(L)
All data sheet also has these three columns Cat # (A), Price(F), Tax(H)
So I want a macro to search Cat # from Requirement in All Data and then copy All Data F, H to Requirement J, L respectively.
Last edited by a moderator: