Lookup value from many sheets and create a summary page

[shanan]

Hi,

I'm in the midst of figuring out how to create a summary page by consolidating the amount from each sheet (invoice.xlsx) to as a summary in InvoiceSummary.xlsx. attached example of workbook.

1)User will keep adding the sheet based based on our customer requirements.
2)Each sheet will have one invoice number and one amount only.

Please help. Thank you.

 

[Nebu]

Hi:

I guess you need a macro for this , Is the invoice tab layout consistent across?

Thanks

 

[shanan]

Hi Nebu,

Thanks for your prompt reply. oh we need a vba for this.can help me to go about it? yes it is a consistent across the sheet.

 

[Nebu]

Hi:

Find the attached, click on the button it will consolidate info from the sheets.

Thanks

 

[shanan]

Hi,

Perfect. can i ask for slight amendment?

as and when there is a new sheet - add the new sheet information (right now it's adding all the information again in different row. so we might have repetition of invoice number and amount whenever we click consolidate.

Thank you

 

[Nebu]

Hi:

Find the attached, I have fixed it.

Thanks

 

[shanan]

Hi,

Thank you. It's working well now. Appreciate it