How to auto copy rows based on date
Okay, we are looking to use excel as a quick way to manage our projects internally. Basically we have a sheet for each employee, plus a "Today" task list as a sheet, and a "completed" task list as a sheet.
Each employee will have 4 columns of information.
A = Job#
B = Description
C = Due Date
D = Notes about task. (This will be simple descriptions like ... Complete, Sending to Print, Sent to Client, etc)
What we are looking to do is have information from the employee tasks auto copy to the "today" and "complete" sheets automatically based on the date and the Notes section.
Is there a simple solution to this? Ultimately we would also like it to organize by client, employee, etc as well but we are willing to just go one step at a time for now. Any suggestions?
hi suggest you spend a little
hi
suggest you spend a little money and get ExcelExperts.com to do this.. (there's a link for a Quote request on the left of the main page)
They've done hundreds of similar projects.
Thank you
Good to know. THank you for the response. I will definitely do that. If all else it doesn't hurt to see what it would cost.