Importing and sorting data

[confusedbymacros]

Hi,

I am new to excel with little or no macro knowledge.

I have a problem, that someone may be able to help with.

Everyday I have to manually copy data from one spreadsheet to another.

In the master spreadsheet there are c.800 entries. in the secondary spread sheet this list of 800 has been filtered to 80 items.

In the 2nd sheet, the data is put in to the respective column by date.

Unfortunately I need to keep the list of 800 entries.

I'm looking for a quick way to import/sort/paste the data from one sheet to another.

Does this sound possible in excel and how do I do it?

If you need more info please ask,

Thanks,
Jim

[mudraker]

A good starting method is to record a macro whilst you do the import/sort/paste the data from one sheet to another.

Then if you need it tweaked post it in the programming forum (using code tags) and explain what changes are required