Take Info from One Sheet to Create Multiple Sheets - Itemized Bills / Invoices

wad06

New Member
Joined
Jan 16, 2014
Messages
4
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
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
If it helps to describe the two operative sheets:

Sheet 1 ("Time")

Column A = Time Keeper
Column B = Date
Column C = Client
Column D = Description
Column E = Time
Column F = Notes
Column G = Total Hours
Column H = Final Notes

Sheet 2 ("Clients")

Column A = Client Number
Column B = Client Name
Column C = Blank Column
Column D = AAA (first biller)
Column E = BBB (second biller)
Column F = CCC (third biller)
Column G = DDD (fourth biller)
Column H = EEE (fifth biller)
Column I = FFF (sixth biller)
(Each biller column contains the rates for each biller for each client)

Thanks again!

Will
 
Upvote 0
This thread has gotten lots of views but no replies. Is this too complicated or time consuming? I'll admit openly that this would be the first VBA issue I've ever had, and I'm not sure how much goes into coding the solution. Is it something I should hire someone to do? If so, what should it cost?

Thanks,

Will
 
Upvote 0
One last bump for my old question...

This thread has gotten lots of views but no replies. Is this too complicated or time consuming? I'll admit openly that this would be the first VBA issue I've ever had, and I'm not sure how much goes into coding the solution. Is it something I should hire someone to do? If so, what should it cost?

Thanks,

Will
 
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,297
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top