Copying multiple rows from different spreadsheet based on a logic

C

cshiva

Dear Friends, Need your help in the following :

Here is my requirement:

I have a worksheet which has columns 1,3,6,8. Which has few rows with a
unique values in column 1.

I get a spreadsheet everyday with columns 1,2,3,4,5,6,7,8,9,10.

I need to insert new rows with only columns 1,3,6,8.

I need a button using which I should be able to update. It would be
great if the macro gives me an option of selecting the file.

Thanks in advance.
 
D

Don Guillett

You might try hiding the undesired columns>f5 visible cells only>copy/paste.
Or a macro.
 
C

cshiva

Thanks Don. The requirement is to just add those which are new. Also,
note that I will be getting the spreadsheet every few hrs and would
like to avoid manual work.
 
D

Don Guillett

A macro could be written to easily do this and append or replace existing.
Try recording while doing it manually to get the idea.
 
Top