MRichmond
01-27-2012, 07:21 AM
Good afternoon all,
Here's hoping someone can help.
I have a workbook, and on sheet "Summary" people enter stock in column H. I need to take whatever is entered in (notice the break in sample workbook) it will always be qty and stock no, and break the data down into two columns on the "Data" worksheet.
I know I can do this with text to columns, and then moving it manually, but the Summary could contain 200+ rows, so I'm looking for some VBA code to automate
Any ideas?
Here's hoping someone can help.
I have a workbook, and on sheet "Summary" people enter stock in column H. I need to take whatever is entered in (notice the break in sample workbook) it will always be qty and stock no, and break the data down into two columns on the "Data" worksheet.
I know I can do this with text to columns, and then moving it manually, but the Summary could contain 200+ rows, so I'm looking for some VBA code to automate
Any ideas?