Copy row data by condition

[b737]

Hi. I need macro which will copy data from row to a new new workbook where if it find the same condition. It will be more clear if you see the example. Many thanks

example.xls

[xladept]

How many columns and rows are in your table?

[b737]

I have 5-6 tables like that one. But I have one which I am doing every day copy-paste. It has 60 rows and 15 columns. So it would be nice if you can help me with this one.

[xladept]

Hi b,

Try this and let me know of any issues:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open your Workbook

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

[b737]

I have a problem with this, and that is my fault. I did not say that I have data in upper row Year 2011 so now macro copies me all table, not just row year 2012, and nothing then is happening. It works fine with out data in row 2011, it is not your fault it is mine, so I would be very grateful if you could help me with this now. Sorry

[xladept]

Hi B,

See if this is what you want:

Please Login or Register  to view this content.

[b737]

It does not work, it copies whole table, Year 2011 and 2012 data. Here is the new example of table, how it really looks like, simplified, but close to original. You have old and new sheet.

Thank you for your time example1.xls

[b737]

Any help???? Please

[xladept]

This is what I thought I had posted before - see if it's what you wanted:

Please Login or Register  to view this content.

[b737]

It works perfectly. Thank you very much for your help.

[xladept]

You're welcome! Glad it's working

[b737]

I am maybe annoying, but could you describe me what every line of code represent, becasue, I have different tables so I would like to use this for different purposes, so I need your help once more. and off-course to learn something

[xladept]

You're not very annoying - hope this helps. (I write it this way because some of the features don't work as they should!)

Please Login or Register  to view this content.