copy row based on column value

[momo13]

need some help in setting up his. need to copy entire row based on column value. If column is Y entire row should be copied to another sheet. example--if I column is Y showing individual is secondary migrant entire row with data to be copied to sheet called Secondary migrants.

[Mumps1]

Try this macro in the worksheet code module.

Please Login or Register  to view this content.

[momo13]

thanks ..it is not doing anything. i am not experienced with excel. this code goes under development right?

[Mumps1]

You have to place the code in the worksheet code module. Do the following: right click the tab for sheet "RSS Database (TANF)". Click 'View Code'. Paste the macro in the empty code window that opens up. Close the code window to return to your sheet. When you enter a "Y" in column I, that row will be copied over to your other sheet.

[momo13]

thanks. still not getting what i want on the second sheet. i want entire row with all data to be copied exactly as it is on the first sheet if criteria on the column I matches (Y). thanks so much.

[Mumps1]

It works for me. Try the attached file. Make sure that you enter all your data in the cells in any row and that the "Y" is the last piece of data that you enter. Column I must be the last cell completed because it triggers the macro. Also make sure that you enter an uppercase "Y". I am using Excel 2010 and have saved the file in Excel 2003 format. I'm not sure if that may be giving you a problem.

[momo13]

got it. thanks so much. last question is. recording starts automatically? secondary migrant sheet should look exactly the same (formatting). how do i start adding rows from specific row on the secondary migrants sheet? thanks

[momo13]

it does it but each time I enter a new row, filed I when typing Y give me error 13 mismatch. I used same formula starting a new sequence for placements only to be copied into another sheet but did not work.

[Mumps1]

The copying is done automatically as soon as you enter Y in column I and exit the cell. Have a look at the attached file. You will notice that the two sheets are now identical, however, you will have to adjust the column widths in 'Secondary migrants'. As far as the error you are getting, I'm not sure what is happeing to cause it. It is very difficult to trace a problem when I can't see the actual file you are using. In the attached file, when I add data into a new row and then enter a Y in column I, the row is copied to sheet "Secondary migrants". If you are trying to apply the macro in a different situation and the sheet names are different, the macro won't work. If you attach your actual file with a detailed explanation, I could have a closer look.

[majid_mx5]

dear Mumps1
TKS Lot

[Mumps1]

My pleasure.