Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-09-2018, 05:49 PM
Dawindle Dawindle is offline Windows 10 Office 2016
Novice
 
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
  #2  
Old 11-09-2018, 09:07 PM
Marcia Marcia is online now Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: May 2018
Posts: 98
Marcia is on a distinguished road
Default

How did you arrive at 19 as the value for A2? is A2 dependant from the values of the other cells areas? You said c4 is equal to 6 plus B2 or 27 so c4 value is 33, right?
Reply With Quote
  #3  
Old 11-10-2018, 04:31 AM
Dawindle Dawindle is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2018
Posts: 2
Dawindle is on a distinguished road
Default

Sorry column a would be the order amounts which i would put in at the begining of the month. Column b will be a lookup for the daily output possible from the order amount in column a. That is all done and working. Column c is my issue. It needs ro be the target set for each day
Reply With Quote
  #4  
Old 11-10-2018, 07:14 AM
Marcia Marcia is online now Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: May 2018
Posts: 98
Marcia is on a distinguished road
Default

Let's wait for the experts to provide the solution. It's not the regular IF and SUM operations because my understanding is the daily goal (column c) remains static until the first order had been filled, any remaining balance (first order less accumulated goal in Col C) will then be added to the next goal in column B.
Reply With Quote
  #5  
Old 11-10-2018, 07:40 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,195
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

@dawindle
Hi and welcome
please post a sample sheet with some data and expected results
( click Go advanced - Manage attachments)
Thank you
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
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 multiple cells whislt using Filter VinceO Excel 1 05-09-2011 06:38 AM


All times are GMT -7. The time now is 04:23 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft