Copying multiple rows from different spreadsheet based on a logic

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cshiva@gmail.com - 23 Dec 2006 13:58 GMT

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.

Reply to this Message

Don Guillett - 23 Dec 2006 14:37 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Dear Friends, Need your help in the following :
>
[quoted text clipped - 11 lines]
>
> Thanks in advance.

Reply to this Message

cshiva@gmail.com - 23 Dec 2006 15:23 GMT

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.

> You might try hiding the undesired columns>f5 visible cells only>copy/paste.
> Or a macro.
[quoted text clipped - 18 lines]
> >
> > Thanks in advance.

Reply to this Message

Don Guillett - 23 Dec 2006 15:58 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> 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
[quoted text clipped - 23 lines]
>> >
>> > Thanks in advance.

Reply to this Message