date and time stamp

I have a power query ("Query - qry_Riders_Last_5_Years") located on sheet tab "Previous RolledUp Cost Data" which needs to be refreshed only once each workday. I prefer this to happen before everyone gets in and starts their day. This way, they can come in, open the tool and begin working...

Hello Gurus, I am currently working on adding a date/time stamp when things are entered into a column. So for example, if I enter something in column O, I would like the date/time stamp in column P. This following code seems to work most of the time, but once in a while, it stops working and...

I came across the below VBA and need some help to modify it. First it auto fills the date and time in I1 whenever you selected from a drop down in H1. I have also added another to it that adds date and time to cell J1 whenever you choose "Closed" in cell E1. This all works great for what I want...

Hi, I have the macro below to put a date stamp in a cell ("U") when the text in another cell ("I") is changed. This works fine. However the original cell "I" automatically populates with "open" when a new row is created within the spreadsheet and A date stamp is created at this point. Therefore...

I've tried searching but struggling to find an a remedy that works. - I use an Excel spreadsheet as a shared client database - each row being a separate client. - Each client row has a hyperlink, which links to a Word file in which we keep chat notes. Because there are 5 people who access...

Hi, I am trying to put in a formula to auto update my week number so my spreadsheet is one week in advance, I know to make it this week I use this formula: =CONCATENATE("WEEK:",WEEKNUM(TODAY())) My question is how do I take it from this week showing "WEEK 35" to working in advance so it would...

Hello I am trying to take data from specific cells on PBI_DATA_SORT and paste it into a new line in PBI_DATA_SORT_TRACKING with a date and time stamp in separate cells. I have been able to get it to copy from one to another but not with a date and time stamp. Sub Macro3() ' ' Macro3 Macro '...

I have a sheet where I would like for A1=the next workday (M-F) formatted as mm/dd/yy so if today is 1/3/2014 (a Friday) I would want A1=01/06/14 if today was 1/6/14 (A monday) I would want A1= 01/07/14. . Also it would be nice to have it not be something that is not like =today()+1 as I copy...

Hi everyone, I am new to Excel programming and I have a question regarding finding the oldest 2 dates in a specific cell. I am trying to build an application that automatically sends an email but can't seem to filter the 2 oldest dates which is why when I click on send, all the records are...

Hi all. I have research around the internet and finally found out Macro able to solve my issue. But im totally not a programmer. Hopefully someone can help me on this. I will scan QR Code with a scanner to cell A1 and wanted cell C1 to have date and time stamp for IN. When Scanner scan the...