I have 2 worksheets in a workbook. SheetA allows total deposits to be entered in A1. Sheet B allows user to enter individual deposits in A2:A100 and calculates total in A1. I want to be able to Auto fill SheetA, A1 with value in SheetB, A1. I know how to do this part However I also want to allow user to enter manual value in SheetA, A1 without losing formula to SheetB, A1 (='Sheet B'!A1). The Formula is needed as back up due to the type of underwriting we are doing. Some bank statements list total deposits which would allow us to enter value directly into SheetA, A1. Some Bank statements do not and the individual deposits would need to be manually input and added up via SheetB A2:A100 totaling in A1. Is this possible?
Bookmarks