specific records in Excel

New Contributor

I have a business in which I need to locate specific records (around 80-100) from a large database (20,000) have them sent to another workbook make some updates and then return them to the main database. It is necessary that the 80-100 records be grouped together as the changes are relative within the group.

2 Replies


Should be possible to filter the 80 - 100 records within the worksheet and make some updates and then remove the filter.

will try it thnx for the reply