Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-23-2023, 11:56 AM
BYahr BYahr is offline Using VBA to return values from several cells as a formula. Windows 11 Using VBA to return values from several cells as a formula. Office 2021
Novice
Using VBA to return values from several cells as a formula.
 
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
 

Tags
combine data in cells, vba to display a formula.



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
Using VBA to return values from several cells as a formula. Loop through cells and return only unique values trevorc Excel Programming 4 10-11-2018 03:49 PM
Using VBA to return values from several cells as a formula. 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
Using VBA to return values from several cells as a formula. Excel Formula: return a range of cells that match tinfanide Excel 4 08-30-2014 07:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft