report pasted values between 2 sheets

[xam99]

Hello
I have a sheet with many rows (more than 2500) and it is necessary to report the rows of column B of the sheet "articoli" in the sheet "nomi" column A
without empty rows and in ascending order
I hope I have explained
xam

[Mumps1]

Try:

Please Login or Register  to view this content.

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[xam99]

Hi bo_ry
your macro works almost fine
must paste only column B of the "articles" sheet in colums A sheet "nomi"

[xam99]

HI mumps1 your macro must copy column B of the "articoli" sheet from the row 6 without color

[Bo_Ry]

Try

Please Login or Register  to view this content.

[xam99]

Hi bo_ry
now it works thanks
Thanks you
xam