View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ahwelch ahwelch is offline
external usenet poster
 
Posts: 4
Default Click on cell (or "button"), takes you to appropriate information

I am building a spreadsheet, and I would like to be able to create a cell
that when you click on it, it looks like a "button" and then automatically
takes the user to the approriate information.

For instance, I ask a question: "Did your firm sell any fixed assets this
year? If yes, fill out Schedule R" Then, I place a cell called "Schedule R"
that relates to Schedule R at the end of the question...the user clicks that
"button" and it takes them to Schedule R.

I'm sure this is easy for an advanced user, but I am not that ;)!

Thanks!