Summary worksheet

[Leonora Bayona]

Hi Sir,

I'm trying to use VBA to summarize the purchase order, But not able to do it.
Please help me.
Each worksheet have more than 5 tabs
Each tabs have at least 10 to 20 items.
I would like to have the following data in summary within the worksheet.

Dept:Deliver on:Sheet NameTo.O No.:QtyUoMDescriptionU.P.Total

 

[vletm]

There were some challenges with links ( but no problem! ) and
one of tab was different than others.
If 'basic tabs' are different, it needs to make some modifications.
Something like that?
You could use .xlsm -version if possible.
Ask, if You have any questions, Okay?

 

[Leonora Bayona]

Hi Vletm,

Thank for your reply.
Its my first time to use the VBA, please help me to understand.
I would like to ask if I need to do the same thing in different worksheet having more than 10tabs, should I copy the VBA? Or just open the file and click the icon of run?

 

[Leonora Bayona]

Hi,

I tried to use the same in other worksheet but the summary did not finish till the end. Please help me to check.

 

[vletm]

Oh no! That was my mistake. I didn't test so far. Sorry.
I fixed that feature (You can compare difference) and ...
I find few more things too.
There are some hidden tabs too, which made 'challenge' before I fixed that.
The name of worksheet should be like I use. If it's .xlsx, there could be 'challenges'.
You should copy that 'Sub' to VBA to that file You're using.
It's possible to run from another file too, but then You have to be very careful.
Please test this version.

 

[Leonora Bayona]

Thank you so much it save my time.
I tried insert another info. in the summary, but it doesn't change even I amend in the sub. what should I do. Let's say in column J of each worksheet I need to include it also.

 

[vletm]

Hmm ... that macro do 'almost only' I have written.
It's sensitive to changes. If You change 'something' on one ore more tabs, like 'just move everything one cell to right' ... the 'summary' result can be unwanted.
I didn't make this so so 'perfect' easy to use.
It's possible to modify.
Do You mean 'J7'-cell value or every possible visible values from J-column?
What kind of 'summary-tab'-layout, You have planned?

 

[Leonora Bayona]

The summary lay-out is good already, just need to add the J7 cell value in column which will be my invoice number. Thanks

 

[vletm]

I added 'Invoice #:' to 'summary' and 'totals' to 'P'-col.
... and something that You could think to accept too?

 

[Leonora Bayona]

Its so great. Thank you so much