Posts by Carim

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 :

How To Trap when Autofilter returns nothing

I couldn't really figure out how to title this, but here's a bit more in depth description. I have created a VBA code which will filter an excel file based on…

stackoverflow.com

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 :

How to Embed Excel Data into Microsoft OneNote

Thanks to Office integration, it's entirely possible to use Excel data in your OneNote notes. Here's how.

www.groovypost.com

Programmatically Searching in OneNote 2010

learn.microsoft.com

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 :

Excel Data Validation Combo box Click

Hi,

With your string located in cell A1, you can test following formula:

=MID(A1,FIND("last_price",A1)+12,FIND("change",A1)-2-FIND("last_price",A1)-12)+0

Hope this will help

Hi,

Once you have tested the formula ... feel free to share your comments

Attached is an example of what "grouping" actually means ...

Quote from PETRODATAjames

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