Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multipe sheet search
Hi..
I have 12 sheets for each month and the dates appear at the tops of columns under which the user can input data. From a 13th sheet I want a macro button launch an input box that will search through the 12 month sheets and select the cell with the required date. I want to avoid using the generic FIND box as it provides too many options to the simpolistic user Any code would be muchaappreciated Jack |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multipe sheet search
Jack,
Name the month sheets Jan, Feb, ..., Dec Simply put 1,2,3, ... into the column headings on each sheet The input box would be something like myDate=cDate(inputbox("Input Date") the worksheet can be extracted with Worksheets(Month(myDate)) the column would just be Day(myDate) so to get the value below the date for 1st Jan, namely A2, it would just be Worksheets(Month(myDate)).Cells(2, Day(myDate)) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Jack" wrote in message ... Hi... I have 12 sheets for each month and the dates appear at the tops of columns under which the user can input data. From a 13th sheet I want a macro button launch an input box that will search through the 12 month sheets and select the cell with the required date. I want to avoid using the generic FIND box as it provides too many options to the simpolistic user. Any code would be muchaappreciated. Jack |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table with multipe columns | Excel Discussion (Misc queries) | |||
VLookup needed to search one value and return multipe results | Excel Worksheet Functions | |||
Lookup value with multipe Results | Excel Worksheet Functions | |||
lookup from multipe cells | Excel Discussion (Misc queries) | |||
How do I statistically analyze data across multipe worksheets? | New Users to Excel |