Thanks again for your help
So here is the breakdown.......
I have a .txt file that I import into Excel that was original generated by information in AutoCAD and I read and write to this txt file from the Excel workbook. The record no. is what I am using to "link" files from one sheet to another. So both the "Import_file" and the "Mast Inst List" both have this record number listed in the "B" column of their sheets. I had 2 macros that I was using, one for moving info from the "Import_file" to the "Master Inst List" and another for moving the information from "Master Inst List" to the "Import_File". I was having an issue with needing to replace that formula in column "H" of the "Master Inst List" after I ran the macro to move information into the "Master Inst List". The macro that you shared with me (thanks again!) I am now using to move info from the "Import_File" to the "Master Inst List" and it is great! Now I am having issues with the macro I have for moving information from the "Master Inst List" to the "Import File". It seems to work for the most part but for somereason it will randomly leave certain record numbers out of the transfer and I cannot figure out why. That is why I was hoping to use that code you shared just in reverse (from "Master Inst List" to "Import_file"). I have been told to use VLOOKUP() but I cannot have code in the "Import_file" because I have to import that information back into AutoCAD.
This is the code I am using to move files from "Master Inst List" to "Import File", but I would like to use something similar to what you shared with me...... It seems to work better!
Bookmarks