Create multiple multiple rows of data using a variable number from another sheet.
Before asking how, I need to see if this is even possible. Also, allow me to thank you in advance for any feedback you provide.
What I am working with:
One sheet is a finance tracker - This sheet uses a form to gather purchase information for equipment we purchase and put on display.
The second sheet is an Asset Tracker. - This sheet draws some of it's initial data from the Asset tracker using Bridge.
The Finance tracker intakes purchases one item at a time. This is fine for Computers or monitors. If we purchase 3 of the same model mice, those 3 mice are, currently, on a single row with a combined cost.
I am wondering if it is possible to use a "Quantity" field in the Finance tracker that can then be used to create that number of Row Items in the Asset tracker.
One purchase of 3 mice at 15.00 each totaling 45.00 - one row on Finance tracker but the Quantity multiplier of 3 makes that translate into 3 individual rows of data in the Asset tracker. This way I can assign those 3 mice to 3 different eco systems.