I am importing a CSV file when imported has column for date (mm/dd/yyyy), employee. I need to do a report where it will total up each employees hours for the month, then take the pay rate and multiply the hours to give me the total price for each individual and then add up the amounts to give a total labor cost for the month. Every month I will be importing a report and I can either just import all the information for the year or I can import for just the month. I am not sure how I can go about doing this, is this something I would just use a macro for each step of the process? or is there a way to group (without knowing how big each group is going to be) I am trying to set this up so that it will be automatic so that my boss can also use the form if I am not in the office.
I hope I made sense.
Thank you in advance for any help.
Bookmarks