I don't think this will make absolute sense but here goes.
At the moment I have a basic accounts spreadsheet where I put the income and expenditure based on a statement. I have now 4 staff that each have their own income/expenditure sheet and also a separate expenses sheet. I want to if possible merge all this into one workbook on excel where If one staff has an expense it shows up automatically if possible on the "Master Expenses sheet" I want to make it so any expenditure on their sheets will appear on my "Master sheet" Is this at all possible? Also can I have usernames and passwords where I can restrict users from accessing other people's income/expenditure sheet. Like for example "EMP1" is only able to see his expenses and accounts sheet once he has put in his username and password but can't do it for "EMP2" and look at theirs. I hope this isn't too confusing and if you need any clarification then please tell me and I will give you a clearer breakdown of what I mean and an example of what I currently have. I work as a volunteer for a non-profit organisation called Kumon Y'all who has won grants to fund their premises and staff wages and other relevant things needed to operate a Youth group. . Many Thanks,Much Obliged. Please Reply and Help.
Bookmarks