Excel Help

[Zia Khalid]

Dear Members - I have one daily production sheet and each sheet is same only amount and quantities are different, each cell are in same place throughout the sheet.

I want to make a summary sheet for each day and want to bring data from each day to summary sheet. I don't want to do it manually.

I want each product planned and output quantity to be fetched from each sheet when I dragged the formula.

Totally stuck. Need help.

 

[Georgiboy]

Are you able to download the XL2BB add in from this site and display the layout of your data?

XL2BB - Excel Range to BBCode