LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Lists with dates in them

I am trying to come up with a way to have a dropdown list that displays all
the days of the month, and when you choose one of the dates, it takes you to
the corresponding cell on the page (employees are listed vertically, and days
of the month are listed horizontally accross the page, with a section under
each date for each employee). Here is an example of what I am talking about:

Emp1 Date1 Date2 Date3 Date4...
Emp2 Date1 Date2 Date3 Date4...
Emp3 Date1 Date2 Date3 Date4...

So when I click on date4 in the dropdown list, it moves me over to the date4
cell, just for an example.

I know how to create a macro that would do this, but I don't want to have to
have 31 buttons to correspond to each day of the month, I just want one list
that has all the macros in it. I don't even know if this is possible.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to clear validation lists based on other validation lists Ben Excel Discussion (Misc queries) 1 March 12th 07 07:11 PM
LISTS- adding info without repeat to other lists Jemimastar Excel Discussion (Misc queries) 1 December 1st 06 09:29 PM
Lists referencing lists...is it possible? JohnB Excel Worksheet Functions 2 October 18th 06 06:37 PM
Multiple lists with repeated values for dependet drop down lists mcmanusb Excel Worksheet Functions 1 September 29th 06 12:13 AM
lists from other lists in excel Lew Excel Worksheet Functions 5 March 13th 06 07:21 PM


All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"