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
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
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:
- Copying data from one file to another
- Windows 10 iso file download 64-bit - Download - Windows
- Transfer data from one excel worksheet to another automatically - Guide
- Dvi file - Guide
- Tmobile data check - Guide
- Messenger file downloader - Guide
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
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.