I've done a lot of searching and found several similar questions and answers, but I haven't been able to adapt the answers in a way that works for me (actually, I've spent several hours on this and failed miserably).
I need to bill projects by the time spent and different hourly rates. I have created a sheet with 8 columns (A-H). Column C is titled Client. At month end, I need to create separate sheets for each different client in Column C that also brings along the info contained in Columns A, B, D, and E (but not F, G, and H) - this will serve as an itemized bill. I'd also like each sheet to have a cell that totals the amount of time (Column E) and another cell that shows the total owed (it multiplies the total time for each biller by an hourly rate for each biller (info contained on a separate sheet), then adds them all together).
I would attach a sample sheet, but I can't find a way to do so.
Thanks in advance. I've been a long time lurker here, and this forum has been invaluable. This is the first time a search hasn't answered my question, hence my first post.
Will
I need to bill projects by the time spent and different hourly rates. I have created a sheet with 8 columns (A-H). Column C is titled Client. At month end, I need to create separate sheets for each different client in Column C that also brings along the info contained in Columns A, B, D, and E (but not F, G, and H) - this will serve as an itemized bill. I'd also like each sheet to have a cell that totals the amount of time (Column E) and another cell that shows the total owed (it multiplies the total time for each biller by an hourly rate for each biller (info contained on a separate sheet), then adds them all together).
I would attach a sample sheet, but I can't find a way to do so.
Thanks in advance. I've been a long time lurker here, and this forum has been invaluable. This is the first time a search hasn't answered my question, hence my first post.
Will