| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro how to
Hi all, I have a excel file delivered weekly that contains various columns. O Column A, for example, I would have an ID type and on Column B I woul have the ID's descriptive text. Since the Column A and B are actua troubleshooting errors for a company, I then have an action that fixe each error and and the relevant average fix rate. An example of which is 'here (http://www.heaphydesigns.com/example.xls) :) Anyways, how can I make a macro that will prompt the user for the ID it will then scan ID column for the ID entered, and return the averag fix rate of all the steps in one go -- BravoGol ----------------------------------------------------------------------- BravoGolf's Profile: http://www.excelforum.com/member.php...fo&userid=1475 View this thread: http://www.excelforum.com/showthread.php?threadid=27211 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Threaded Mode
