Intelligent Macros (exclude values etc)

[testadimissile]

Hi Everyone,

i attach two xls:

- PERSONNEL LIST_EXAMPLE: files with macros activated.
- PERSONNEL LIST_MANUAL OUTPUT: output sheets filled manually to make understandable my needs.

The xls contains 3 sheets:

- source
- disembarks
- embarks

At the moment i have created two macros that copy, paste, sort and format in the two different ouput sheets (disembarks and embarks)

I have several problems:

Macros:

- disembark: shouldn't paste entries:
1) without disembark date;
2) with disembark date filled with text;
3) with disembark date before today (blue cell on top of sheet)

- embark: shouldn't paste entries:
1) with disembark date filled (both text or date);
2) with embark date before today (blue cell on top of sheet)

I think this could be challenging for all of you and i hope someone can help me.
Thank anyway to all of u

Marco

[BG1983]

Just make the source data a table and filter it accordingly for each - then copy only the visible data in the table.. all of this can be done by recording the actions and then cleaning up the recorded macro

[testadimissile]

Thanks for the reply BG1983.

I know that is the best and quicker solution but my boss disagree with me

Hoping that someone can help me thank you

[testadimissile]

no one?