I apologize in advance if I am throwing too many things out at once. I understand what I need may be more than one macro and potentially one huge pain in the rear. If someone could help me understand just a portion of this I am going to call it a win.
Okay
What I am trying to do in essence is import,organize and add formulas to several different documents. I am pulling raw data into 5 different text documents. Now I can have the export use a colon or semicolon as a deliminator. OR I can have the information put into 5 different workbooks but I stayed away from that because I thought it would be slower. (I'm adding this info incase it makes a difference for the macro)
I need the data from these 5 sheets imported to one central Workbook preferably one tab for each document. Once in the central workbook I need to sort them into categories. Keeping in mind that there is some overlap between documents, Meaning that each document currently represents a location that handles different products and it is not uncommon for a single product to be handled by multiple locations. (Hopefully that's not too confusing)
For this portion I am not expecting someone to just hand me a script but more or less point me in the right direction as far as how to build a script that could sort that information.
Lastly once sorted I need a script that will update the information by half hour. In other words at 12:00pm I would like to run the macro and have all the current data for our clients sorted and set down the column and at 12:30 would use the next column and so on.
I do not have an issue with having to run the macro every half hour. However if there is a way to automate that as well it would be appreciated.
**Because I'm not sure if its relevant here is some information about the data I currently export.
Document 1: 11 Columns 398 Rows
Document 2 11 Columns 245 Rows
Document 3 11 Columns 25 Rows
Document 4 11 Columns 22 Rows
Document 5 11 Columns 50 Rows
Bookmarks