Recent content by Darrell

On your Sheet3 code, I think this bit should have been If ActiveCell.Text = "DELETE" Then

Yeah I thought it was an odd way of doing it but his original request was to populate multiple sheets (1 sheet per year) and so I thought he was still going down that route. This request is a bit of a moving target to be fair...

OK looks you have decided to create the Workbook from scratch when the report is run. You will probably need to work out how many sheets to create based on the range of leave in your table, but I'm sure you can work that out. Gasman is right in that you are referencing the wrong object, this...

Try something like this.. Sub Macro1() Dim i As Integer Dim y As Integer With ThisWorkbook.Sheets("Sheet5") .Range("D3") = "Monday" .Range("D3").AutoFill Destination:=.Range("D3:ND3"), Type:=xlFillDefault y = 4 i = 1 Do Until .Cells(2, y).Address = "$NE$2"...

For what it's worth, here is a rough attempt at what you originally were looking for where the spreadsheet is updated after the Save button is clicked. I've based this on the following: - The Input form in access has: Staff ID (ie a unique number), First Name, Last Name, Leave Type, Leave Date...

Just curious but what happens when you have two people with the same name..?

I'd definitely take it the wrong way and slap Greta Thunberg :D

This might get you started. You'll need to put this in the Worksheet_Change of each sheet 2-5 Private Sub Worksheet_Change(ByVal Target As Range) Dim wReq_Sheet As Worksheet Dim sMat As String Dim iQty As Integer Dim sDesc As String Dim iLastRow As Integer Set wReq_Sheet =...

I think I've found the Anti-Beato...

Porcupine Tree knew

I don't think that's the case but will check when he's back from his holiday.

Yeah that's why I'm unsure if it's an excel specific problem. But I can be in the workbook in read only after I've selected 'Notify' (because it's told me that my colleague has it open for editing), and then sure enough about half an hour to an hour later I get a message saying that it's...

Not really no. The only people who use these workbooks in write mode are the two of us (not at the same time of course)

Another random problem that one of my co-workers is having is that he regularly will be working on a workbook in write mode and approx. half an hour later I'll hear him swearing and then showing me that his file has gone from write mode to read only. I've never seen this before and thankfully...