N0t Y0urs
Board Regular
- Joined
- May 1, 2022
- Messages
- 96
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- Platform
- MacOS
- Mobile
- Web
Before I start my next headache I thought I would ask if this might be possible and if anyone would like to spin me around 3 times clockwise then 6 times anti so the confusion sets in from the start.
If I have a formula that creates a value of say 250 (Lets call it "A") I want that value to be reported on the next row in the a new data set. Should the "A" value be 2500 I want to create 10 new data sets on the next row. With a maximum of 99 new data sets.
The reason I am trying to figure out if this is possible or not is to save confusion on missing or even doubling up in the forecasting. From there I would create a new formula in an additional column that referenced the bank value in the preceding cell to give a value that would be used elsewhere but was not instrumental in creating a new data set.
Sheet 1
If I have a formula that creates a value of say 250 (Lets call it "A") I want that value to be reported on the next row in the a new data set. Should the "A" value be 2500 I want to create 10 new data sets on the next row. With a maximum of 99 new data sets.
The reason I am trying to figure out if this is possible or not is to save confusion on missing or even doubling up in the forecasting. From there I would create a new formula in an additional column that referenced the bank value in the preceding cell to give a value that would be used elsewhere but was not instrumental in creating a new data set.
Sheet 1
| Data Sheet | |||||||||||||||||||||||||||||||||||
| Data Set | 1 | Data Set | 2 | Data Set | 3 | Data Set | 4 | Data Set | 5 | ||||||||||||||||||||||||||
| Number | Summary | Qty | Value | Total | Value A | V2 | V3 | Qty | Value | Total | Value A | V2 | V3 | Qty | Value | Total | Value A | V2 | V3 | Qty | Value | Total | Value A | V2 | V3 | Qty | Value | Total | Value A | ||||||
| 1 | 15 | $ 55.00 | $ 825.00 | 13 | $ 105.00 | $ 1,365.00 | 50 | $ 60.00 | $ 3,000.00 | 9 | $ 220.00 | $ 1,980.00 | 41 | $ 82.00 | $ 3,362.00 | ||||||||||||||||||||
| 2 | 46 | $ 90.00 | $ 4,965.00 | 37 | $ 101.00 | $ 5,102.00 | 51 | $ 98.00 | $ 7,998.00 | 9 | $ 55.00 | $ 2,475.00 | 48 | $ 177.00 | $ 11,858.00 | ||||||||||||||||||||
| 3 | 42 | $ 52.00 | $ 7,149.00 | 42 | $ 209.00 | $ 13,880.00 | 3 | $ 76.00 | $ 8,226.00 | 14 | $ 196.00 | $ 5,219.00 | 23 | $ 124.00 | $ 14,710.00 | ||||||||||||||||||||
| 4 | 49 | $ 102.00 | $ 12,147.00 | 43 | $ 231.00 | $ 23,813.00 | 48 | $ 45.00 | $ 10,386.00 | 53 | $ 202.00 | $ 15,925.00 | 27 | $ 119.00 | $ 17,923.00 | ||||||||||||||||||||
| 5 | 5 | $ 57.00 | $ 12,432.00 | $ 2,500.00 | 4 | $ 133.00 | $ 24,345.00 | $ 5,000.00 | 51 | $ 55.00 | $ 13,191.00 | $ 2,500.00 | 42 | $ 237.00 | $ 25,879.00 | $ 5,000.00 | 11 | $ 164.00 | $ 19,727.00 | $ 5,000.00 | |||||||||||||||
| 6 | 48 | $ 68.00 | $ 15,696.00 | 3 | $ 104.00 | $ 24,657.00 | 37 | $ 85.00 | $ 16,336.00 | 29 | $ 192.00 | $ 31,447.00 | 29 | $ 164.00 | $ 24,483.00 | ||||||||||||||||||||
| 7 | 28 | $ 99.00 | $ 18,468.00 | 16 | $ 114.00 | $ 26,481.00 | 22 | $ 146.00 | $ 19,548.00 | 10 | $ 201.00 | $ 33,457.00 | 21 | $ 157.00 | $ 27,780.00 | ||||||||||||||||||||
| 8 | 51 | $ 125.00 | $ 24,843.00 | 18 | $ 57.00 | $ 27,507.00 | 32 | $ 100.00 | $ 22,748.00 | 44 | $ 139.00 | $ 39,573.00 | 9 | $ 109.00 | $ 28,761.00 | ||||||||||||||||||||
| 9 | 13 | $ 158.00 | $ 26,897.00 | 4 | $ 181.00 | $ 28,231.00 | 32 | $ 206.00 | $ 29,340.00 | 33 | $ 187.00 | $ 45,744.00 | 46 | $ 59.00 | $ 31,475.00 | ||||||||||||||||||||
| 10 | 17 | $ 179.00 | $ 29,940.00 | $ 5,000.00 | 16 | $ 115.00 | $ 30,071.00 | $ 5,000.00 | 43 | $ 94.00 | $ 33,382.00 | $ 5,000.00 | 18 | $ 160.00 | $ 48,624.00 | $ 5,000.00 | 22 | $ 213.00 | $ 36,161.00 | ||||||||||||||||
| 11 | 51 | $ 90.00 | $ 34,530.00 | 48 | $ 139.00 | $ 36,743.00 | 34 | $ 64.00 | $ 35,558.00 | 54 | $ 177.00 | $ 58,182.00 | 17 | $ 172.00 | $ 39,085.00 | ||||||||||||||||||||
| 12 | 4 | $ 150.00 | $ 35,130.00 | 28 | $ 197.00 | $ 42,259.00 | 2 | $ 174.00 | $ 35,906.00 | 34 | $ 87.00 | $ 61,140.00 | 4 | $ 99.00 | $ 39,481.00 | ||||||||||||||||||||
| 13 | 4 | $ 151.00 | $ 35,734.00 | 36 | $ 90.00 | $ 45,499.00 | 22 | $ 129.00 | $ 38,744.00 | 35 | $ 55.00 | $ 63,065.00 | 26 | $ 51.00 | $ 40,807.00 | ||||||||||||||||||||
| 14 | 2 | $ 171.00 | $ 36,076.00 | 50 | $ 163.00 | $ 53,649.00 | 37 | $ 182.00 | $ 45,478.00 | 17 | $ 189.00 | $ 66,278.00 | 55 | $ 190.00 | $ 51,257.00 | ||||||||||||||||||||
| 15 | 26 | $ 68.00 | $ 37,844.00 | $ 5,000.00 | 39 | $ 231.00 | $ 62,658.00 | $ 5,000.00 | 5 | $ 223.00 | $ 46,593.00 | $ 5,000.00 | 48 | $ 131.00 | $ 72,566.00 | $ 5,000.00 | 23 | $ 229.00 | $ 56,524.00 | ||||||||||||||||
| 16 | 42 | $ 190.00 | $ 45,824.00 | 43 | $ 237.00 | $ 72,849.00 | 15 | $ 97.00 | $ 48,048.00 | 54 | $ 161.00 | $ 81,260.00 | 29 | $ 195.00 | $ 62,179.00 | ||||||||||||||||||||
| 17 | 21 | $ 77.00 | $ 47,441.00 | 17 | $ 111.00 | $ 74,736.00 | 52 | $ 195.00 | $ 58,188.00 | 55 | $ 115.00 | $ 87,585.00 | 25 | $ 189.00 | $ 66,904.00 | ||||||||||||||||||||
| 18 | 24 | $ 157.00 | $ 51,209.00 | 2 | $ 109.00 | $ 74,954.00 | 16 | $ 113.00 | $ 59,996.00 | 1 | $ 103.00 | $ 87,688.00 | 24 | $ 216.00 | $ 72,088.00 | ||||||||||||||||||||
| 19 | 1 | $ 247.00 | $ 51,456.00 | 29 | $ 250.00 | $ 82,204.00 | 45 | $ 104.00 | $ 64,676.00 | 36 | $ 185.00 | $ 94,348.00 | 44 | $ 127.00 | $ 77,676.00 | ||||||||||||||||||||
| 20 | 22 | $ 76.00 | $ 53,128.00 | $ 5,000.00 | 9 | $ 61.00 | $ 82,753.00 | $ 5,000.00 | 9 | $ 98.00 | $ 65,558.00 | $ 5,000.00 | 1 | $ 125.00 | $ 94,473.00 | $ 5,000.00 | 1 | $ 116.00 | $ 77,792.00 | ||||||||||||||||
| 21 | 55 | $ 103.00 | $ 58,793.00 | 7 | $ 229.00 | $ 84,356.00 | 4 | $ 110.00 | $ 65,998.00 | 50 | $ 193.00 | $ 104,123.00 | 52 | $ 183.00 | $ 87,308.00 | ||||||||||||||||||||
| 22 | 46 | $ 198.00 | $ 67,901.00 | 3 | $ 124.00 | $ 84,728.00 | 22 | $ 138.00 | $ 69,034.00 | 22 | $ 85.00 | $ 105,993.00 | 17 | $ 79.00 | $ 88,651.00 | ||||||||||||||||||||
| 23 | 43 | $ 176.00 | $ 75,469.00 | 52 | $ 70.00 | $ 88,368.00 | 48 | $ 60.00 | $ 71,914.00 | 48 | $ 215.00 | $ 116,313.00 | 16 | $ 189.00 | $ 91,675.00 | ||||||||||||||||||||
| 24 | 49 | $ 114.00 | $ 81,055.00 | 38 | $ 231.00 | $ 97,146.00 | 14 | $ 99.00 | $ 73,300.00 | 33 | $ 50.00 | $ 117,963.00 | 15 | $ 156.00 | $ 94,015.00 | ||||||||||||||||||||
| 25 | 4 | $ 97.00 | $ 81,443.00 | $ 5,000.00 | 5 | $ 98.00 | $ 97,636.00 | $ 5,000.00 | 42 | $ 182.00 | $ 80,944.00 | $ 5,000.00 | 47 | $ 192.00 | $ 126,987.00 | $ 5,000.00 | 38 | $ 195.00 | $ 101,425.00 | ||||||||||||||||
