Extracting data from a worksheet based on a range of in a column.

B

banderson

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
 
D

Dave Peterson

You have a suggestion at one of your other first posts (in worksheet.functions)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a column of data from 1 worksheet to extract data from another worksheet 2
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Help With MS Access 4
Pivot Page field filter based on cell value 3
extracting multiple rows of data from another worksheet 1
correlating and summing data from multiple spreadsheets 1
Auto Input Today's Date 3
VBA - retrieve data on last create named range from previous inserted named range 0

Top