I currently have a macro in the attached file that populates cell A23 in the Data Finder worksheet based on column A in the Employees worksheet and prints them out (the graphs from each valid entry Data Finder sheet). Rather than print them out, I want to place the data that would be found in column AI in the Data Finder sheet and match it up with the corresponding number in column A of the Employees sheet placing the values in columns E, F and so on....The way the file is currently setup (this is the smaller file, copied from larger ones), it calculates the data based on the 'clock number' input from the employee sheet. I'm not sure how to simplify it, but I believe a change to the macro that already functions may be the way to go. I add each month into this file so the macro may need to be tweaked so that i could add onto the data in the employee sheet (additional columns for subsequent months).
Any suggestions?
Thank You
Bookmarks