Greetings my friends!
I've been disabled for 5 years, part of my disability is short term memory. The reason I tell you this is so you will understand IF this question is redundant. I have looked at the forums and haven't seen the answer I seek. I also may not have described what I need accurately. Please be patient and ask if I am missing information. I'm trying to start a catalog business to help my meager disability income, lol.
I am very grateful for any help that I can get. Thank you in advance.
Now to the problem;
I have a list of inventory which will be updated regularly. I have to "clean up" column B for printing catalogs and need some of the information moved to the next adjacent cells.
I have in the second cell of the document (In this case, cell "B-2") below my heading, the product names, count per, and the majority of them have a weight. For example, it might have, "Snicker bars 25/8oz" I do have a few that have a space after the "8" but not enough to worry about, for those I can manually check them after and adjust accordingly. The description in column "B" can vary in the number of words to describe the product so a count of words from left to right won't work. For example, it could have in the cell below it, "Doritos cool ranch flavor 10/16oz"...
I need a macro to take the data in the "B" column and look for the last piece of data, whatever is after the "last space" in the description. I then need it to then look for a delimiter which I believe is the "/". If there's a "/", then I want it to take the number directly before the "/" (and after the preceding space) and place it in the next column "C" (which I have created for "count"), then take the items after the "/" and place it in column "D" for product weight and delete the information that it used from the original cell in column "B".
A few items don't have the "/" and just have a count, if this is the case, I just want the information moved to the "C" column.
Again, I thank all of you for any help you can provide.
I've been disabled for 5 years, part of my disability is short term memory. The reason I tell you this is so you will understand IF this question is redundant. I have looked at the forums and haven't seen the answer I seek. I also may not have described what I need accurately. Please be patient and ask if I am missing information. I'm trying to start a catalog business to help my meager disability income, lol.
I am very grateful for any help that I can get. Thank you in advance.
Now to the problem;
I have a list of inventory which will be updated regularly. I have to "clean up" column B for printing catalogs and need some of the information moved to the next adjacent cells.
I have in the second cell of the document (In this case, cell "B-2") below my heading, the product names, count per, and the majority of them have a weight. For example, it might have, "Snicker bars 25/8oz" I do have a few that have a space after the "8" but not enough to worry about, for those I can manually check them after and adjust accordingly. The description in column "B" can vary in the number of words to describe the product so a count of words from left to right won't work. For example, it could have in the cell below it, "Doritos cool ranch flavor 10/16oz"...
I need a macro to take the data in the "B" column and look for the last piece of data, whatever is after the "last space" in the description. I then need it to then look for a delimiter which I believe is the "/". If there's a "/", then I want it to take the number directly before the "/" (and after the preceding space) and place it in the next column "C" (which I have created for "count"), then take the items after the "/" and place it in column "D" for product weight and delete the information that it used from the original cell in column "B".
A few items don't have the "/" and just have a count, if this is the case, I just want the information moved to the "C" column.
Again, I thank all of you for any help you can provide.