Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning a large spreadsheet into a room by room list
I have a spreadsheet with items listed from top to bottom on the left, with
rooms going across the top. If the item is required in teh room I put the qty. This means teh chart is very large and not every item is in every room. I want to be able to 'filter' this chart so it produces a room by room breakdown on one long list.... i.e. Room 1 Room 2 Room 3 Chair 1 1 Table 1 Stool 1 1 Bin 1 1 1 .....would be produced as... Room 1 Chair - 1 Table - 1 Stool - 1 Bin - 1 Room 2 Stool - 1 Bin - 1 Room 3 Chair - 1 Bin - 1 The actual chart is as wide as excel will do and about 500 hundred items long, just to give you a scale on it. I can send over the file if you fancy a challenge? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning a large spreadsheet into a room by room list
Send, along with this msg as a snippet, to my private address below and I
will take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "raphiel2063" wrote in message ... I have a spreadsheet with items listed from top to bottom on the left, with rooms going across the top. If the item is required in teh room I put the qty. This means teh chart is very large and not every item is in every room. I want to be able to 'filter' this chart so it produces a room by room breakdown on one long list.... i.e. Room 1 Room 2 Room 3 Chair 1 1 Table 1 Stool 1 1 Bin 1 1 1 ....would be produced as... Room 1 Chair - 1 Table - 1 Stool - 1 Bin - 1 Room 2 Stool - 1 Bin - 1 Room 3 Chair - 1 Bin - 1 The actual chart is as wide as excel will do and about 500 hundred items long, just to give you a scale on it. I can send over the file if you fancy a challenge? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
QAT does not allow enough room for customization - please help | Excel Discussion (Misc queries) | |||
Need more room on Spreadsheet | Excel Discussion (Misc queries) | |||
HELP - Room booking spreadsheet hell | Excel Worksheet Functions | |||
HELP - Room booking spreadsheet hell | Excel Discussion (Misc queries) | |||
Chat Room | New Users to Excel |