Copy Blocks Of Data

S

SenojNW

Hi
I'm working on an excel database at the moment and have come up agains
a roadblock...

I'm at the point where I have got Excel to sort all the data for m
(HLOOKUP) into the correct categories and now I just want to record
macro to copy it over in blocks to the database sheet.

So...

What I need it to do is take a whole block of data (each row is a
entry) and place it into the database spreadsheet at the end of th
last block. So each time I process (sort) a new block of data it paste
it after the previous lot...

Nic
 
E

Earl Kiosterud

Nick,

Normally, the records are added to the bottom of the main list, then it's
sorted. Done. If you need your records in some other order, sort it on
that column.
 
S

SenojNW

Its the pasting new entries in at the end of the list that is a problem
- I can do it manually but want to run a macro to do it...
 
Top