Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy Blocks Of Data
Hi I'm working on an excel database at the moment and have come up against a roadblock... I'm at the point where I have got Excel to sort all the data for me (HLOOKUP) into the correct categories and now I just want to record a 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 an entry) and place it into the database spreadsheet at the end of the last block. So each time I process (sort) a new block of data it pastes it after the previous lot... Nick -- SenojNW ------------------------------------------------------------------------ SenojNW's Profile: http://www.excelforum.com/member.php...o&userid=25958 View this thread: http://www.excelforum.com/showthread...hreadid=393864 |
#2
|
|||
|
|||
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. -- Earl Kiosterud www.smokeylake.com "SenojNW" wrote in message ... Hi I'm working on an excel database at the moment and have come up against a roadblock... I'm at the point where I have got Excel to sort all the data for me (HLOOKUP) into the correct categories and now I just want to record a 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 an entry) and place it into the database spreadsheet at the end of the last block. So each time I process (sort) a new block of data it pastes it after the previous lot... Nick -- SenojNW ------------------------------------------------------------------------ SenojNW's Profile: http://www.excelforum.com/member.php...o&userid=25958 View this thread: http://www.excelforum.com/showthread...hreadid=393864 |
#3
|
|||
|
|||
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... -- SenojNW ------------------------------------------------------------------------ SenojNW's Profile: http://www.excelforum.com/member.php...o&userid=25958 View this thread: http://www.excelforum.com/showthread...hreadid=393864 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge cell & Copy Data from different cell | Excel Discussion (Misc queries) | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) |