Hi

I have this complex Excel file where I can input the ID of a member in one field and get a bunch of calculation results back. I basically need to produce a file that has all of those values for a large number of members.
There is only one field where I can input the members ID one by one, the copy and paste it somewhere else. And the field cannot be duplicated.

Is there simple way to fix this? I was going for VBA, but I'm really no good at this.

Details:
In cell A1, I can input the member ID.
Whenever I input a member ID, I get the calculated values I need, in cells A2, A3, and A4.

The full list of members is in separate sheet, from cells A1 to A255. I need the values for each member outputted in C2, C3, C4, next to the correct member ID.

Thank you for helping. Much appreciated.