Hi all,

I'm trying to work out how to replicate data from one spreadsheet to another if a certain value occurs in a column.

eg if '2421' occurs in column D, I want the data from columns A,B&C on that row to appear in an entirely different spreadsheet, directed to specified columns. '2421' is likely to appear several times so every time it does I want to transfer the data. Any idea how to do this? Can it be done at all?

I've no idea how to go about this, hence the post.
Thanks in advance for your help.