Help need to copy data from sheet 1 to sheet 3 if cell in sheet 1 = Yes

Hi All,
I need some assistance with a work book, I need to Copy a series of cells from sheet A to Sheet C, IF a specific cell = "Yes" .

Specifically in the attached workbook, SHEET A, IF cell B column ( I.e B8 ) = "Yes", I need the information in Cells A8, C8, D8, E8, F8 & G8, copied to SHEET C Cells D,E, F, G, H & I.

If the Cell in B column does not = "Yes" then no action is required.

The information in SHEET C is to be a summary so I need to only show the YES rows.


Thanks in advance as I vaguely know that this is possible but it is apparently beyond my very basic ability to make this function as I would like.

Thanks
NoIDeer.

Please Login or Register  to view this content.

Thanks for the quick reply, but just to show my ignorance how do I insert that script into the workbook to make it run?

And just for the record I am starting to feel overwhelmed knowing what I do not know!

Thanks

OK thanks again, but, (sorry) worked out how to run the script but I am only getting the headings for each column (Row 6) being copied to the SHEET C. Then I get a Run time error 1004 on the ROW B8 if it is selected as Yes (dropdown box in Column B)


Thanks.

Amended:

Please Login or Register  to view this content.

One more question if I may, and this may be a result of my application ( as I'm way out of my depth), Should this actually run automatically when data is input, as I can only get it to run when I manually run the VBA Project?

If you want it to be triggered upon selecting "Yes" in column B, this code will do. It needs to be properly placed in the correct sheet object

Please Login or Register  to view this content.

Thanks Guys,
Both of your codes work spot on once I got them in the right spot and tidied up the spreadsheets a bit.

I think I was having trouble with some merged cells

The copied cells stop at the first blank cell though.

As an afterthought, is it theoretically possible to have the same function take information from two or more sheets and collate into the one summary?

As an afterthought, is it theoretically possible to have the same function take information from two or more sheets and collate into the one summary?

Yes, however, a lot of specific parameters would need to be defined by you. There can be no room for guessing.