VBA/Macro Save rows (based on criteria) as value to new sheet in closed workbook(s)...

[blak9]

Hi there,

I've been struggling with this for a few days now, trying to remix several scripts into something that would fit my purpose. But as a total VBA noob, i'm really stuck and could use your help.

Let me explain what the issue is...

I've got a Workbook Source.XLS, sheetname Source with a list of employees (last, firstname) In Column A & B, defined by UK and BE in column C and several columns with info in columns >= D. The list starts on row 5.

I'm looking for code that would copy (values only) the rows of the BE and UK employees into (closed) Workbooks BE.XLS and UK.XLS respectively, in a new sheet before existing sheets, where each new sheet would be named after a date in cell A1.

All three sheets are in the same folder, and it would be sweet if something like ThisWorkbook.Path & "\BE" could be used, to prevent the macro from not working when someone else copies the folder.

Your help would be appreciated very much
Mike

[PaulM100]

You need to open the workbook, add sheet, then copy based on the criteria and close it, saving the file. Then do the same thing for the second one.
But without a sample file(with how the desired results should look) to test, probably nobody will bother to create something.

[AlphaFrog]

Try something like this (not tested).

Please Login or Register  to view this content.

[blak9]

Thanks AlphaFrog, that worked Superb. Clean and what more, superfast within the blink of an eye. I'm really happy and impressed..!

Is it possible to also copy the Headers I have on row 3 to BE.xls and UK.xls, as well as the formatting of the Source sheet. F.i. some columns have %, or additional formatting.

Many thanks in advance...

[blak9]

Thanks AlphaFrog, that worked Superb. Clean and what more, superfast within the blink of an eye. I'm really happy and impressed..!

Is it possible to also copy the Headers I have on row 3 to BE.xls and UK.xls, as well as the formatting of the Source sheet. F.i. some columns have %, or additional formatting.

Many thanks in advance...

Doubel post, Sorry. Can't find a way to delete this post..

[blak9]

I Figured it out. Thanks again..