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
How to update a value from a linked worksheet back to the master worksheet? 0
How to update data from linked worksheet back to a master worksheet? 0
Extracting data from Multiple columns to a Single row 3
MATCH OR VLOOKUP 3
Macro to copy formula based on range of other column 2
correlating and summing data from multiple spreadsheets 1
Auto Input Today's Date 3

Top