Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-09-2018, 05:49 PM
Dawindle Dawindle is offline Filling in cells based on 2 other cells data Windows 10 Filling in cells based on 2 other cells data Office 2016
Novice
Filling in cells based on 2 other cells data
 
Join Date: Nov 2018
Posts: 2
Dawindle is on a distinguished road
Default Filling in cells based on 2 other cells data

I need to figure out how to enter data fro column b and then subtract that from column a and enter the new value, then keep that going to formulate each days target for the whole month



So if cell a1 is 105 and b1 has a goal of 33 a day then c1 is 33.
Then c2 and c3 would need to also be 33
Then c4 would be the 6 remaining plus the goal from b2
So a2 would be 19 and b2 would be 27
And so forth
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Filling in cells based on 2 other cells data Cells automatically filling in otuatail Excel 3 08-17-2017 11:31 PM
filling in blank cells with data from cell above RayK Excel 1 01-12-2017 04:14 PM
Conditional formating all cells in an array based on adjacent cells deejay Excel 6 12-20-2016 12:00 PM
Wierd... "cell" started auto filling with data from other cells I double click on. How stop it?! KerryOn Excel 2 08-10-2015 08:41 PM
Filling in cells based on 2 other cells data filling multiple cells whislt using Filter VinceO Excel 1 05-09-2011 06:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:47 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