Macro that pulls data like vlookup but for multiple instances
Desperate to find help with this one. My excel is rusty and my macro writing ability is close to nil. Looking for someone who can lend me a hand, hopefully this isn't a tough one. Here's the scenario: have 3 sheets, 1st sheet is assets, 2nd sheet is liabilities, 3rd sheet I'm looking for the assets and liabilities to parse into it for the specific entity I type in (say in cell A1 of the third sheet). Let's say in case it's Coca-Cola; would love to be able to have the 3rd sheet pull in all instances of Coca-Cola and its entire row of data from the 1st and 2nd sheet (all entities are in column A in the 1st and 2nd sheet; Coca-Cola appears a few time in both the assets and liabilities sheets and would need all instances from both to be brought into the 3rd). So in the occurrence an asset or liability is removed or added, the 3rd sheet will pick up the update accordingly and will always match what's current on the other two sheets. I beg the excel macro guru's to please help with this one, would be greatly indebted.
Cheers.
Hello finance14,
Welcome to the Forum!
You should post a workbook that doesn't contain sensitive information, but mirrors the original workbook in every detail. Having the workbook will get you an answer faster and ensure that the solution is correct.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Solved in another section, my apologies if this was a double post.Originally Posted by Leith Ross
Last edited by finance14; 06-29-2011 at 12:39 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks