Summarize 3 Tabs into 1

[JNimports]

Hi all

I have a customer order form spreadsheet with 3 existing tabs, each tab has a different product range and there are rows for each different product with columns for price, description, SKU and quantity ordered.

I need some help please with what formula to use so that on a new fourth tab I create a list of any products which have been ordered and their quantities which feeds from the other 3 tabs. So it would only show product rows which have had quantities entered.

The idea is that the fourth tab would be printable for our warehouse to pick.

Thanks!

 

[sriche01]

There are ways to craft it so that lines are added or deleted automatically based on Items that have a quantity ordered. That gets tricky, plus if you wanted any static info on the lines they wouldn't necessarily float with the data. What I did for a pick list is have a tab with every product we sell on it, then have a column that looks up quantities ordered by customer. Then you can filter that list for positive numbers in the quantity ordered column.

But it would help to have a sample.

 

[JNimports]

Thanks for your reply, I thought what I had been asked to do sounded a bit complicated! Your idea should work so I will give that a go

 

[sriche01]

Great!

 

[JNimports]

Hi sriche01

I've created the tab as you described, using vlookups for the quantities from the other tabs. I've applied a filter for greater than 0 but I want this to auto-update. I've had no luck pasting vba codes I found, none of them actually update the filter. Hoping you might have some advice! Thanks

 

[sriche01]

To be clear, so you mean you want the filter to reapply automatically every time a change is made in the other tabs?

 

[JNimports]

Correct, yes.

 

[sriche01]

Unfortunately, automatically reapplying the filter is VBA which I am not particularly good at. In my application, when the data changes I just hit reapply on the filter.