Hello Everyone!
To start, I would consider myself an Excel novice so I apologize if this post is not quite as clear as it should be. I am looking for a way to have a macro look at a specific worksheet column, find any row that specific text in it then perform some SUMS and AVERAGEs of corresponding columns. I have been trying to figure this out on my own and I honestly do not know where to look.
I have uploaded a sample document, I would appreciate any assistance for the following scenario:
1. Check the "IO Classification by LUN" worksheet and find all rows that have the word "ESX" in the B Column
2. For all of the conditions matching step 1, I would like to SUM columns S, BP, BQ, BY, BZ and I would like to AVERAGE columns AA, BM, BV
3. I would like the output of the calculations to placed into the "Analysis" worksheet in the sample table provided.
4. I would like to divide the results of the 'Capacity' by 1024
The ultimate goal here is to be able to have a MACRO that looks for defined words and performs the same calculations based on these words. In my example above i specified ESX however I will have the following keywords in a final document:
ESX
DB
LOG
TEMPDB
FILE
BACKUP
APP
ARCHIVE
EXCHANGE
ORACLE
SQL
Thanks for any assistance you can provide, it is most appreciated.
Bookmarks