I need a formula to pull a formula from another cell. So for instance, in A1, the formula is "=A2+A3+A4" and I need a formula that I can put in B1 that would reference A1 and return the value of "=B2+B3+B4". Finding a formula is the key here as I would rather not run a macro to copy and paste it. Seems like there should be a function called "copyandpaste" but I guess i've got my head in the clouds. The final goal would be to be able to have one workbook reference another workbook's A1 and have it calculate "=A2+A3+A4" using the A2,A3, and A4 in the original workbook. Thanks for the help!