ChristineJ
Well-known Member
- Joined
- May 18, 2009
- Messages
- 771
- Office Version
- 365
- Platform
- Windows
A1=1 (can vary)
A2 =2 (can vary)
A3 = D3, D2, E9, F8, D4, K15 (text string of cell references that can vary: different references, different number of references, different order)
The "allowable" references are C5, D3, D4, D6, F8, G1 (can vary: can vary: different references, different number of references)
Cell A4 should take the "allowable" references from the string in A3: D3, F8, D4 AND then adapt those so the column letter in each cell address is increased by 1 (the value in A1) and and the row number is increased by 2 (the value in A2).
Cell A4 would finally show E5, G10, E6
Can this be done? Would be even better with VBA so values in A1, A2, and A3 do not have to appear on the worksheet - just the result in A4. Thanks!
A2 =2 (can vary)
A3 = D3, D2, E9, F8, D4, K15 (text string of cell references that can vary: different references, different number of references, different order)
The "allowable" references are C5, D3, D4, D6, F8, G1 (can vary: can vary: different references, different number of references)
Cell A4 should take the "allowable" references from the string in A3: D3, F8, D4 AND then adapt those so the column letter in each cell address is increased by 1 (the value in A1) and and the row number is increased by 2 (the value in A2).
Cell A4 would finally show E5, G10, E6
Can this be done? Would be even better with VBA so values in A1, A2, and A3 do not have to appear on the worksheet - just the result in A4. Thanks!