powercell99
New member
- Joined
- Apr 25, 2014
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi,
I'm in need of some help with this formula: =PROPER($J2)&", "&PROPER($I2)&" / "&$Z2& " / Total Attendees: "& SUMIFS($AU:$AU,$D:$D, $D2,$C:$C, $C2,$Z:$Z, $Z2) &" / Total Cost: $"& SUMIFS($BB:$BB,$D:$D, $D2,$C:$C, $C2,$Z:$Z, $Z2) &" (vbCr) "&$BZ2
I cant seem to get vba to accept that concatenated formula into a cell, or find a way to get VBA to put the value result of the formula in Column "AA", specifically Cell "AA2" and every cell below it if cell "A" is not blank. Either method would work for me.
Any help would be GREATLY appreciated.
Thanks in advance!
I'm in need of some help with this formula: =PROPER($J2)&", "&PROPER($I2)&" / "&$Z2& " / Total Attendees: "& SUMIFS($AU:$AU,$D:$D, $D2,$C:$C, $C2,$Z:$Z, $Z2) &" / Total Cost: $"& SUMIFS($BB:$BB,$D:$D, $D2,$C:$C, $C2,$Z:$Z, $Z2) &" (vbCr) "&$BZ2
I cant seem to get vba to accept that concatenated formula into a cell, or find a way to get VBA to put the value result of the formula in Column "AA", specifically Cell "AA2" and every cell below it if cell "A" is not blank. Either method would work for me.
Any help would be GREATLY appreciated.
Thanks in advance!