J
jsteenberge
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 th
next sheet. I cannot use a macro or any vba. There is a reason fo
this due to exporting later. I could have 1000 entries on the firs
sheet. So the second sheet can't just be a bunch of nested i
statements. Is there any way to dynamically based on the form butto
call a certain cell? I know it would be say 'B' whatever in the cel
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.
Jami
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 th
next sheet. I cannot use a macro or any vba. There is a reason fo
this due to exporting later. I could have 1000 entries on the firs
sheet. So the second sheet can't just be a bunch of nested i
statements. Is there any way to dynamically based on the form butto
call a certain cell? I know it would be say 'B' whatever in the cel
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.
Jami