I need to have a ticking clock by seconds in cell A1 on Sheet1.
This cannot have the current date associated with it. It needs to only show the time because I am using specific times in A4:A200 for employee report times, and in column B an IF statement
that show if an employee check in late. Column F will be used by our supervisor and they will simply mark an 'x' when the employee reports in for their shift.
I would like this macro to start automatically when a user opens the workbook, and stop when they close it.
I trying to figure a formula to convert time on a phone call eg. 01:01:21 into total seconds (3661). Phonecalls will never be more than an hour long but the spreadsheet I will be supplied with (havn't got it yet!) will display them in the 00:00:00 format.
I am trying to convert a number of "hours" "minutes" and "seconds", to give me a result in seconds only, in order that I may then financially cost the amount of time spent on a task. (A time and motion costing exercise)
Example:
1119:48:06 Represents 1119hours:48minutes:36seconds spent on a task.
I can manually convert this to 4031286 seconds, but it just takes too much time !!!(sorry!)
The data is extracted from a database which is unable to split the hours,minutes,seconds into seperate fields, which prevents me from using three cells in excel.
I am using the below code and it is not performing the operations of comparing and deleting the duplicate values from sheet1 and pasting unique values in sheet 1, p.s. Do not need values from sheet 2, just want to compare the sheet 1 with 2 and delete dups in sheet1.
I have a date base that is used as a job status board developed in excel that has locations, times, clock and other areas. What I am looking for is a way of playing a sound when the time approaches 5 min before the time in the excel cell that has been entered into the job status board...
Sheet1 Column1: contains the word "dog" Column2: contains the word "bark"
Sheet2 Column1: contains the sentence "I like dogs a lot." Column2: is blank
What I need to do is search Sheet2/Column1 for the presence of "dog" and if it's present, populate the word "bark" in Sheet2/Column2 from Sheet1/Column2.
1. Create a worksheet for each set of tables (Sheet1: 2x table, Sheet2: 3x table etc) 2. In field A3 (e.g.), I'd type (Formatted as text): 2x1= 3. In field B3, he'd have to type the answer. To prevent him from using the cell as a calculating tool, it will be formatted as text (courtesy of Prevent Someone From Entering A Formula In A Cell) 4. He'll start the test by clicking a button that says "START THE TEST" (or something more exciting, like "Earn some money!"). I'd like a macro to select the first cell (This I can do, believe it or not! :-)) and then, after, say 5 seconds, jump to the second cell, then the third etc up to the last cell (2x13=) 5. Despite the timer, the active cell must be allowed to be changed to the following one (one down) by pressing "Enter" (In other words, if the timer is set at 5 seconds and Jonathan enters the answer in 1, he may then press enter and move to the following cell immediately) 5. He can only enter the answer in the cell while highlighted and I'll have the whole sheet protected once the macro has done its run to the end or once he's answered the final question and pressed "Enter".
I currently have a lot of times saved in an excel file that are in seconds for example 245.9 seconds. Need formula where i could have in the next cell to it where it would say 4 minutes 5.9 seconds.
Sheet1 is a list of names, then a few columns of numbers. Sheet2 contains calculations based of the numbers in sheet1.
Each sheet from 2 on is names after the names in sheet1 column A... A large cell at the top of each sheet contains the formula to display the sheet name: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
So what I want to do now is... in cell, look for the cell in sheet1, and display the value in the cell offset by X so i can bring the numbers from sheet1 over.
In plain english the cell would say like... "look in sheet1 for "Name" then display the cell next to it"
I know to look in the next sheet its "=Base!B2" if i wanted b2 on sheet base. I know to use "=OFFSET(Base!B2, , 1, , )" too look at B2 and go right 1 column. But the issue is i dont want Base!B2.. i want whatever cell in Base column A that has the text that A1 has.
1) I am doing multiple sumproducts on 6 sheets within a workbook with last row now being in the 12,000 cell range. Since putting in this SumProduct, my excel is extremley slow and affecting other windows applications. Is there anything I can use to replace this sum product ?
It seems to be starting the calculations even before I put any values in column D ? I have already tried the manual calculation, but it is not making much of a difference.
2) After doing the sumproduct, I then need another row to look at the value of the sumproduct cell and report it in another sheet. My problem is that the cell contains the date and time in 1 cell, but in order to get the cell to lookup the value properly I need to delete the 00 in the seconds to refresh the cell or else it gives me back an n/a# value, even though the seconds are 00 and not 01 or 02 etc ?
I have a value in a cell in Sheet2 (in this case its price per ft), on sheet1 is where I would input the number of feet. So can I multiply from data in cell on Sheet2 from cell on Sheet1and if so....
I need a macro which read out the last (in this file Pos. 4) or a user seleted Position (Position 2 or 1). The macro should read out the cells in this row and put the data into the defined cells in Sheet2.
in this case:
Data from B4[Sheet1] copy to B5[Sheet2] Data from C4[Sheet1] copy to C7[Sheet2] Data from D4[Sheet1] copy to E6[Sheet2]
The cells in Sheet2 are the same every time. Only the data (the row) in Sheet1 does change. I add more Position every week in Sheet1.
I have a workbook with sheet1 and sheet2. Each sheet I am only dealing with columns A-D. The data in column A in both sheets is the unique identifier. The below macro I am using will take sheet1 (ColumnA) and compare to sheet2 (ColumnA). If the identifies are the same in both cells it will highlight it green.
What I need to add to the below macro is the ability to add a cell copy over. So sheet1 being my master, if sheet1 and sheet2 have a equal identifier in column A, the data from sheet1 B,C,D for that row will be copied over to sheet2 of its equal identifier sheet2 B,C,D.
I have I workbook that contains 2 sheets. The first sheet "Business Objects" is the master list. The second sheet "Gene" contains similar data but is incomplete. There is a unique identifer for both sheets and that is item ID. what I would like to do is look at the Item ID column on sheet1 compare it to SS# on sheet two and copy any rows from sheet1 to the end of the sheet in sheet 2. I have found in my searches on this forum a bit of code that identifies the ones in sheet1 that are not in Sheet2 and highlights them red(which is not neccessary for me, but I am struggling to figure out how to take that and paste it to sheet2.
Is there a way to have it show the number of days, hours, minutes and seconds? So it will say 45:1:23:42? (45 days, 1 hour, etc...) Or something along these lines?
Is there any way to make one cell on a separate sheet appear EXACTLY the same, including formatting and values? As in this for example: Copy this value and formatting
I would like to keep the formatting, (color and bold), but I have not figured out how to do this. I read a couple other posts but could only copy the values but not get the formatting to also copy over.
i'm trying do is have information from sheet1 copy to sheet2 upon selecting a value from a DV list. Based on my attached sample, in Column J, upon selected "Yes", I would like to get the information from A6:H6 copied to sheet2 in the same row. I've tried it with the "if" formula and writing a macro for it.
I have a workbook name Sample and I want the code to run when its opened and it should check the first sheet "Sheet1" in all the workbooks in the folder C:FolderTemp.
And if the first sheet name is not "Sheet1" then just ignore that workbook and move to next workbooks. If the first sheet name is "Sheet1" in a workbook then store the value present in cell B1 in Sample workbook "Sheet1".
So if there are 5 workbooks in the folder C:FolderTemp and two of them hasn't got first sheet named "Sheet1" then display value of B1 in rest of the 3 sheets to the "Sheet1" of "Sample workbook" one after another.
