Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need A Guru Please! Click on Cell - Go there
Hi All,
I am a finance manager for a Large Company. What I am trying to do is follows: Each week our sales team enter in data into an excel worksheet (Yes I would prefer to use Access but our company does not allow it!). One worksheet is set up with all the entry cells for all the weeks in advance for the year. I am trying to do two things: 1.In a separate sheet have the inputer select a week for entry from a drop down list. Once they select the week - this takes the user directly to the week of entry in the other sheet. Does anyone know how to do this, without creating a hyperlink for each week 2.Conditional format so that only the week of entry is displayed, or if that can't be done the current week in a different color Any help would be greatly appreciated |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need A Guru Please! Click on Cell - Go there
Hi Communities
Maybe you like my EasyFilter add-in You can filter on Weeknumbers http://www.rondebruin.nl/easyfilter.htm Another way is check the first day of the week and find that date in the other sheet On this page you find a formula to find the date for ISO week numbers -- Regards Ron de Bruin http://www.rondebruin.nl "Communities" wrote in message ... Hi All, I am a finance manager for a Large Company. What I am trying to do is follows: Each week our sales team enter in data into an excel worksheet (Yes I would prefer to use Access but our company does not allow it!). One worksheet is set up with all the entry cells for all the weeks in advance for the year. I am trying to do two things: 1.In a separate sheet have the inputer select a week for entry from a drop down list. Once they select the week - this takes the user directly to the week of entry in the other sheet. Does anyone know how to do this, without creating a hyperlink for each week 2.Conditional format so that only the week of entry is displayed, or if that can't be done the current week in a different color Any help would be greatly appreciated |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need A Guru Please! Click on Cell - Go there
Oops
http://www.rondebruin.nl/isodate.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Communities" wrote in message ... Hi All, I am a finance manager for a Large Company. What I am trying to do is follows: Each week our sales team enter in data into an excel worksheet (Yes I would prefer to use Access but our company does not allow it!). One worksheet is set up with all the entry cells for all the weeks in advance for the year. I am trying to do two things: 1.In a separate sheet have the inputer select a week for entry from a drop down list. Once they select the week - this takes the user directly to the week of entry in the other sheet. Does anyone know how to do this, without creating a hyperlink for each week 2.Conditional format so that only the week of entry is displayed, or if that can't be done the current week in a different color Any help would be greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help please, cell formatting only works after I double click the cell | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Ms Excel, Copying Cell to current sheet using 'Right Click' | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) |