About Us

I would like to have two tabs in Excel. The first one has a large generic
list of products. I would like to put a qty number before just the products
I will need and have it create another list with just the products with qtys
in front of them. I know it can be done but how??

Why not just filter on 'not blank'?
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".

"Rob" wrote:

I would like to have two tabs in Excel. The first one has a large generic
list of products. I would like to put a qty number before just the products
I will need and have it create another list with just the products with qtys
in front of them. I know it can be done but how??

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create a Sub validation list in excel?	Simon	Excel Discussion (Misc queries)	1	July 13th 05 10:31 AM
i want to create a simple mailing list can u help	Gary Brown	Excel Worksheet Functions	0	May 18th 05 05:25 PM
Create a cascading list box using Excel	JPB	Excel Discussion (Misc queries)	1	February 24th 05 08:43 PM
How to create a macro that compares a list to another list	Rampa	New Users to Excel	1	January 13th 05 01:15 PM
create a drop down list with the source from a different workbook	Sampath	Excel Discussion (Misc queries)	2	January 8th 05 07:57 PM

Menu

About Us