asked on
Displaying content from one sheet in another when there is match??
Can anyone come up with a formula solution to populate the green colored tabs with the information from the GL Income tab in the attached document. The commonality is the numbers in row 4 of the gl income tab, you will see when they any of the numbers in row 1's of the green tab documents the numbers from Gl income document then display. Right now I am cutting and pasting these and it take a long time and I always manage to make a mistake or two when pasting.
test.xlsx
test.xlsx
Microsoft ExcelMicrosoft Office
Last Comment
Flyster
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If this is something you are doing on an ongoing basis, and the data is coming in the same way (where and how did you get the data on the primary tab?), then I am guessing the "gather and transform" the data is a good solution. Once you have set the process up once, assuming the data comes in the same way, the process is automated.
ASKER
Thanks for the help
Anytime! Glad I could be of assistance!