Nov 07 2021 09:35 AM
Hi
I am a complete newbie to Excel.
I have a workbook for my small business showing .Sales. stock and purchases.
Each on a separate sheet.
What I need is to have sales automatically deduct from the stock sheet and purchases automatically added to the stock sheet.
Is this at all possible?
Using 2019 Excel.
Thanks for any help.
Nov 21 2021 06:28 AM
SolutionWhen you enter a formula, you just have to navigate to the other sheet within the workbook, and make the cell(s) from the other sheets part of the formula. In other words, start from the sheet where you want the result to appear, then create the formula by selecting the proper cells in the other sheets. You can select data from any other cells, either from sheets within the same workbook, or even pull from other workbooks. Make sense?
Nov 22 2021 02:35 PM
Nov 21 2021 06:28 AM
SolutionWhen you enter a formula, you just have to navigate to the other sheet within the workbook, and make the cell(s) from the other sheets part of the formula. In other words, start from the sheet where you want the result to appear, then create the formula by selecting the proper cells in the other sheets. You can select data from any other cells, either from sheets within the same workbook, or even pull from other workbooks. Make sense?