Auto populate invoice from time sheet

**benswelding** · 04-30-2010, 08:35 PM

What I am trying to accomplish is to populate my invoice from information in my time sheet,that are all on the same worksheet. I seem to be stuck on getting it over there. though(eg)I want to populate v:22 to v:35 with information from b13 to b31 with matching costs from formula sheet cell e1 to e 16 taking the hours from I 13 through I 31 and putting them in w 22 tow 35,and also be able to count how many times a specific word is entered in b13 through b31 and put the total in corresponding cell in t 22 through t 35. My goal is to populate my invoice from my time sheet without touching my invoice. I also have macros to print invoice ticket and time ticket separately but I left them off because of size. Any help would be appreciated. Thanks Ben

**ratcat** · 05-01-2010, 09:10 AM

G'day Ben

Is this what your looking for ?

**benswelding** · 05-01-2010, 10:04 AM

Yes Thank you very much for your help.

**benswelding** · 05-01-2010, 10:21 AM

Do you thing it would be possible to hide my invoice so I never see it with a macro button beside my timesheet that would Print the hidden invoice.Thanks in advance

**ratcat** · 05-02-2010, 02:56 AM

That's entirely up to you and if there is other users to discuss.

Originally Posted by Forum Rules

Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

Cheers

RC