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

p45cal · #1 05-24-2023, 04:03 AM

I don't know what your sheets' names are so you'll need to adjust this:

Code:

With Sheets("Sheet1")
  Sheets("Sheet2").Range("Q165").Value = .Range("A23").Value + .Range("A24").Value - .Range("A25").Value
End With

…and there are many other ways.

BYahr · #2 05-25-2023, 11:58 AM

Thank you, p45cal. This helps. The result is the correct value but I would prefer to get the individual values in a formula. EX =100+5-1 to display 104. This makes it easy to know where the values originated.

The sheets that I am working with are in two different workbooks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to match one list with another and return certain values from corresponding cells in excel	Oluagbe1	Excel	10	02-11-2019 07:00 PM
Loop through cells and return only unique values	trevorc	Excel Programming	4	10-11-2018 03:49 PM
have a formula that combines two cells return a zero instead of a blank cell	Kubi	Excel	3	08-07-2017 11:52 PM
Formula/function to return column names for matching values	GiJoe81	Excel	1	06-27-2015 12:13 AM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM