finding and copying data to a usable table

**Johnidge** · 10-16-2009, 06:52 AM

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

**DonkeyOte** · 10-16-2009, 10:56 AM

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.

**DonkeyOte** · 10-16-2009, 11:35 AM

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.

finding and copying data to a usable table

LinkBack

Thread Tools

Display

finding and copying data to a usable table

Re: finding and copying data to a usable table

Re: finding and copying data to a usable table

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions