I have come up with a problem at work that I am trying to solve. I have a Revit schedule that has been previously created export to a .txt file, which then can be imported into an excel file, this is pretty basic. The problem I am having is the excel file is also formatted to a standard format that we have to follow. So somehow I need this .txt file to come into the excel program and populate multiple tabs of information, in the appropriate cells that I need them in.

 

For example, the schedule I have is for interiors items in a building. The list is organized by Item number then from there will have a description, manufacturer, address...etc. Now in excel, I want to be able to export this to populate tabs created per item. So the excel files tabs represent an item number from that schedule I have. Within those tabs there will be much more information that the schedule provides but that will be typed by hand. So again the problem is being able to import that .txt to excel and have the information I want, populate the cells that I want, in the tabs that I want.

I think it has something to do with having an input sheet where the text file info goes,  and then somehow those cells can be reference between the item tabs that are created prior to the import. I've seen this done before and honestly it has been done already with this schedule so really this might be more of an excel problem. 

 

If someone is highly knowledgeable with Excel and would like to help out and take this on, I would highly appreciate it. If you would like the files I can provide them as well. Without having someone actually just do this for me I really just need to know how I can reference inputted data into EXACT locations on a pre-formatted excel tab (each tab would be its own interiors item), as well as performing this for multiple tabs (interiors items).