Roger49
asked on
How to improve my Attendance Tracking in Excel with macros
I have had to bring this one back to the experts. Plse see attached tracking workbook. Try as i will I cannot teach myself enough to finish the workbook macros. I need to be able to have 60 names appear on the Year To Date sheet but they must also appear automatically on the other sheets (one for each quarter). They must also be able to be sorted across all sheets keeping the data in the row asssociated with the name. Also once deleted I would like to be able to delete through all sheets and then resort. If anyone can assist i would be so grateful. My VBA skills are basically zero but I have tried to self-teach but cannot gain enough skills to do this part.
New-Attendance-28-Oct.xls
New-Attendance-28-Oct.xls
ASKER
Many thanks for the rescue. In all honesty not a lot has changed but a problem or two has arisen that has stumped me. Quick summary: As you can see I have a summary page where the intention is that users only need to complete the headings highlighted in green. Thereafter all they should need to do is complete a row alongside their own name for the relevant quarter shown on each relevant following worksheet. EE has already helped me link the colour codes at topleft on each sheet so that when you put a letter in it highlights in relevant colour - this seems to have stopped working for some reason.
I started by inputting the user names on the summary page and EE helped me with a macro to delete and sort the names. I initially linked these to following tabs sheets by seelcting tabs and then pasting into summary. They then flowed through the sheets - this seems to have ceased as well and is probably not the best way to achieve this. However the deletions on summary screen accrued so that number of referenced rows also decreased not allowing the same scope for new input.
The intention: this was to have a summary sheet where user adds name and details in green column. Then they link to relevant period and input code letter to indicate a whole or half day of a particular absence type. The the idea was that as new names were added the existing sheets would pick up the names and retain the data rows against the names when sorted on summary sheet. This would also apply when a name was deleted - a re-sort keeping data rows aligned.
This whole thing started as an upmarket straighforward spreadsheet until I saw what could be done - have sort of dropped myslef in it as boss would like to use it internally. Can I assure you that any effort you make willnot be used for any benefit other than recovering my pride. It would only be for internal use in our local govt dept. It may be of use to others on EE though.
I really would be grateful if you are able to assist.
Roger
I started by inputting the user names on the summary page and EE helped me with a macro to delete and sort the names. I initially linked these to following tabs sheets by seelcting tabs and then pasting into summary. They then flowed through the sheets - this seems to have ceased as well and is probably not the best way to achieve this. However the deletions on summary screen accrued so that number of referenced rows also decreased not allowing the same scope for new input.
The intention: this was to have a summary sheet where user adds name and details in green column. Then they link to relevant period and input code letter to indicate a whole or half day of a particular absence type. The the idea was that as new names were added the existing sheets would pick up the names and retain the data rows against the names when sorted on summary sheet. This would also apply when a name was deleted - a re-sort keeping data rows aligned.
This whole thing started as an upmarket straighforward spreadsheet until I saw what could be done - have sort of dropped myslef in it as boss would like to use it internally. Can I assure you that any effort you make willnot be used for any benefit other than recovering my pride. It would only be for internal use in our local govt dept. It may be of use to others on EE though.
I really would be grateful if you are able to assist.
Roger
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Will try and lend a hand.
Can you help me understand what has changed since the last posting on this topic, or what parts of what we discussed then are giving you trouble?
https://www.experts-exchange.com/questions/24711459/Sorting-data-on-mutliple-Excel-sheets-from-single-summary-sheet-deleting-line-information.html
~bp