Posts by Carim

Hi,

Attached is an image where you will see, on the right side : CREATE THREAD

Sadly you have decided not to answer the questions ...

And since you are only providing important information very sparingly ...

After 14 messages .... we have yet not reached the Start Line ...!!!

Recap

1. Date in Column A is the triggering input

2. Index # in Column B is a Date Ranking formula with no Ties

3. Columns D, E , F are the filtering criteria

4. Columns G and H are simple data

Questions :

A. Are you manually adding Dates in Column A or are you copying them from another source ....???

B. How many "X,Y,Z" or "Columns D,E,F" do you actually have ...???

C. How many "Color, Size" or "Columns G,H" do you actually have ...???

D. To handle everything without formulas, could a macro be suitable or not ...???

Thanks for taking the time :

1. To read the Read the Recap

2. To validate or not to validate my understanding

3. To answer the 4 questions

Glad you could fix your problem

Thanks for your Thanks ...AND for the Like

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

Hello,

There are only two possibilities ...

Either you do not need to make the difference between the First Name, the Middle Name and the Surname .... or you don't ...!!!

Attached is your Version 2 ... with the two possibilities ...

Hope this will help

Thanks for your Thanks ...AND for the Like

Hello Rajan,

Attached is your test file

Hope this will help

Hello again,

In order to deal with your objective of SBLO = Skipped Between the Last Occurrence ...

... and not reinvent the wheel ...

Why not attaching a sample file ... to illustrate your point ... and to show your expected result ...

Hello again,

In order to base the discussion on something concrete ...

Attached is your initial test file where, as requested, all formulas have been deleted ...

In your main worksheet Data, you do need to fill in your Column A with X, Y, Z in order to automatically generate your three "extract" sheets ... please note Columns E and F do need to be populated ahead of your inputs in Column A ...

At this stage, all the questions listed in message #10 remain valid, since many things do depend a lot on your operating process, especially since your sample database does not seem to be built with a Unique Identifier ...

Hope this will help

alansidman

Thanks for the M code ...

Hello,

Thanks for reading the Forum Rules

Forum Rules

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

Quote from leap-out

Carim your code is astonishing this is the best answer

many thanks

Glad this could help

Thanks for your Thanks ...AND for the Like

Quote from leap-out

Carim your code doesn't disable it just changes the font color

Hello again,

Sorry ... but the macro is disabled ...

see attached your test file

Hello,

You could test following

Hope this will help

Hello again,

Attached is your test file

Hope this will help

Thanks for your sample file

What is better than one example ...?

Two examples ...

In order to completely eliminate all formulas, we have to focus on the core principle of your entire workbook.

Quite obviously, X,Y,Z, Colors and Sizes are only a way to generically describe your actual workbook structure.

My understanding is that your Data worksheet is the Main sheet, and it is holding all your inputs.

All your other sheets are partial extracts based on a given criteria.

So, the very first questions are about your real-life input process and your needs:

- Do you manually add new records to your database ?

- Do you need a live update, i.e. record by record ?

- Do you need a bulk filtering solution which would create all your other sheets, based on the Main one ?

- Do you need to be be able to modify an existing record and see it automatically updated in its destination sheet ?

Thanks for all your clarifications

Hi,

May be you could give a try to following

Hope this will help

Attached is an overview ... which ... I hope... will help clarify the most important aspects ...

Should you have specific questions ... do not hesitate to post back