Copy a row to another sheet with conditions

Closed
Danielnowizard Posts 2 Registration date Wednesday January 11, 2012 Status Member Last seen January 11, 2012 - Jan 11, 2012 at 01:47 PM
Danielnowizard Posts 2 Registration date Wednesday January 11, 2012 Status Member Last seen January 11, 2012 - Jan 11, 2012 at 01:50 PM
Hello,

I am very new with coding in excel.

I have a sheet called AFF with rows containing different information. If a cell in column Q is not emtpy and a change is made somewhere in that row the entire row will copy to another sheet called Results. The rows that are copied to the "Result-sheet" must be sorted chronologically without any empty rows in between.

AFF: --> Results: Column Q
Column Q
row 1 row 2 10
row 2 10 row 4 11
row 3
row 4 11
row 5

If a change is made later on affecting row 1, I need row 1 to be listed before row 2 and 4 in the Result sheet (looking at the example above).

Thanks a lot,

Daniel


Related:

1 response

Danielnowizard Posts 2 Registration date Wednesday January 11, 2012 Status Member Last seen January 11, 2012
Jan 11, 2012 at 01:50 PM
I tried to illustrate the problem above but my spaces were erased. Probably hard to interpret.
0