Combining two spreadsheets - Marking what cells have been pulled over

[thoham]

Hi there,

I have resorted to this help forum to see if there was a way to get what I wanted. A little background, I am trying to match CC deposit batch transactions to daily sales transactions. I have two reports, one from our credit card processor/gateway (Report "B") and one from our software where the daily sales (Report "A") are recorded. I used the INDEX/MATCH formula to pull the information I needed from Report "A" into Report "B". It worked perfectly. My question is, is there anyway that I can show what information has been pulled from Report "A"? Possibly by highlighting what was pulled over? It is a longshot, but it would make my life so much easier if it was possible...

You help is appreciated.

[FDibbins]

Hi and welcome to the forum

I am probably missing something here, but if you want to see what was pulled in, couldnt you just look at the index/match formulas to see that?