I am trying to update one Excel spreadsheet from another. For a variety of reasons, I do not think linking will work. I need help writing VBA code to execute the project.
Two files are involved, but they have been combined into the single file that I can upload.
Ref A contains a Macro6 that functions the way I want it to, except that I cannot write the following code:
1. I need to start at cell A2 in Ref B and search Column A in Ref A for a like number.
2. Once the like number is found, copy columns B, C, and D from Ref B and paste them as a value into like columns in Ref A on the row with the found (identical) number.
3. If no matching number is found, create a new row in Ref A and paste columns A, B, C, and D from Ref B into A, highlighting those pasted cells with a yellow background or red font, etc.
4. Finally, starting at cell A7 in Ref A, search Column A in reference B for a like number - only numbers, not text. If no like number is found, delete the row in question in Ref A.
Finally, it appears the the spreadsheet is in the form of a GIF file. If so, you cannot see the Macro6 code. In any case, the Macro6 code includes eliminating a number of columns from the original Ref B. I have manually done this for the uploaded file so as to keep under the max file size limit.
I wish I could write this stuff. Ten years ago I probably could have.
Thank you in advance for any help you can give me.
Dick Frederick
Attachment 10863