You are welcome
Thanks for your Thanks AND for the Like
You are welcome
Thanks for your Thanks AND for the Like
Hi and Welcome to the Forum
You can add following Event macro to the Sheet Module
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub
If Target.Address <> "$I$34" Then Exit Sub
If UCase(Target.Value) = "PASS" Then
ActiveSheet.Shapes("Rounded Rectangle 4").Visible = True
Else
ActiveSheet.Shapes("Rounded Rectangle 4").Visible = False
End If
End Sub
As a reminder post #4 provides the answer to the initial question
Glad to hear the "No VBA" solution is fine with you
Thanks for your Thanks AND for the Like
Hi again,
Given the fact you do need to trap when Filter returns nothing, the best solution is to have your UserDefinedFunction
see :
Hi,
For sure the Forum can help you out
Could you summarize your general situation ... and explain the main obstacle you are facing ...
Hi DezB,
Attached is your test file ... with a tiny manual intervention ...
See if this fits the bill ...
Hi,
What is your own definition of "without having to use a macro" ...???
1. Either it means you do not want to have to run a macro ...
or
2. It means you do want the process to be Automatic as the date changes ...
Hi and Welcome to the Forum
If my understanding is correct, the process you could follow is to Filter your Database using Column A as your criteria ...
For each Unique Family id, you would get the respective file which you require ...
Does this make sense ?
Hi and Welcome to the Forum
Very pleased to hear that could help you out ...!!!
You are right : Ken PULS has designed a brilliant macro
Hi and Welcome to the Forum
Personally, never worked with OneNote ...
So did some research and located a couple of "potentially" interesting sites :
Hope this will help
No such thing as a stupid question !!!
Indeed, unlike Excel, Power Query has its own "engine" and does not update itself automatically ...
If the test file attached in post #8 (Test MarcoTex) does produce your expected result ... ( you have not answered this question .... )
probably the easiest solution, for you, is to copy your entire database from your current file to this test file ... and, then,
From Excel's main menu, just click on Data > Refresh All
See attached sample
Hi,
If your objective is to have a Search Function with the AutoComplete feature ... the best alternative would be a ComboBox ...
Just take a look at following explanation :
Attached is an example of what "grouping" actually means ...
Thanks, and sorry for the late reply, lets's try subgroups.
Hi,
Have the strange feeling your own idea about your final objective is, to say the least, not extremely clear ...
Hi,
Not sure to fully understand ... since it seems to me your new rules will boil down to retaining records between 5 and 99 ...
Another interpretation of your comment could be that you are after creating 4 sub-groups ....
Please clarify
Once you have tested out the M code, feel free to share your comments