Search : in
By :

Excel spreadsheet

Last answer on Oct 13, 2008 5:12:03 pm BST max, on Oct 13, 2008 2:27:04 am BST 
 Report this message to moderators

Hello, I am trying to create a spreadsheet for employees schedule. I want it to be able to give me the total hours at the end of each week. It is a montly schedule with their names. Also, I want to be able to put a code in representing the shift they are suppose to work that day. How do I do it? Also, can I use Visual Basic to create a employee schedule?


Thanks.

Best answers for « Excel spreadsheet » in :
Inserting an animated gif in Excel Show Inserting an animated gif in Excel To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control. To insert the control, go to the View menu/Toolbars/Control Toolbox Activate the first button Design...
Index and matching 2 different spreadsheets Show
[Excel]Storage name and path of a spreadsheet Show [ExcelStorage name and path of a spreadsheet The tip below will show you how to automatically show the storage path and the name of any spreadsheet Enter in a cell (E.g cellA1) the following formula: =cell("filename", A1)...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Excel - Comparing columns and returning value ShowExcel - Comparing columns and returning value Issue Solution Note Issue I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A B C D ...
Excel – How to extract partial data? ShowExcel – How to extract partial data? Issue Solution Note Issue I have an Excel spreadsheet that contains around 1500 html links. All the addresses start out common... i.e. http://www.frogs.com/. What I want to extract into another...
Download ABC Amber Excel Converter ShowDo you know that your Excel spreadsheet can be converted into any format? Only ABC Amber Excel Converter can gather these many conversions into a single application. ABC Amber Excel Converter is a program to convert your XLS files into several...
Download Ulead GIF Animator ShowFor your Web site or your PowerPoint presentations, you need animated GIFs to cheer up your pages. Ulead GIF Animator is the most successful and accessible program in term of creation of animated GIF. It allows to create a simple animation sequence....
Download Excel2mysql Show
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Introduction to Spreadsheet Concepts ShowWhat is a Spreadsheet? A spreadsheet (or spreadsheet program) is software that permits numerical data to be used and to perform automatic calculations on numbers contained in a table. It is also possible to automate complex calculations by using a...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

nees21, on Oct 13, 2008 12:16:11 pm BST

Why dont you use macros in doing that? do you know how to do that if not then just post an add here and i will try to get one for you

see you

   
Reply to nees21

2

Max, on Oct 13, 2008 3:00:37 pm BST

I have never used macro's but if you could show me how to use them I would appreciate that.
If it helps me to create a employee schedule that would be great!



Thanks,


Max

   
Reply to Max

3

john, on Oct 13, 2008 4:21:18 pm BST

Hi,
You can find online templates on the Microsoft website or in MS Ofice Publisherf

   
Reply to john

4

 max, on Oct 13, 2008 5:12:03 pm BST

Thanks John for your help!


Max

   
Reply to max
Ask your question Reply
They need your help