Is this possible?

[Mel Smith]

I have a list of 1,364 players that have ever represented their club and I would like to make it dynamic by adding any new players to the list should they represent their club. The players are listed in column B1:B1364 on a spreadsheet called History. In a separate workbook called Averages, I have a spreadsheet named Championship.

What I would like to do on the History sheet in cells B1365 and downwards, say to B1401 is to have a formula that looks the range of D4:D63 of the Championship spreadsheet and if, say the value in one of the cells is greater than 0, check that the corresponding name in range B4:B64 (on the same sheet) is already listed on the History sheet (B1:B1364 etc) or not. If the name is already listed, do nothing. If it is not listed then copy the contents of the cell (B4:B63) and paste it in the next cell of the History names list i.e. add to B1365 and then B1366 and so on.

Is this possible? Any help will be much appreciated.

Mel

 

[Mel Smith]

Could this by handled better by VBA and a command button?

Mel

 

[rlv01]

Is this possible?

My $0.02: Yes it is possible, but probably not without a VBA component.