copy data

[Hong]

Hello,

I have a excel spreadsheet with lots of part# and date and Qty. call it
original data,

I have a list of part#, I am trying to write code to get the data from the
original data.

I am starting to learn how to write code for excel.

Please help me!

Thank you!

 

[Dave Peterson]

In code or using worksheet formulas?

In either case, it may be easier to populate the "receiving" worksheet with
formulas that retrieve the data from the "sending" workbook's worksheet.

Depending on how the data is laid out, you may be able to use =vlookup() or a
combination of =index(match()).

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble