Apologies if this question has been asked/resolved previously, but I'm trying to perform an audit of ~1000 values in a single worksheet by comparing them to the same values spread across several (126) worksheets in another workbook. Also, the values are listed vertically in the single worksheet and horizontally in the workbook. I tried using the "Get and Transform" function, but unfortunately, I'm not that well versed in Excel. Thank you in advance for your assistance.
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks