shakethingsup
Board Regular
- Joined
- May 21, 2017
- Messages
- 64
- Office Version
- 365
- Platform
- Windows
I have a workbook in which I will have multiple tabs.
Tab 1 looks like this. Let's call this Tab - ALL. The common thread is the group name:
I will create a second tab called "cash" and have a A1 also be called "cash"
I want to then prepopulate this second tab with all accounts, descriptions and amounts that match "cash"
I will then do that for AR, Prepaid and so forth.
My current solution in the cash tab:
=IF($A$1='All'!$A1,'All'!B2)
This pulls in 1110. I just copy the formula into the next cell and so forth and it pulls in the description and amount. I can drag it down. When it doesn't find a match, it outputs FALSE and I know to stop.
Any other way to do this?
Thank you
Tab 1 looks like this. Let's call this Tab - ALL. The common thread is the group name:
![zwgjPop.png](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FzwgjPop.png&hash=aebd2f57821ab92c824663596e83411b)
I will create a second tab called "cash" and have a A1 also be called "cash"
I want to then prepopulate this second tab with all accounts, descriptions and amounts that match "cash"
I will then do that for AR, Prepaid and so forth.
My current solution in the cash tab:
=IF($A$1='All'!$A1,'All'!B2)
This pulls in 1110. I just copy the formula into the next cell and so forth and it pulls in the description and amount. I can drag it down. When it doesn't find a match, it outputs FALSE and I know to stop.
Any other way to do this?
Thank you