Question about Excel (SS8SATAS5128400R)
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!
Can you upload the worksheets so that we can take a look at them.
Posted on Jun 13, 2008
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.
Posted on Jan 02, 2017
Tips for a great answer:
Nov 15, 2010 | Microsoft Windows XP Professional
Sub sbVeryHiddenSheet() Sheets("SheetName").Visible = xlSheetVeryHidden End Sub
on Dec 09, 2016 | Microsoft Excel for PC
Jun 26, 2010 | Microsoft Office Excel 2003 for PC
Jul 14, 2009 | Microsoft Excel for PC
Dec 20, 2008 | Microsoft Computers & Internet
Nov 05, 2008 | Microsoft Windows XP Home Edition
Apr 25, 2008 | Computers & Internet
Jan 01, 2008 | Microsoft Office Standard for PC
Mar 23, 2017 | Lenovo Computers & Internet
2,107 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: