I have a form button in excel and want it to go to another worksheet. The form button will contain the row number that it is associated with. This row number I need to be put into a 1/2 a dozen or so spots on the next sheet. I cannot use a macro or any vba. There is a reason for this due to exporting later. I could have 1000 entries on the first sheet. So the second sheet can't just be a bunch of nested if statements. Is there any way to dynamically based on the form button call a certain cell? I know it would be say 'B' whatever in the cell on sheet 2. But I do not know if it is row 1/2/3/4/ etc ...

I hope there is something that I can do to work this out.

Jamie