Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Wooksheet
Hi,
I have a spreadsheet that has four tabs (Dave, Pete, Andy & Blank) within Dave, Pete, Andy is lots of information. Coloumn A shows a name, Column B a date and Column c show other information. I would like a MACRO that when clicked on it will ask me for a Name, Start Date and End Date. When these are entered it will search the three worksheets (Dave, Pete & Andy) it will look for the name in column A then check column b for dates inbetween those input. If it finds one where the name matches and the date is inbetween those input I want it to copy that row onto the blank sheet etc... Can someone help..... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Wooksheet
Glenn:
Try recording a macro in which you use the AutoFilter to set the criteria for a certain result. Then modify the macro to use three Input Boxes to put the name and dates into three strings. Substitute these strings for your AutoFilter criteria, and you'll see your results. Then copy what you see and Paste SpecialVisible Cells onto the blank sheet. If you have "lots of information", an AutoFilter will show you a constrained results set faster than iterating through every row. Ed "Glenn Robertson" wrote in message ... Hi, I have a spreadsheet that has four tabs (Dave, Pete, Andy & Blank) within Dave, Pete, Andy is lots of information. Coloumn A shows a name, Column B a date and Column c show other information. I would like a MACRO that when clicked on it will ask me for a Name, Start Date and End Date. When these are entered it will search the three worksheets (Dave, Pete & Andy) it will look for the name in column A then check column b for dates inbetween those input. If it finds one where the name matches and the date is inbetween those input I want it to copy that row onto the blank sheet etc... Can someone help..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel wooksheet problem | Excel Discussion (Misc queries) | |||
maro to save wooksheet & open in sheet 1 | Excel Worksheet Functions | |||
how do I print gridlines for Excel wooksheet | Excel Discussion (Misc queries) | |||
How to extract data from a wooksheet in a closed workbook | Excel Worksheet Functions | |||
Help with Promting for wooksheet name in macro. | Excel Programming |