Copy rows to master sheet based on contents in column

[gjw1971]

I have a workbook with a number of sheets, all with the same layout - data is in columns A:K starting on row 3.
I need to be able to copy the entire row on each sheet into the 'Master' sheet whenever any data is entered in column I.
Any help is appreciated.

[MatrixMan]

Put the code below in the workbook object and that should do it.

Please Login or Register  to view this content.

[gjw1971]

Thanks for that.
It's close, but it's only populating rows 3 and 4 of the Master sheet. Any changes to column I on any of the others just gets copied to row 4 on Master.
Nothing gets copied on rows below this.

Also, how would I amend this to run manually, for existing entries?

[MatrixMan]

I'm shooting blind a little without seeing your data and structure. Do the rows that get copied have all cells (especially the cell in col A) populated? If not then this:

Please Login or Register  to view this content.

won't pick up the actual last row, just the last populated row in column A.

If that is the issue, then change that line to this:

Please Login or Register  to view this content.

If that's not the issue, then post your file and I'll have a look.

[gjw1971]

Apologies; it works fine as is.
It was the fact that I was trying dummy data in column I to test, without anything in column A.

If I wanted to run this manually on the existing data, what would I need to change, please?

Thanks for your help with this.

[MatrixMan]

If by "manually" you mean you want to run it from the code window, then you need to move the code into a module (call the sub "CopyRows" or something) then replace all the code in the worksheet change event with this line:

Please Login or Register  to view this content.

And then you can hit F5 in the CopyRows sub in the module you created. The reason is that - as you have probably discovered - you cannot run the worksheet change event manually because it needs to be passed two parameters (sheet and target).

[gjw1971]

Thanks for your help.