Macro how to

  • Thread starter Thread starter BravoGolf
  • Start date Start date
B

BravoGolf

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
 
Hi
why do you want to use a macro. You can for example enter the ID in
cell C1 and use an array formula for calculating the AVERAGE. Where is
your data of interest stored?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reduce duplicates to 1 with a count of how many before 42
Merge data by macro 9
Match 2 set data and combine to 1set 2
Comparing data on 2 worksheets 1
Change macro button text when macro is invoked. 2
Lookup formula needed 1
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Populating values in cells based on lookup from other cell. 4

Back
Top