Extracting data from one XL worksheet to another.

Mar 6th, 2002, 10:02 AM

Hi .. I hope someone can help...I have a user with a problem.He needs to be able to extract various rows of data that meet a criterion (e.g - stock id's that contain a certain number as part of the id make-up)and copy or link that data into another separate XL file. The originl file that the data is found in will be updated monthly, so it cannot have an absolute reference to a specific cell, etc.... any help greatly appreciate!!

THANKS,
Laura

lenze · Mar 6th, 2002, 12:01 PM

Have you looked at using MS Query?

karraj · Mar 6th, 2002, 12:21 PM

Try using hlookup or vlookup after opening the file from which you want to extract.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 10:02 AM	#1
Guest Posts: n/a	Hi .. I hope someone can help...I have a user with a problem.He needs to be able to extract various rows of data that meet a criterion (e.g - stock id's that contain a certain number as part of the id make-up)and copy or link that data into another separate XL file. The originl file that the data is found in will be updated monthly, so it cannot have an absolute reference to a specific cell, etc.... any help greatly appreciate!! THANKS, Laura

Mar 6th, 2002, 12:01 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Have you looked at using MS Query?

Mar 6th, 2002, 12:21 PM	#3
karraj Board Regular Join Date: Mar 2002 Posts: 76	Try using hlookup or vlookup after opening the file from which you want to extract.