Hi,

I have been struggling with Excel 2007 for a while now. I file timesheets every month and I have to convert the self-calculating Excel sheets I use into pretty, formatted ones for the clients. I have been trying autofilter and advanced filter and I don't think either can do exactly what I need it to, although both are close.

I have 6 columns of data in the source sheets (the timesheets), namely date, from, to, hours, client and task description (this may change a bit). I would like to create another sheet in the workbook, which would be neatly formatted and later exported to PDF (the invoice). I imagine I would type the name of a client (or select from a drop-down list, but only if this could be hidden) into the invoice (somewhere near its header), upon which those lines from the timesheet that contain this name in their "client" column would be filtered and filled into the prepared spots in the invoice. A third sheet might be used in the middle, perhaps to simply copy the selected lines to and the invoice could then draw easily from there.

At this point, the best results I had were with autofilter, filtering out the relevant lines from the timesheet and manually copying them to an empty "source" sheet from which the invoice could draw all the relevant data.

Advanced filter is also good, as it can do the first step - copy the rows to a separate sheet, but it doesn't dynamically update - I would have to define the filter each time over again.

I would prefer to avoid macros, since I would then have to teach my employer to use them, but if they are the only way to achieve this, I will welcome any help in that direction as well.

Is there a way to either somehow automatically copy the results of autofilter, or automate advanced filter to refresh whenever the criterion cell changes?

Thank you for any advice,

Jenda