Cell NOT NULL, Next Cell.
I need to make a formula that says if A2 is not null, put information in A3, if A3 is not null, put in for in A4, and so on. Then I need another formula for another cell to reference the last cell in formerly mentioned column. I am completely flummoxed!
Thanks!
The way that the first part of your post reads, is that you want a formula to 'send' something to the next empty cell in the column.
A formula cannot do that, it can only show a result in the cell in which it is entered.
Allow me to rephrase, a function or a formula. I will elaborate. I want the result of E4+D4, in the BASEMENT worksheet to go into another worksheet, we'll call BALANCE. And each time D4 is changed in BASEMENT, the new amount is put into the next blank cell of a column in BALANCE. Then in turn, I want E4 in BASEMENT to reference the last number in the column. It will be a running balance in BALANCE, but the last cell in the running balance will show in Basement E4. Does that make sense?
Last edited by LibraryTech; 10-02-2015 at 09:52 AM.
They are the effectively the same, a FUNCTION is a command used in a formula.Originally Posted by LibraryTech
This will put "information" in the next empty cell after A2
This will reference the last cell in column A
Please Login or Register to view this content.
Formula:
Please Login or Register to view this content.
Last edited by jason.b75; 10-02-2015 at 10:53 AM.
It is a bit circular.... I tried a formula like BAL = BAL- INV_CHG, as I would use in any OOP, but Excel does not like circular references.
Thank you Jason.b75. I have that as well.
Ok, lets start from the beginning.
Where is the 'Information' coming from, and what sort of information are we looking at? Text / dates / numbers?
Numbers. Just basic balances. If we have 10 things in stock, and use 2, we have a balance of 8. If someone comes and grabs 2 more, then we have 6. We want the sheet to keep track of the balance of the stock. However, We want the main sheet (that the rest of the users will see) to only show the balance available. In the background, we want a running balance on another sheet... We are thinking we may have to do this is Access, but since the users are more familiar with Excel, we thought we would try and use that.
Ok, I think I have this right.
Enter your opening stock balance in A2 of the Balance sheet.
Enter this formula in E4 of the Basement sheet.
Formula:Please Login or Register to view this content.
Right click the sheet tab of the Basement sheet, click 'View Code', then copy the code below into the sheet module.
I think it does what you need.Please Login or Register to view this content.
To add new stock to the balance you should be able to input as a negative in D4, or you could change D4 to 0 and delete the data from column A of Balance sheet and enter the new figure manually to start again with a clean sheet. Whichever suits your need best.
Thanks! I'll give it a try! :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks