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.

Thread Tools
Display Modes


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 08:00 PM.


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