occasions

Hello - I have a macro with the following signature: Sub Create_Table (Optional ByVal WCP_Special As Boolean = True). While this macro is typically called from another macro most of the time, there are some occasions when I want to call it as a standalone. However, I am unable to do that...

Im having trouble trying to exclude the weekdends from my sickness occasions formula {=SUM(IF(FREQUENCY(IF(B1:B365>=(A1-365),IF(D1:D365="Sick",ROW(D1:D365))),IF(B1:B365>=(A1-365),IF(D1:D365<>"Sick",ROW(D1:D365)))),1))} Sick database looks like Date 01/01/19 Sick 02/01/19...

Currently, I'm spending many hours reading a report and hand-typing values from the report into an Excel spreadsheet. I do this for each day of the year. It's quite time-consuming and I'm looking to find a faster approach. The report is in PDF format, but I can export it to Excel. Here is an...

Hi This is my first question. I have a command button (SaveChangesBtn) that I wish to set focus to under certain circumstances. On many occasions the button works fine, but occasionally I get an unspecified run time error. It is at the following point in the code POpenIssuesRowID = r.Row -...

Hi I have a simple code i want to call in several occasions. Is it possible to change "qwr" when calling it? ActiveSheet.ListObjects(1).ListColumns("qwr").DataBodyRange.ClearContents Cheers!

I have a lot of data which shows what dates staff have been sick.. a bit like what is below: I want to be able to get Excel to recognise where a sickness for an employee is greater than 14 days on the data below. I was thinking IF(AND(something something something),"LTS","STS)... but I can't...