Copying filtered column to a new tab with extras

[dvollebregt]

Hi all!

I have a question that I could not find directly in previous posts.

I want to copy a selection from a database to the next tab and thereby bring a number of things.
I want the macro to continu at the end of the column to the next named column. Preferably by saying that the macro moves a few rows.
I also want an ID number to appear next to the selection and continue numbering the total.

I tried to record a macro but I'm stuck.

In Annex I give the start and end result. In Sheet1 you see the start position and the end position Sheet2.

You would really help me, I need it for a database of 300 x 5000 lines.

Thanks in advance!

test macro filteren lijst en kopieren.xlsm

[tehneXus]

Hi,

try this:test macro filteren lijst en kopieren.xlsm
by default the result will be written into the sheet with index 2, you can adapt this here:

Please Login or Register  to view this content.

File contains:

Please Login or Register  to view this content.

Regards

[dvollebregt]

Wow works like a charm! What do i need to modify when I would like to use it with text in stead of numbers?

Thankks

[tehneXus]

this works with text and/or numbers, skips zeros and blank text: test macro filteren lijst en kopieren.xlsm

Reards