I have this code
Path = "C:\test\"
Filename = ActiveSheet.Range("P7")
ActiveWorkbook.SaveAs Filename:=Path & Filename & ".xlsm", FileFormat:=52
I have this formula in one cell
What would be the formulas to display the five highest scores in five cells.
The names are in column C, scores are in column P
There can be identical scores.
Something like this?
The comboboxes and the textboxes are mandatory fields.
If you enter something in a combobox that are not in the combobox list you get an error message.
In the Warrant Number field you only can enter numbers.
The goal is to copy the rows that have an x in column G from the result sheets to the Jabpsheet, In the result sheets, there are formulas in column A like the formula above. But in the Jap sheet the formulas should be replaced with the values.
I used your code from # 4 but then I get what you...