Copy down

I

Ivor Williams

I've imported a spreadsheet, some sample data is below. I would like to
create a macro or some code to:
1. If there is a value in column F, delete the row.
2. If a 5 digit string is followed by a 12 character alphanumeric
string, replace the 12 character string with the 5 digit string ahead of it
3. If there is no value in column B, delete the row.

In the first sample below,
1. Row 3 would be deleted, all rows below it would move up.
2. The value in what is now A3 (01559) would be copied down until
the next 5 digit only string is encountered in column A. The next 5 digit
string would be left unchanged, but would be copied down until the next. So
on until the end of the sheet.
3. Row A3 and all like it would be deleted.

This should leave a sheet that looks like the second sample.
Please help if you can.

Ivor



A B C D
E F G H I
00020 Sof 992 24 Jan 2005 No ETA Not Received 2/501
Vanc Wh No Type OK
00020 Sof 992 24 Jan 2005 No ETA Not Received 1/501 Vanc Wh No Type
OK
Total 169
01559
VAAB20050105 Sof 951 05 Jan 2005 No ETA Not Received 2/75 Vanc Wh No
Type OK
VAAB20050105 Sof 951 05 Jan 2005 No ETA Not Received 1/75 Vanc Wh No
Type OK
VAAB20050105 Sof 951 05 Jan 2005 No ETA Not Received 1/75 Vanc Wh No
Type OK


A B C D E
F G H I
I
00020 Sof 992 24 Jan 2005 No ETA Not Received 2/501 Vanc Wh No Type
OK
00020 Sof 992 24 Jan 2005 No ETA Not Received 1/501 Vanc Wh No Type
OK
01559 Sof 951 05 Jan 2005 No ETA Not Received 2/75 Vanc Wh No Type OK
01559 Sof 951 05 Jan 2005 No ETA Not Received 1/75 Vanc Wh No Type OK
01559 Sof 951 05 Jan 2005 No ETA Not Received 1/75 Vanc Wh No Type OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top