Question about Excel (SS8SATAS5128400R)

2 Answers

Attendance sheet in Excel

I need to create 2 worksheet, In the first worksheet, i should have the team members enter time for the particular day. They should not be able to enter time for the next day or the previous day. In the second sheet the entered dat has to be consolidated and the total hours of each member has to be calculated, but the second sheet should be readonly.
Please tell me if a macro can be written to do the same, if yes please do share the code.

Thanks in advance!
KDina

Posted by on

  • pk4111971 Jul 06, 2008

    i want excel software to download in my computer

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

Hi KDina,

If you need me to work on this project for you please contact me at hdbas8@gmail.com

Posted on May 27, 2008

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Can you upload the worksheets so that we can take a look at them.

Posted on Jun 13, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

Have a used laptop excel asks for product key but i click cancel and have used the software but now it opens and i can't edit or do anything is there a way to fix it or is there a way to download another...


MS Excel is not afree program.
You will need to purchase a copy of MS Office which includes Excel.
For an alternative free program OPEN OFFICE is a full-featured officesuite that's compatible with Microsoft Office.
If you want Open Office you can download this free program.
Click on this link to download :-
http://www.openoffice.org/

Mar 03, 2011 | Excel (SS8SATAS5128400R)

2 Answers

Excel formula creation


= (a3) minus (b3) won't do it for you?

Sep 05, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Excel question


You can import data from one sheet to another. If you want to bring a total from Sheet 1 to Sheet 2, then in Sheet 2 enter [=sheetname!cell] (without the brackets of course. You will now have the data from Sheet 1 in a cell in Sheet 2 and you can do anything you want with it. One note: if the sheet name has a space in it (Sheet Name) you have to enclose the name in single quotes; that tells it that the whole thing is the name. For example, Monthly Sales, A10 is the total for last month; to put it in this month for a running total, you would enter in Sheet 2 ['Monthly Sales'!A10] (without the brackets again). Now you can have a running total between the two sheets.

Aug 19, 2008 | Excel (SS8SATAS5128400R)

1 Answer

HELP with macro config


Hi Hss Holdings,

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table
table_to_check = the table you want to find the data from
column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.
range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here
B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)
G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)
etc

Jul 12, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Prevention of delition of cell which has a formula


If you right click the cell in question and go to Format Cells..., on the protection tab there should be a check mark in the locked box. Go to the tools menu and choose Protect and Protect Sheet, enter a password and your cells will be protected.

Any cells you want to allow changes to when the sheet is protected should have the Locked checkmark removed.

Jun 16, 2008 | Excel (SS8SATAS5128400R)

2 Answers

Version Tracking in a workbook


Hi blackhand18,

This might be different on your version of excel but try this

=INFO("release")

Jun 04, 2008 | Excel (SS8SATAS5128400R)

1 Answer

FORGOT THE PASSWORD


Hi SAKHIE

You need to run a utility, link below
http://www.straxx.com/excel/password.html

May 07, 2008 | Excel (SS8SATAS5128400R)

3 Answers

Excel password removing


could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

5 Answers

Excel


If you don't have MS Office, then you will have to purchase either the Excel component as a stand alone but you would be better off with the whole MSOffice as it contains your Word processor, Database, Excel, Powerpoint presentation software and in the 2003 version also Publisher.

It is not too badly priced anymore, but if you cant afford it then you may be able to borrow a copy whilst you are doing your course from a friend, but you will have to uninstall it afterwards.

Oct 26, 2007 | Excel (SS8SATAS5128400R)

Not finding what you are looking for?
Network Storage Systems Logo

Related Topics:

2,107 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Network Storage Systems Experts

Geoff

Level 3 Expert

413 Answers

Brad Brown

Level 3 Expert

13536 Answers

Daily Mehdi
Daily Mehdi

Level 2 Expert

48 Answers

Are you an Excel Network Storage System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...