How can you add a row and insert data based on text value?

July 30, 2014 at 22:40:40
Specs: Windows 8
Hi there, hope you can help me with this problem in creating VBA in excel 2013. I need to add a row based on a text value in a cell. I also need to add values to that added cell based on the cell next to the text value.
Sample: ( CPU/W being the text value ).
A B C D E
CPU/W 828422A 1 0265 1
2146 1
4876 2

so it will be

CPU/W 828422A 1 0265 1
0265 1
2146 1
4876 2

until the end of column A

really would appreciate your help

message edited by edgister


See More: How can you add a row and insert data based on text value?

Report •

#1
July 31, 2014 at 04:23:57
Please click on the link at the bottom of this post and can read the instructions on how to post data in this forum so that the column format is retained. It may take some trial and error via the Preview Follow Up button, as explained in the instructions, but it can be done.

Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question