I use a Google spreadsheet to keep track of my program's budget and would like to create a system in which rows are automatically duplicated onto seven other spreadsheets, depending on the code in each row. The goal is to provide staff access to budget information related to their operations without providing details on the entire budget.
The current spreadsheet has two tabs:
- Tab 1: Budget The "Budget" tab has the budget line description, the budgeted amount, and the actual amount spent (pulled from tab 2).
- Tab 2: Register. The "Register" tab has the date, description, budget line, and amount.
1. If a row on Tab 2 of the main spreadsheet has a budget line that is assigned to a specific person, that row is duplicated onto Tab 2 of a secondary spreadsheet that is assigned to that specific person. There will be seven secondary spreadseets in total. The total number of spreadsheets may change in future years.
2. If a row is changed on Tab 2 of the main spreadsheet, it is changed on Tab 2 of the secondary spreadsheet.
25 freelancers are bidding on average $422 for this job
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel
Google Spreadsheets Professional Dear, I am an Excel as well as google spread sheet professional having hands on expertise on data analysis and management. I will do your project as per your requirements. Best regards