Hi,

I am new to this forum and not experienced in vba. I apologize in advance if there is already a thread about my question. I did search quite a bit, but couldn't find any answers that a) I understood b) answered my specific question.

I have a tab (a) that has about 25 columns of information
In tab (b) I would like to be able to copy select cells from tab (a) based on if a Yes answer is put into a cell in tab (a)

For example:

Tab (a) columns: Name, date, event, attending, G, C, T, D, ....
Tab (b) columns: Name, date, event, attending, G, C, T, D, ....

In my head the formula looks like .... =If(D$1="Y",copy Tab a A1:D8 to tab b, "")...so that everytime someone puts a Y on any given row under column D, those first 8 cells of that row would be copied to the next available row in tab (b).

Sorry if I am not explaining this very well.

Thanks for any help.

Cangert