copy data from sheet 1 from 3 different workbooks from a folder

[srijith]

Hi All


need script for the below situation please help


1.I have two or more workbooks. i need to copy the data from sheet 1 from the 2 different books and copy to the master file.


2.The two excel workbooks have headers and they are common in both the file.once the data is copied to the masterfile there should be only one header ie: while copying it should check the last row and copy below that row with out the header from the second file.


3.clear the contents in column column b (ie check from the below table)


4.Remove duplicates from column 6(text) ( which has text) once duplicate is found in the 6th column(ie text) it should remove that complete row.


5.finally the file should automatically save with this extension test_20121018.csv in the folder and close the excel file.


sample data:


listid check update category product text

3426 wtuqwu simple compaq good

25626 ery wtuwu simple compaq bad

2626 qqu simple compaq good

 

[Luke M]

check out the Copy/Paste/Merge section here:

http://www.rondebruin.nl/tips.htm


Lot's of good examples on how to create different master sheets. You should be able to modify the code to get #1 and #2.

Step 3 is just a

Range("B:B").ClearContets

command.


For #4, try searching this forum for other threads about removing duplicates.


#5 you'll modify the code form Ron's site as desired.


You've got a lot of different things going on, but if you tackle them one at a time, you should be able to get everything.