Thread: look up a set of values,copy a range of data into 2nd file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
new_to_vba[_8_] new_to_vba[_8_] is offline
external usenet poster
  
Posts: 1
Default look up a set of values,copy a range of data into 2nd file

i have 2 files, Information & 822,
i need to check for all the data that contain the texts "IT" in 822,
and copy the specific range of data(such as A9,F9,J9,L9) into another
file called Information.

this seems impossible, i tried my best but i still can't get it done..


--
new_to_vba
------------------------------------------------------------------------
new_to_vba's Profile: http://www.excelforum.com/member.php...o&userid=30131
View this thread: http://www.excelforum.com/showthread...hreadid=509271

Reply With QuoteReply With Quote