| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create 1 master list from a combination of rows and columns
Hi there
I have a spreadsheet that contains approx 584 rows and 163 columns. Column A = Account, Column B = Description, Columns C+ = Department. Something like this ACCT DESCRIPTION 1101 2140 3125 6179 12345 Example 1 X 22588 Example 1 X X X 33244 Example 1 X X 78544 Example 1 X X X 78545 Example 1 X X Is it possible to use VBA to achieve the following: ACCT DESCRIPTION DEPT 12345 Example 1 1101 22588 Example 1 1101 22588 Example 1 2140 22588 Example 1 3125 33244 Example 1 2140 33244 Example 1 3125 78544 Example 1 2140 78544 Example 1 3125 78544 Example 1 6179 78545 Example 1 3125 78545 Example 1 6179 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selecting data from a combination of columns & rows. | Excel Discussion (Misc queries) | |||
| Create A Master List From Several Lists | Excel Worksheet Functions | |||
| How can I create a master item list from orders? | Excel Worksheet Functions | |||
| how to create a list and link it to the master excel file | Excel Worksheet Functions | |||
| create a master list from other sheets | Excel Worksheet Functions | |||
Threaded Mode
