Probably requires a bit more testing but you could put this in you personal macro workbook or in the template if you have one Sub RowH() Dim Row...
Sorting I think that you can only sort on unprotected cells, which is kind of logical as you are changing them - although not really helpfull in th...
Can you please post an example so we can see what it is doing and how?
It was corrupted for me to, i wonder if it is becuase of the languge it was created in? What are you trying to do, loop through the LIST_WRONG shee...
I have done a 2 way lookup to return the current status of the child. 0 means the cell is blank, all the others are obvious. So know you have a ...
There will definitely be a better way with power query, where you can split on a number, but in the meantime, this seems to work on the small data set...
Hi Katerine If the first part of 1 character will always be ignored you can go with =IF(MID(A5,2,999)+0<=16,6,7) The MID extracts the number,...
How about a little macro to do it? Sub LookupDWG() Dim ws As Worksheet Dim DWG As String Dim i As Integer Dim LR As Long Dim c As Range Dim DWGr...
The code could stop at a vlookup if the workbook or worksheet doesnt exist (i acutally had that happen today). A file open dialog box opens for you to...
You have used merged cells which will only cause problems in a spreadsheet, i would remove them Your problem is that the reference table is not in ...
You need to post example workbooks at the very least - we cant even see a bill ref no. But even then it will be difficult to know why something is ...
I did remove the total column as it fundmentally changed the check. It now works with 4 rows
When working with US dates i normally change my date formatting to Long Date, so i can eaisly see if the formula has worked. Try =IFERROR(DATEVALUE...
As Mynda has confirmed that it cant be done with usual protection etc, so how about a Macro work around? Just click on the button to add more rows (on...
I think you want alll the yellow rows copied from the various worksheets to the first work sheet? If so try this Sub ListYellow() Dim s As Works...