Hello
I have only just started using this forum and I could really use some help.
I am trying to create static timestamps in one column range "R" (R4:R56), dependent on/using a date entered in an adjacent column range "Q" (Q4:Q56) and data validation
input in R.
Using the data validation input...
I'm sure this has been answered as I've read similar post on this forum but none matched what I am doing exactly and I need to get this fixed quickly. I apologize if this is a repeat, but I have a simple formula on a cell that when the value of the cell is not longer empty, or an employee...
Hello All!
I am trying to build a excel sheet that can do the following.
When some one selects a yes or no (from the list) in Column B it than copies the Cell E10 and pastes special text/value only into the corresponding row Cell E.
Eg click yes on B4 pastespecial the static date and time E4...
Hello Excel World,
I have a workbook full of templates and when the workbook is opened I would like for the date field (cell d4) to auto enter a static (one that does not change) into the cell. Can someone please help the code to do this. I can get the date to populate but it changes to the...
Hi everyone. I have designed a spreadsheet in 2003 which uses staticdate in a formula e.g. =IF(C34="y",StaticDate()). It works perfectly fine in Excel 2003 but when I open it in Excel 2010 it returns the current date i.e. the date the spreadsheet is being opened on. When I re-open in in 2003...
<code>Hi,
Having searched </code><code>MANY </code><code>previous threads I have finally found the following code that was submitted by phamtom1975 back in Dec 2003 and it works wonderfully, where if 1 is entered into A1 then the current date and time is put into E1.
Private Sub...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.