Copying data from one file to another

Closed
calgaryguy30 Posts 1 Registration date Thursday August 23, 2012 Status Member Last seen August 23, 2012 - Aug 23, 2012 at 04:29 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 15, 2012 at 07:24 AM
Hello,


My programming skills are a little weak so i require some help with the following:
I am trying to write a macro in excel 2010 to look up info from one file and then copy it to another. The problem i am having is that i need the macro to compare a column with a PO (purchase order) and then a column with an item number from one file and match it with a PO from one column and a item number from another column in another file. If those match I want it to copy a date from another column "ETA" into the ETA column in another spreadsheet. If the ETA column is blank, then i want it to disregard and move on.

Is there anyway you could help me?

Tony
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 15, 2012 at 07:24 AM
Could you post a sample book at some public file share site and post back link to the file back here.
0