Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Location data to grid
I have a list of products, item 1, item 2, etc.. and for each location. The location is in a grid 26*26, from a to z in the x axis and 1 to 26 on the y axis. Each item appears ONLY ONCE in the list bu could have SEVERAL locations in the grid. In that case, the locatio field is populated with several location couples seperated by a comm (eg. a1,b2,f4) From the list, I would like to generate the grid graphically in anothe worksheet where for the item's name appears in the appropriate cells. If there was one location for each item, it would be easy with a looku function, but here I am stuck. Thanks for your help -- fredl ----------------------------------------------------------------------- fredlo's Profile: http://www.excelforum.com/member.php...fo&userid=1453 View this thread: http://www.excelforum.com/showthread.php?threadid=26160 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Location data to grid
hi,
could you explain a little more about the grid part. what is it? -----Original Message----- I have a list of products, item 1, item 2, etc.. and for each a location. The location is in a grid 26*26, from a to z in the x axis, and 1 to 26 on the y axis. Each item appears ONLY ONCE in the list but could have SEVERAL locations in the grid. In that case, the location field is populated with several location couples seperated by a comma (eg. a1,b2,f4) From the list, I would like to generate the grid graphically in another worksheet where for the item's name appears in the appropriate cells. If there was one location for each item, it would be easy with a lookup function, but here I am stuck. Thanks for your help. -- fredlo ---------------------------------------------------------- -------------- fredlo's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=14535 View this thread: http://www.excelforum.com/showthread...hreadid=261601 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
Pulling data from grid | Excel Worksheet Functions | |||
I need to convert grid.doc to an Excel Grid. | Charts and Charting in Excel | |||
Is it possible to use 'grid' as a value in vb to process XL data? | Excel Discussion (Misc queries) | |||
Active X and Data Grid | Excel Programming |