Hi, i need a macro to insert a blank line between rows that are different on column 2.
Example Data...
Col 1 Col 2
12345 A
12346 A
12234 A
34534 B
52323 C
23455 C
23455 C
23542 C
Needs to look like
Col 1 Col 2
12345 A
12346 A
12234 A
34534 B...
Hi, is there a macro to move rows to the top of a worksheet that have certain chars like dashes, perods, commas etc. and change the font colour to red?
Many thanks,
Jim
Hi, i have an excel document which can be 1000's of rows long with the following example values in it...
Item Code QTY
0200109002/009/026/072/202 1
0200109074/012/014 23
200109047 22
0.20.0109262 (red) 21...
Hi, i have an excel document which can be 1000's of rows long with the following example values in it...
Item Code QTY
0200109002/009/026/072/202 1
0200109074/012/014 23
200109047 22
0.20.0109262 (red) 21...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.