Excel to excel import - values have drop down list

[MP1989]

Hi,

I have a VBA that imports information from one excel document into another master excel document. I have a form that is filled in, then I collect them and place them in a folder, then import them into a master spread sheet at the touch of a button (thanks to someone's previous work on here).

However for some reason the line that is copied into the master workbook has a drop down box on all columns (see image). I have a few charts etc. looking at the information gathered and for some reason it cant interpret the data due to the format that it has been copied in (I assume). One field is a date and this is not copied in a date format (the source data is a date format).

I have done some testing and found that this seems to occur because the data in the master spread sheet is in a table. The imported data is added to the next row of the table.

I use information from this sheet for mail merge so have made the table as the first few rows are not the headers of the table. I tried to remove the table and use a data filter but when I do this not of the data appears in the mail merge document.

I would be grateful if anybody could help me with this as I currently have to copy all the rows inserted and then paste them as values and then go through and edit the dates which defeats the point a bit.

This is the code;

Please Login or Register  to view this content.

[Mumps1]

Can you post a copy of your file? Rather than trying to interpret your macro, could you please explain in words, referring to specific cells, rows, columns and sheets exactly what you want to do?