Microsoft Office Forums - View Single Post - [Solved] Using VBA to return values from several cells as a formula.

Thread: [Solved] Using VBA to return values from several cells as a formula.

View Single Post

Old

05-23-2023, 11:56 AM

BYahr

BYahr is offline

BYahr uses Windows 11

Windows 11 BYahr uses Office 2021

BYahr uses Office 2021

Office 2021

Novice

The original poster

Join Date: Mar 2023

Posts: 16

BYahr is on a distinguished road

Default

Using VBA to return values from several cells as a formula.

I'm trying to get the data from more than one cell to combine in another cell.

Example: In worksheet 1, cells A23, A24 and A25 have dollar values.
In cell Q165 of worksheet 2, the desired result is =value of A23 + value of A24 - value of A25. (or =35+100-60). Showing in Q165 is 75.

Reply With Quote