Spreadsheet: 880970d1728869664-transfer-values-from-one-table-to-another-transfer-to-forum-2
Sheet: Sheet1

 | wallyclan | HELP - How can I transfer the data in Table One cells F10 to O21 to the cells in Table Two from C29 to O40?
 |  | The amounts in table two must transfer based on the corresponding year in  table one
 |  | See lines 7 and 8 in Table Two as an example
 |  | This is just a portion of all the data - I have manually shown some of the results for clarity
 |  |  |  |  |  |  | TABLE ONE
 |  | 2024 | Expected | Remaining | First | First | Second | Second | Third | Third | Fourth | Fourth | Fifth | Fifth
 |  | Est. Cost | Useful | useful life to | Time to | Replace | Time to | Replace | Time to | Replace | Time to | Replace | Time to | Replace
Line | Item | Per Phase | Life | 1st Replace | Replace | Cost | Replace | Cost | Replace | Cost | Replace | Cost | Replace | Cost
1 | Concrete Repairs | 64200 | 10 | 15 | 2039 | 83460 | 2049 | 100152 | 2059 | 120182.4 | 2069 | 144218.88 | 2079 | 173062.656
2 | Railings, Replacement | 72000 | 50 | 24 | 2048 | 106560 | 2098 | 213120 | 2148 | 426240 | 2198 | 852480 | 2248 | 1704960
3 | Doors, Common, | 4000 | 27 | 1 | 2025 | 4080 | 2052 | 6283.2 | 2079 | 9676.128 | 2106 | 14901.23712 | 2133 | 22947.9051648
4 | Roof, Concrete Tile | 174000 | 25 | 22 | 2046 | 250560 | 2071 | 375840 | 2096 | 563760 | 2121 | 845640 | 2146 | 1268460
5 | Paint walls & railings, | 50000 | 10 | 1 | 2025 | 51000 | 2035 | 61200 | 2045 | 73440 | 2055 | 88128 | 2065 | 105753.6
6 | Electrical Systems, | 42000 | 56 | 30 | 2054 | 67200 | 2110 | 142464 | 2166 | 302023.68 | 2222 | 640290.2016 | 2278 | 1357415.227392
7 | Life Safety System, | 5000 | 3 | 3 | 2027 | 5300 | 2030 | 5618 | 2033 | 5955.08 | 2036 | 6312.3848 | 2039 | 6691.127888
8 | Emergency Devices | 12000 | 3 | 3 | 2027 | 12720 | 2030 | 13483.2 | 2033 | 14292.192 | 2036 | 15149.72352 | 2039 | 16058.7069312
9 | Pipes, Risers, Domestic | 70000 | 90 | 30 | 2054 | 112000 | 2144 | 313600 | 2234 | 878080 | 2324 | 2458624 | 2414 | 6884147.199999999
10 | Elevator Cab Interiors | 10000 | 32 | 6 | 2030 | 11200 | 2062 | 18368 | 2094 | 30123.52000000001 | 2126 | 49402.57280000002 | 2158 | 81020.21939200003
11 | Elevator, [NAME] | 40000 | 53 | 27 | 2051 | 61600 | 2104 | 126896 | 2157 | 261405.76 | 2210 | 538495.8656 | 2263 | 1109301.483136
12 | Trash Chute | 15000 | 56 | 30 | 2054 | 24000 | 2110 | 50880 | 2166 | 107865.6 | 2222 | 228675.072 | 2278 | 484791.15264
 |  |  |  |  |  |  | TABLE TWO
 |  | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget
 |  | Cost | Cost | Cost | Cost | Cost | Cost | Cost | Cost | Cost | Cost | Cost | Cost | Cost
 | Item | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036
1 | Concrete Repairs
2 | Railings, Replacement
3 | Doors, Common, |  | 4080
4 | Roof, Concrete Tile
5 | Paint walls & railings, |  | 51000 |  |  |  |  |  |  |  |  |  | 61200
6 | Electrical Systems,
7 | Life Safety System, |  |  |  | 5300 |  |  | 5618 |  |  | 5955
8 | Emergency Devices |  |  |  | 12720 |  |  | 13483 |  |  | 14292
9 | Pipes, Risers, Domestic
10 | Elevator Cab Interiors |  |  |  |  |  |  | 11200
11 | Elevator, [NAME]
12 | Trash Chute