I'm trying to sort through a large list of stock data that has been converted from a .csv file. for the information to be in a useful format i need to pull off the product codes and relavent total stock weight. i have been trying to write a macro to search usung a list of codes as a referance an then search for the next raw stock under that code (which can change in distance) and then put the informatin in a table then search for the next code and do the same until i have a usable stock list.
so far i haven't got very far, does anyone know of an easy way of doing this?
i have attached a file of the relavent data.
thanks
Files are generally speaking a gazillion times more useful than an image... so:
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks