Create a List From a Grid

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cecil - 22 Jul 2006 00:29 GMT

I have a worksheet of rows of customers and columns of products. There
are about 250 customers and about 100 products. Therefore, there are
25,000 cells of data. Each cell contains the dollar amount of that
product sold to that customer. I would like to create a 3-column list
of data that contains customer-name, product-name and dollars sold. The
number of rows in that list would equal the number of cells that are
non-zero. In other words, cells with zero dollars can be ignored. How
can this be accomplished? :confused:

Signature

Cecil

Reply to this Message

Jim Cone - 22 Jul 2006 01:58 GMT

Would a VBA code solution be something you could use?

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Cecil"
wrote in message I have a worksheet of rows of customers and columns of products.
There are about 250 customers and about 100 products. Therefore, there are
25,000 cells of data. Each cell contains the dollar amount of that
product sold to that customer. I would like to create a 3-column list
of data that contains customer-name, product-name and dollars sold. The
number of rows in that list would equal the number of cells that are
non-zero. In other words, cells with zero dollars can be ignored. How
can this be accomplished? :confused:
--
Cecil

Reply to this Message