Does anyone know how to set up a payroll spreadsheet that not only calculates
hours and wages, but also tips?
I need it it to do all of the taxes as well.
Pretty much the normal payroll spreadheet, but claiming earned tips as well.
Excel 2003. I had this working years ago but have since forgotten how to do this.
I need to start Excel 2003 two different ways depending on one of two short cuts used. In one case, I want to start Excel 2003 and automatically load files in the start-up folder. In the other case, I want to start Excel 2003 but not load any workbooks automatically. Any help would be appreciated. Thanks.
What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards
J-O
My business users dont know access at all so I need a easy way for them to import excel sheet to specific tables.
Planing to develop this functionality in one of the 2 ways
Design 1 -
I plan to have a a separate button for each file type. When a user press this button a small window should pop-up asking user to browse the file to import. Once user browse and selects the file, he press the import button which should trigger a query to append this data to an existing table.
Design 2 -
Similar to design 1 but instead of user browsing to search the file, there will be specific folders on C: for each file type where the user will put these files. then on the form all user has to do is hit the import button to import this data.
Please advice how to develop these designs.
Thanks
SKV
Guys,
I am new to the forum. There is alot of valuable information here. Anyways I would like to ask for your opinion if this can be done. I have a excel workbook with customers names, email address, SR and RMA numbers, Part that was shipped and qty. It also contains when it was shipped. This sheet has decent amount of data in it. What I would like to do is email the outstanding parts that have not been shipped back from excel that contains a message to the customer and with the parts below that need to be returned. I would like it to update a ticker in excel that once I have hit the send button 3 times then the button is greyed out. Can this be done? I have already seen a vba macro that sends the rows out to outlook but I want it to contain all the customers outstanding parts instead of sending a email for each one. If someone can help me I have the form to show you.
Regards
Corey
Hi,
Can someone please tell me all the different ways in which an Excel Workbook can be shared for multiple users to edit?
Thanks.
Dan
Hi,
Can someone please tell me all the different ways in which an Excel Workbook can be shared for multiple users to edit?
Thanks.
Dan
...this is a bit of an unusual post I suppose. I am curious if anyone has had any luck with outsourcing NON-COMPLICATED Excel work and if they had tips or advice on how to go about it.
I have an Excel file with over 300 tabs of report data that I am looking to make a database out of. I want to hire someone (I was thinking of using elance.com) but it isn't very sophisticated work. It would mostly be formatting grunt work.
Thanks for any suggestions or advice!
Kind regards,
Jake
Can i set auto recovery for Excel?
Thanks in advance
