chadski778
Active Member
- Joined
- Mar 14, 2010
- Messages
- 297
Hi,
I carry out regular extracts from a database but a lot of the data is not required. I would like a macro that deletes all the rows between the following strings in my spreadsheet - 'Oilsafe Classification:' and 'Toxic Hazard Rating'; 'Our GHS Class:' and 'Regulatory Information'; 'ECN (Taiwan)' and 'REACh overall status'; 'REACh overall status' and 'Physical Properties'; 'Density at ambient' and 'Flash point (C)'; 'Flash point (C)' and 'WGK'; and every row containing data after 'WGK'
Is that possible?
I carry out regular extracts from a database but a lot of the data is not required. I would like a macro that deletes all the rows between the following strings in my spreadsheet - 'Oilsafe Classification:' and 'Toxic Hazard Rating'; 'Our GHS Class:' and 'Regulatory Information'; 'ECN (Taiwan)' and 'REACh overall status'; 'REACh overall status' and 'Physical Properties'; 'Density at ambient' and 'Flash point (C)'; 'Flash point (C)' and 'WGK'; and every row containing data after 'WGK'
Is that possible?