Hi
I have had a long break from working with Excel/formulas so hoping someone could be of assistance. I have included a test sheet as an example.
I would like to be able to pull information from the "pasted data" tab only if the "area" from B1 on the check tab is found in column H on the pasted data tab. If it is, then to pull the information required from pasted data(A, B, G, H) shown on the check tab. Ideally I would like to pull only ageing information too so only show if more than 0 days old.
Hope this makes sense.
Regards
Bookmarks