copy row into seperate worksheet if column A has any value

Hi Guys,

I am trying to find a VBA that will do the following:

1. If Sheet1 has any value in Column A, then copy the entire row into sheet2.

Further, once the rows have been pasted, autofilter the sheet to remove blanks so that we have thecopied cells one after another rather than spread apart on sheet2.

Would be great to get help on this. I Have 7500 rows of data

Can you post a sample workbook? What rows do you want copied based on any value in column A? How do you want the macro to trigger, etc.

Thanks for that,

I want the whole row to be copied into the next sheet.
Currently, any value is added in columsn A and the rows with any values in A are to appear in the next sheet.

I am unable to upload a file because i cant see the option in the thread available

NOW ATTACHED


Hi Guys,

I am trying to find a VBA that will do the following:

1. If Sheet1 has any value in Column A, then copy the entire row into sheet2.

Further, once the rows have been pasted, autofilter the sheet to remove blanks so that we have thecopied cells one after another rather than spread apart on sheet2.

Would be great to get help on this. I Have 7500 rows of data .



Re: copy row into seperate worksheet if column A has any value

Can you post a sample workbook? What rows do you want copied based on any value in column A? How do you want the macro to trigger, etc. .Today, 09:47 AMNeilM
copy row into seperate worksheet if column A has any value



NeilM
Re: copy row into seperate worksheet if column A has any value

Thanks for that,

I want the whole row to be copied into the next sheet.
Currently, any value is added in columsn A and the rows with any values in A are to appear in the next sheet.

I am unable to upload a file because i cant see the option in the thread available .Today, 10:05 AMMedpack

Now its attached below, Thanks.

I just posted a threat about this exact issue. Could use the same help. Even in the coding area.