southernsquid2
New Member
- Joined
- Nov 18, 2024
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi,
I am working a huge budget worksheet and was wondering if I can do the following. I have over 3000 line items (rows) that have individual cost associated with them. I can sort the whole sheet and total cost for whatever is sorted. Alot of these items fall into specific "kits". I would rather just list the kits with the total cost, but the bean counters want to see the individual cost for each item. Is there a way to list by kit and then be able to drop down the rows that make up that kit? either by rows or tables?
I understand I can hide rows but I was wondering if there was a simpler way to expand a kit and have the individual equipment rows populate below it if I need to.
I am working a huge budget worksheet and was wondering if I can do the following. I have over 3000 line items (rows) that have individual cost associated with them. I can sort the whole sheet and total cost for whatever is sorted. Alot of these items fall into specific "kits". I would rather just list the kits with the total cost, but the bean counters want to see the individual cost for each item. Is there a way to list by kit and then be able to drop down the rows that make up that kit? either by rows or tables?
I understand I can hide rows but I was wondering if there was a simpler way to expand a kit and have the individual equipment rows populate below it if I need to.