windiestboat
New Member
- Joined
- Jul 2, 2020
- Messages
- 4
- Office Version
- 2016
- Platform
- MacOS
Hello All,
I have an example of a problem i am encountering.
Imagine the below data (a simplified example of the data im working with):
I am wondering if there is a function or macro that I can put together which would input the units for a selected bldg on a different line. so if i selectd bldg one and wanted to see the amounts for each unit it would pull a-d into a successive line and i could then use an index match function for the amount data. this would need to be variable though as say bld 4, 3, and 2 all have less units than bldg 1. I cannot use a pivot table here. Wondering if there is a macro that would take the count of the units for each bldg and insert on a new line based on duplicates? the number of line items is variable - so an example end product will show 1 to 4 unit/amt line items - have a macro that automatically adjusts to the number of units by copying rows 16-18 in the example product and inserting them below...
any help or ideas is much appreciated. Thank you guys!
I have an example of a problem i am encountering.
Imagine the below data (a simplified example of the data im working with):
I am wondering if there is a function or macro that I can put together which would input the units for a selected bldg on a different line. so if i selectd bldg one and wanted to see the amounts for each unit it would pull a-d into a successive line and i could then use an index match function for the amount data. this would need to be variable though as say bld 4, 3, and 2 all have less units than bldg 1. I cannot use a pivot table here. Wondering if there is a macro that would take the count of the units for each bldg and insert on a new line based on duplicates? the number of line items is variable - so an example end product will show 1 to 4 unit/amt line items - have a macro that automatically adjusts to the number of units by copying rows 16-18 in the example product and inserting them below...
any help or ideas is much appreciated. Thank you guys!