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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How do I pull a figure from a spread sheet and add it to another in the same file.....


Are you talking about different worksheets in the same file.
go to the other worksheet then go to the particular cell and press = on keyboard
then use mouse to select the other worksheet from the bottom of the spreadsheet .
Then click on the cell you wish to link and press enter key on keyboard.

https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2

You can also do this to spreadsheets with different file names by opening both spread sheets in different windows and switching between the windows.

you can also copy just the data by copy whole sheet (click on the square in top left hand and copy and then right click paste special on new worksheet - with values only rather than the original formulas from the spreadsheet

Jan 06, 2017 | The Computers & Internet

Tip

Excel- Unhide All Sheets


Advanced Hide Options

When we hide worksheets using, still user can right click on tabs and un-hide the worksheets. For example, following example will hide the worksheet and user can un hide the sheets on right click on sheet tabs:
Sub sbHideSheet() Sheets("SheetName").Visible = False 'OR Sheets("SheetName").Visible = xlSheetHidden End Sub What if you do not want to permit users to un-hide worksheet, you can set the Visible property of worksheet to xlSheetVeryHidden and lock the VBA code. so that user can not un-hide the worksheet. The below example will hide the sheet and user can not see it in un hide worksheet dialog list.
Sub sbVeryHiddenSheet()
Sheets("SheetName").Visible = xlSheetVeryHidden
End Sub

on Dec 09, 2016 | Microsoft Excel for PC

Tip

7 tips we've learned in setting up and using our team Web site.


In this article, I'm going to give you 7 tips we've learned in setting up and using our team Web site. These tips can help you get up and running productively as quickly as possible with your site.

Note: Windows SharePoint Services is a great, and underused, tool for managing teams and team projects. You can use it to create a team Web site to track objectives and projects, as well as have a central location for storing and collaborating on documents.


Example of a team Web site created with Windows SharePoint Services.

1. Create folder names that are clear and consistent

Organize site folders by whatever makes the most sense for your team. The key is to be clear and, above all, consistent. For example you could choose to organize:

* By department
* By objective
* Alphabetically
* By clients
* By project

We also create a new Document Library folder in SharePoint for each project. We can store all of our files related to a project in a Document Library. This not only helps keep our files organized, but makes it easier if a project is reassigned for the new owner to take ownership of all the associated materials.

2. Develop standards for naming files

Decide as a team how you want to name your files. For example, you can insist that a date be attached to each file, or that the person who created the file put their initials in the file name. Also, you can take advantage of the fact that you can use long file names for files and SharePoint folders. Be sure to publish your naming structure so that everyone on the team knows what it is. Above all, be consistent in reinforcing and using this naming convention. This is critical. We’ve found that if you don’t, your team won’t know how find files and therefore won’t use the site effectively.

3. Keep only the latest versions of files

Develop an archive folder system for keeping previous versions of files for historical or version control needs. We keep only one current version in our “active” folders. This clears up any possible confusion over which version of a document should be used, particularly when your team members download files to their computer to work on while they're traveling or working out of their office.

If your team members do copy files onto their computers, you need to take extra precautions to ensure you only have the most current versions of their files on the team Web site. If team members keep versions of files on their computer, they should change the file name. That way, if they upload the file at a later date, they will not overwrite something on the team Web site that might have been edited in the meantime.

4. Give clear ownership of each section of the team Web site

Give each folder a single owner who can add files to it. We find that this ensures the integrity of naming and file structures within each section of the team Web site. Multiple people may edit documents in various folders, but we make sure no one else uploads new documents or creates new folders inside a folder owned by someone else.

5. Check out and check in files

You will probably have a number of files (like sales data) that are accessed and edited by several team members. While SharePoint won’t allow multiple people to save an open file, it is possible for a person to open a file while someone else is editing it. Unless the file is checked out, you run the risk of more than one person working on the same file. One or more people may end up doing work that can't be properly saved. And if a user doesn’t check the file back in, then others can’t access it. Learn how to:


Make sure you check out files on your team Web site before working on them.

6. Clearly describe folder contents

As people on the team change, they will need to know what they can expect to find in different Document Library folders. Because we include a clear description of each folder, the new team member knows what's in each folder and can find the documents they need to get up to speed a lot faster. This has been really useful to us when an account grows large enough that we add another consultant to the team. We also modify the descriptions when we complete a project. We designate the library as containing archive information rather than active information.

Clearly describe each folder in your Document Library.

To put in a detailed description of a Document Library:

1. Click on the Document Library you want to edit.
2. In the Document Library you want to edit, in the left navigation, click Modify Settings and Columns.
3. On the Customize page, in the General Settings section, click Change General Settings.
4. This takes you to the Document Library Settings page, In the Name and Description section, type in the description of the folder. Click OK.

7. Link to files in SharePoint folders

When you're working on a project, it’s easy to just insert a file from the team Web site into an e-mail. By sending out different versions of the same file, however, you could end up with multiple versions of the same document. It's far more reliable to just insert a link to the document in your e-mail. You can also put links to SharePoint documents into a task in Microsoft Office Outlook, or into an appointment on your calendar.

If you store multiple copies of a file on your team Web site, it's also easy for one copy of the file to get modified and leave the others out of date. Instead, we make sure we only have one version of a document and link to it from other places when necessary.

To put a link to file on your team Web site into any Microsoft Office document:

1. Locate the document you want to create a link for. Put your cursor over the document name until the file name turns red.
2. Right-click on the red file name and in the drop-down menu and click Copy Shortcut.
3. With your mouse cursor in the body of your task, appointment, contact, documents folder, or in another file, right-click and click Paste. This will paste the link. When you click on the link, it will open the actual document.

Put links to documents on your team Web site rather then putting different versions in multiple locations.

To put a link to file on your team Web site into another part of the Web site:

1. Locate the document you want to create a link for. Put your cursor over the document name until the file name turns red.
2. Right-click on the red file name and in the drop-down menu and click Copy Shortcut.
3. Navigate to the folder you want to include the link in. Click New Document. SharePoint will open a new document called "template.htm" in Microsoft Word.
4. Paste the shortcut into the new document. Select all of the text and right click on it.
5. Click Hyperlink... and type in the text you want in the Text to display box (for example, "Click here to see the final version of this presentation.") Click OK.
6. Save the file. When anyone opens this file, clicking the link will take them to the current version of the referenced file.

I hope sharing some of the lessons we’ve learned will help you get a head start on your own team Web site.

on Dec 28, 2009 | Computers & Internet

1 Answer

Mutual Circles Required For Each member of My Circle?


Hello Harry Verstandig ,
Very Interesting and Intelligent Question from your side dear. Your question shows you are a real social media user .

Firstly I would like to answer Your 2nd Question -


Solution -2 ,Answer is Big YES, To use Google + You need to have Gmail /Google Account First .


Solution -2 If You have resolve 2nd question then Its very easy now .
Go to desired User[g +] then you will find a button on his/her profile page = ADD IN CIRCLE. click on that and then you got options to choose particular circle for this human . Hence Solved .


Solution -3 Yes they have to create circle .[ Google already provides some default circles you can edit them or delete them to make circle game according to your,s need

Dear I hope you will satisfied with my answer , but if still you have any thing in your mind please feel free to ask me in comments and don;t forget to vote me thanks

May 26, 2012 | Computers & Internet

1 Answer

Where do you see your new create character And what is the codes


Hi there Arjay,

You will see your new create character when you start a new game. As for the codes,

1. Enter the following codes by choosing "Features", "Extras" and then "Codes"

  • 2ksports - Unlock the 2k Sports Team
  • 2kchina - Unlock the 2k China Team
  • Payrespect - Unlock the ABA Ball
  • nba2k - Unlock the NBA2k Development Team
  • vcteam - Unlock the VC Squad
  • icanbe23 - MJ: Creating A Legend
  • payrespect - ABA Ball
  • agsntrccai - Bobcats Nascar Racing Uniform
  • aifnaatccv - Cavs Cavfanatic Uniform
  • wasshcicsl - Hardwood Classics Uniforms (7 teams only)
  • asrdirmga - Hornets Mardi Gras Uniform
  • eydonscar - Secondary Road Uniforms (Grizzlies, Hawks, Mavs & Rockets)
  • riiasgerh - St Patrick's Day Uniforms (Bulls, Celtics, Knicks & Raptors)
  • ycprtii - Trail Blazers Rip City Uniform

Feb 18, 2011 | Take 2 Interactive NBA 2k11 for PSP

1 Answer

Describe the each part of microsoft excel 2207


anmolsxn_0.gif
Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

1 Answer

Hi. By the grace of Almighty it is hoped that you and your family members would be in good health. I need a link to download a multiple sheets Excel Workbook to manage our daily sale, inventory and...


Here are your links Sales
http://www.brothersoft.com/sales-management-report-spreadsheets-for-excel-366701.html
Inventory
http://www.brothersoft.com/downloads/inventory-spreadsheet.html
Purchase
http://www.spreadsheet123.com/ExcelTemplates/purchase-order-template.html

Jun 26, 2010 | Microsoft Office Excel 2003 for PC

1 Answer

Excel 2007: Conditional formatting


did you put the sheet name in your reference? ex =Sheet2!A1 or you can name the cell ranges on the other sheets and use the cell names in your conditional formatting formla.

May 08, 2009 | Microsoft Excel for PC

1 Answer

Closing Worksheet on executing Hyperlink command


You could do this by creating a close button with the worksheet- Do this via insertin ga prompt in Macro.

Dec 20, 2008 | Microsoft Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

2,109 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Computers & Internet Experts

yadayada
yadayada

Level 3 Expert

71694 Answers

Brett Duxbury
Brett Duxbury

Level 3 Expert

3375 Answers

Bill Boyd

Level 3 Expert

39158 Answers

Are you an Excel Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...