Copy rows to another sheet base on text in cells

[Winston]

Hi

Could Anyone help with the following problem as details below.

how to copy rows to another sheet based on text in cells is true

Regards

WOB

[Pete_UK]

It would help if you attached a sample Excel workbook, in which you can indicate what you want to achieve.

Pete

[Winston]

Hi Pete_UK,

Thanks for quick response please find below before(Brown) and after(Green) sample.

Just need the best way to produce this ideally "After" needs to be on separate sheet tab part number sorted with print range to suit

As requested this is just a sample of a very big spreadsheet

Please let me know if you need any more info

Regards

WOB

[The_Snook]

Hi Winston,

Have you considered copying the tab and using a filter to hide the rows that don't have comments?

Snook

[Winston]

Hi Snook,

I would need it to be automatic in real time on a separate tab or on same spreadsheet in different area.
This would be needed 2 to 3 times a day as data is changed by other users.

Regards

WOB

[Pete_UK]

You can do this with a couple of formulae, as the attached file illustrates. Put this formula in D2 of Sheet1:

=IF(C2="","-",MAX(D$1:D1)+1)

Copy this down beyond your data, so as to accommodate more records being added (the hyphens show where the formula is active). Then in A2 of Sheet2 you can have this formula:

=IFERROR(INDEX(Sheet1!A:A,MATCH(ROWS($1:1),Sheet1!$D:$D,0)),"")

Copy this into B2:C2, and then copy the row of formulae down as far as you need (I've copied to row 20 in the example file)

Hope this helps.

Pete

P.S. In future you should attach a sample Excel workbook (not a picture of one) - no-one like to have to re-create a workbook from scratch.

[Winston]

Hi Pete_UK

In a word "FANTASTIC" just what I needed, what can I say but thanks very much for saving me so much time!!!!!!!!!!!!!!!!!!!!!!!.

Pete where are you from in UK?

Regards

WOB

[Pete_UK]

Glad to hear it works for you.

As it says in my profile, I'm from Warrington, which is mid-way between Manchester and Liverpool.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete