-1

There is one cell that affects the whole workbook (it selects the active product number). I would like to be able to fill that cell (change the active product) from anywhere in the document, so that I don't have to go back to the specific cell in the document.

Do you see a way to do it?

Simon Van Kerckhove
  • 1

1 Answers1

0

Very simple. Say the cell in question is Z1234. In Z1234 enter the formula:

=A1

In A1 enter the product number. Finally use Freeze Panes to freeze both the first row and the first column. Now no matter how you scroll, cell A1 will always be visible and available for you to enter a new product number.

Gary's Student
  • 95,722
  • 10
  • 59
  • 99
  • Thank you for your answer. What if the panes are already frozen for another reason (simply to see the indexes and columns)? – Simon Van Kerckhove Jan 03 '21 at 18:33
  • @SimonVanKerckhove Then use a different cell within the frozen pane. Remember the goal is to treat this cell like an "InputBox"; it should ALWAYS be visible and ALWAYS be available for you to modify. – Gary's Student Jan 03 '21 at 18:42