Importing data from worksheet to be copied in another workbook

**klowjet** · 12-08-2010, 06:43 AM

Hi All,

I have a problem in creating a userform that will import specific data of a worksheet to the main worksheet. The main worksheet will have the userform for importing/updating.
The macro will only import or update if the file to be copied have the same column headers of the main worksheet.

Can you please help on how to generate the codes.

I will appreciate it a lot.

I attached the main worksheet for your reference.

**klowjet** · 12-09-2010, 04:11 AM

Can you please help me on how to do this?

**JBeaucaire** · 12-09-2010, 04:37 AM

So, how about some of those worksheets with data that's supposed to be transferred to the main sheet, some sheets with data that ISN'T supposed to transfer, an explanation of when this transfer is supposed to occur (what starts it?), what's supposed to happen with data already in the main sheet when you start each time anew....

**klowjet** · 12-09-2010, 07:18 AM

Actually, The main worksheet should have a userform for importing worksheet.When the userform imports the data from another worksheet, it will match the columns from the main worksheet to the another worksheet and if not met the criteria, it will not import the data. The other worksheet should only have one sheet that contains the data.
The data that already in the main sheet should update the data and if encounters duplicate data, it will not copy the data, it will copy only data that still not yet copied.'

I hope you get it.

thanks.

**klowjet** · 12-13-2010, 01:59 AM

Can someone help on how to do please.

**JBeaucaire** · 12-13-2010, 10:49 AM

Originally Posted by JBeaucaire

So, how about some of those worksheets with data that's supposed to be transferred to the main sheet, some sheets with data that ISN'T supposed to transfer, an explanation of when this transfer is supposed to occur (what starts it?), what's supposed to happen with data already in the main sheet when you start each time anew....

I was expecting some more usable responses to these questions along with a more fully data-inclusive example.