Copy Cell Value if adjacent is true

Hi All,

Merry Christmas.

I would like to copy a certain Cell values if the cell above is true. (see screenshot below).
I need a vba or formula to copy any value of each group when the G2, H2 and I2 select via data validation.

copy cell value if true.jpg

Thank you.

Hi,

This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

In addition what's the overall requirement here. By that I don't mean tell us how you currently get to the end goal and the data & layout you use but tell us what you start with and what you want to see at the end. There will probably be a better way of holding your data and subsequent reporting of it.

OK.

Try this in G3 filled down and across.

Formula:

Please Login or Register  to view this content.

Here you go.