I am trying to take the Item Number value and have that automatically be copied into the same column but in between the Project Number and Item Description column. I need the Item Number value to be copied until a new Item Number is reached.
For example (see attached document): 20100000 needs to be copied to cells B5:B7 and then when a new Item Number is reached (20100001) that needs to be copied to cells B14:B16 until the new Item Number (20100005) is reached and copied to cells B22:B23.
My actual document is large so I cant just copy and drag each Item Number
Thanks
Bookmarks