20th

Hi All, I control a monthly sales forecast - sales people enter their forecast for the month but then can amend this at 2 dates in the month (approx 10th and the 20th), it is then fixed. I need to track the changes they make; example. Cell B1 they enter £100,000 for June On the 10th they may...

With Sheet1.Range("C7:C1007") Set rngFind = .Find(what:=CDate(Me.Rw2.Text), After:=Sheet1.[C1007], LookIn:=xlValues, lookat:=xlPart, SearchDirection:=xlNext) End With This is a line in my code Some dates are not picking. From 20th upwards does not work. But below 20th works fine. Can...

Hi, Thank You in advance for reading this and the help. I am not an expert in excel. I am sure this is an easy formula but I can not get it to work. I have two list that I am trying to combine. I would like the formula to search the list to the left and return the phone number for the matching...

I have a list of dates in column A and need to identify (probably by conditional formatting?) which dates occur between the last but one 21st of the month and the last 20th. Thus if today's date is the 21st September, entries in the list between 21st August and 20th September should be...

Hi, I am not even sure how to search this. I can find COUNTIF statements but they re only good to tell me how many days fall between before the 20th. Sorry if this is a dimwit question! Thanks in advance!!! :)

I have a workbook that is thousands of rows long. I am looking for a VBA script that will put an "X" into every 20th cell in column E. The first row is a header so this means that I need to add an X into column E on rows 21, 41, 61, 81 101 and so on. After that I need to cut ever Row that has...

Hello guys, I have totally 30 macros for processes. I have 2 processes 1st consists of 20 macros and 2nd consists of all 30 macros. In my 20th macro i have given a message box as completed. For my 2nd process i want to continuously run the macro after 20th to 21st without message box. Now i am...