Creating a mastersheet from sheets with unique ID

[RupertC]

I have a workbook where the three currency sheets are update daily. I need to create an consolidated report of all transactions on the PayPal Payments sheet. The format of the consolidated sheet cannot alter as it is an input file for bank reconciling. Nonetheless it should auto update.

I have tried several methods but seem to be missing something. I tried consolidate, using named and un-named ranges) but it seems to treat the id as numbers and I get odd results. I then tried Vlookup, but fail as I did not get the formula right for the second and third sheet (as I copied down the page the relative references incremented). I tried using an arrays, with no joy.

I cannot use a macro as I am using a mac and others who use the file are using PCs.

I have attached a snipit from a test file to show the issue and desired output.

Any help or pointers would be greatly appreciated.

Rupert

[dilipandey]

HI Rupert,

One of the quick option could be Pivot with consolidated range, see the attachment. thanks.

payments.zip

Regards,
DILIPandey

<click on below 'star' if this helps>

[RupertC]

Thank you so much for your response. I will go through it and let you know how it worked out. Thanks again