Hi, I'm completely new here (found site while searching for a answer to my question, have not found a answer but this seems to be the best place to look for one).
I have a spreadsheet of products (27k of them!) that we are looking to use to generate a .csv file that will eventually populate a website however the data has been supplied with one issue, All the product descriptions are in separate .txt files.
the data is layed out as:
Supplier|Range|Description|Short Description|Picture File|Text File|
In the |Text file| field are file names for the descriptions (For example 34894.txt) (Description field should probably be called name really)
I'm looking for a solution that will let me run a macro over the sheet and populate a new column with the data from the .txt files.
Does anyone know a simple and effective way of achieving our goal?
Bookmarks