Help with Import function, loop?

Hi everyone!

My work uses a excel spreadsheet to monitor our progress on the vehicles in the garage.

We are a big company and therefor we working in different cities but everyone is using the same spreadsheet.

When I make some changes on the sheet I have to ask everyone to email me there workbook so I can manually copy and paste the values to the new one and then send it back to them.
This usually takes alot of time and therefor I tought it would be a good idéa to add an import feature.

First I made it really easy for me and just made a code that copied all the sheets and removed the old ones.
But doing this means if i choose to add new content (that will be shown as a header in a listbox) then this will be removed once the import has been made.

So I made a small code, just to see if it worked, to copy each column instead and then paste and therefor not erasing any new content. But it's over 100 columns (several sheets) and the code will be gigantic if I just copy this and change the values.

What I'm looking for is some help to make this more dynamic. And search for criterias (in the old workbook) in the top row of each column and then copy the rows below to a column with the same criteria (in the new workbook).

I tried using the Find feature with no good results.

Please Login or Register  to view this content.

Hi mikeTRON

I found a solution to my problem. So it's working as intended now. I have a hidden sheet where I added the search criterias (for exampel, Brand, Number, Model). The macro is supposed to have two functions. This on, as posted below, replace everything with the new information.

The other function, is supposed to add the information on the last used row instead of replacing everything.

Please Login or Register  to view this content.