Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a column of data from 1 worksheet to extract data from another worksheet
Alright,
This is my first post to the group!! Here is what I have to get it started: Worksheet(Manuf#) 26025 records (Product#, Description,Buyline, Manuf#) Worksheet(Products) various amount of product ID's in column A(only column of data), this all I want to have in this worksheet, just the list of products I want to find from Manuf#. So what I need is a macro, Module, whatever it will take so I can look at the Products in Worksheet(Products) and extract just those Records from Worksheet(Manuf#) into a new Worksheet named Results? Any help at this time would be greatly appreciated. What i have so far is a Input box so I can input the product I want and it will create a new Worksheet with that one product, but each time I do the Input it creates a new Worksheet. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a column of data from 1 worksheet to extract data from anotherworksheet
I find it easier to keep all my data on one worksheet.
If you do that, you can select your range and do Data|filter|autofilter. Then you can use the dropdown arrows to choose what you want to see. If you really need to put that info on another sheet, you could copy and paste the visible rows. (and if you need a macro, record one when you do it manually) " wrote: Alright, This is my first post to the group!! Here is what I have to get it started: Worksheet(Manuf#) 26025 records (Product#, Description,Buyline, Manuf#) Worksheet(Products) various amount of product ID's in column A(only column of data), this all I want to have in this worksheet, just the list of products I want to find from Manuf#. So what I need is a macro, Module, whatever it will take so I can look at the Products in Worksheet(Products) and extract just those Records from Worksheet(Manuf#) into a new Worksheet named Results? Any help at this time would be greatly appreciated. What i have so far is a Input box so I can input the product I want and it will create a new Worksheet with that one product, but each time I do the Input it creates a new Worksheet. Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a column of data from 1 worksheet to extract data from another worksheet
The only problem is the data in the second worksheet is always changing
with the products so it's not static data. That is why I have to have it on a different sheet so when it downloads it can upload the current products I need to find. I think the Filter would work but if I have 100 product items on my worksheet to look up, how is the filter going to accomplish that task? Thanks Brett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |