Filling cells based on another cell content

[mattyn]

Hi all

A bit of a complicated on in my eyes.

Table is as shown

If a "N" was to be entered in cells G10:G21, I would like the corresponding row cell contents from column B to E to be copied into a new table starting at B35. In addition, if a further "N" is added in G10:G21, I want that corresponding cell contents to be copied into the next available row in the table starting at B35. I hope this makes sense! I have explained better I think in the image.

[/URL]******** async src="//embedr.flickr.com/assets/client-code.js" charset="utf-8">*********>[/IMG]

Many thanks in advance - this would really help me out!

Matt

 

[mattyn]

Well thank you anyway. I apologise for not explaining myself properly - but removing the ' means the data is copied.

I just need it to do so without selecting the cell now!!

 

[mattyn]

As this thread is so manic, just giving this a gentle bump! Anyone have any ideas?