MacroMaster
New Member
- Joined
- Apr 26, 2014
- Messages
- 1
I want a main sheet and 3 sub-sheets.
All sheets have 3 columns
<tbody>
</tbody>
I want them to sort by Date first, Then Number.
The type cells will have ‘drop down lists’ on them; 1, 2 and 3 corresponding to the three sub-sheets.
I would like the data to be automatically updated on all the sheets, and in the correct order, when a value is changed in any of the boxes. I would like the other values to all be constantly be updated when changed on any sheet.
I would also like a single ‘drop down lists’ cell in all the sheets, which when the type is selected the sheet will open up automatically (0 for main, 1 for sub-sheet 1, etc).
All sheets have 3 columns
| Date | Number | Type |
| | | |
| | | |
<tbody>
</tbody>
I want them to sort by Date first, Then Number.
The type cells will have ‘drop down lists’ on them; 1, 2 and 3 corresponding to the three sub-sheets.
I would like the data to be automatically updated on all the sheets, and in the correct order, when a value is changed in any of the boxes. I would like the other values to all be constantly be updated when changed on any sheet.
I would also like a single ‘drop down lists’ cell in all the sheets, which when the type is selected the sheet will open up automatically (0 for main, 1 for sub-sheet 1, etc).
