button to navigate

1-button to navigate to top of the sheet

2- button to navigate to an specific cell
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
Try this.
29076109.xlsm
1
 
Martin LissOlder than dirtCommented:
Please upload a workbook for the buttons.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Here is
C456.xlsx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Martin LissOlder than dirtCommented:
Try this. I didn't know what cell you wanted to scroll to so I randomly chose E200. Please tell me more about which cell you want to select.
29076109.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

2-need move to A46




3-also need move to the last row of data
0
 
Martin LissOlder than dirtCommented:
My workbook has 3 heading lines, do you still you want to scroll to A46?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin , Yes
0
 
Martin LissOlder than dirtCommented:
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin i need also buttons to move to others
cells
like these are
A96, A114,  A121, A135, A163,  A181,
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
I try to see the code to replace the cell but its look more complicate than simple replace the cell number


why?
0
 
Martin LissOlder than dirtCommented:
Please explain why you want to go to those particular cells. Does it have something to do with the values in that row? If so, what?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin yes i need verify that values  in any time
0
 
Martin LissOlder than dirtCommented:
Are you saying that you might want to go to any row?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin need see  these rows with asn button to move fast


A96, A114,  A121, A135, A163,  A181
0
 
Martin LissOlder than dirtCommented:
Why those cells?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin because need see that  because   need to compare
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin  in this sutuation im just testing to compare but nothing true yet

but need to move fast from row to row
0
 
Martin LissOlder than dirtCommented:
Sorry but you aren't giving me the information I'm looking for, so let me ask one more time. Why do you want to go to A96 and not A97?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin  A96 could have any notes i write as needed
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin im just testing it but by now
not really data is on

but need an way to move from rows to rows faster
0
 
Martin LissOlder than dirtCommented:
OK, I can add code that will go to to those specific cells, but how about one of these instead?

  1. Start at row 4 (or any other row that contains a date) and go to the next week each time the button is clicked.
  2. Start at the current row and page down one page every time the button is clicked.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin   the first approach  is more what i need  (this will work great  for week )  you bring this idea

Start at row 4 (or any other row that contains a date) and go to the next week each time the button is clicked.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin is an  Great Solution !!
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job Best Expert !!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.