If Cell = X, Then Copy Entire Row Into A New Sheet-example file

[silviario]

Hi!!I saw a post with the same title and I need a similar thing. I want to copy the rows if in one cell is a numeric value and paste this row in a new sheet. I have a lot of sheets and I want to ejecute the same instruction to paste into a unique sheet.

i send and example file. In this example I want to copy the rows when there're a numeric value (a value) in colum c and repite the same operation to all sheets. I want to paste the rows in Hoja4

[royUK]

Which column?

[silviario]

may be i didnīt explain very well...if in colum c are numbers (in this case will be a year) then copy the entire row and paste in sheet 4 (Hoja 4).

thanks in advance!!

[royUK]

Try this

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

[silviario]

snb, i canīt ejecute your code...it give me error

I have a new question, The "x" code run for the data I send, but, I have other files where it not run and I not sure what i have to change. the file have more colums, i send a sheet example (all have the same format)

thanks a lot!!!

[snb]

Please Login or Register  to view this content.

[royUK]

Again it's not clear what columns you are looking at

[silviario]

sorry!column aj, when aj is not empty (or is numeric, is the same) i want to copy all the row and paste in the sheet "Hoja4"

Many thanks!!