I get sent a large spreadsheet each week my problem is I only need a two bits of it. What ideally I would like is through VB be able to serach for the info and place this in sheet 2.
The added complication is that it may be three lines or up to 20 lines each section is named so I would search for 'Parcels' in column E then select the data in the following rows until the is a clear line then copy this into sheet 2. And do the same for my next piece of data named 'Changes' again in column E
Is this:-
A) Possible
B) Practical
Any hints or help would be welcome thanks.
The added complication is that it may be three lines or up to 20 lines each section is named so I would search for 'Parcels' in column E then select the data in the following rows until the is a clear line then copy this into sheet 2. And do the same for my next piece of data named 'Changes' again in column E
Is this:-
A) Possible
B) Practical
Any hints or help would be welcome thanks.