Hi all,

I'm trying to get my spreadsheet to "grab" info from one part of my spreadsheet and move it to another.

For example if cell A1 equals 1, I would like the text listed in cells A2:A10 to be listed in B1.

Thanks in advance for your help,

Luke