Change in formula with ComboBox Selection

[ravinder_tigh]

Hi Guys,

I'm New to excel programing so facing a problem with solutions I have a file that has multiple worksheets in it. The majority of the worksheets is a basic form that helps summarize.

In this file, I have a Work Summary worksheet in which I'm extracting some data from the other worksheets to "summarize" all jobs into one nice work summary log On Basis of Average of data from 3 other different sheets A,B,C

The following form works great to if onyl formula calling is applied

=AVERAGE(INDIRECT("'"&$C6&"'!c3:c7"))

C6 = Worksheet name or Worksheet tab name
where as c3:c7 is the range of the particular metrics

What i had to do is match the Metrics
eg
Productivity %
Ontime
Abandoned
Abandoned %
Critical Error Accuracy
Non-Critical Error Accuracy
which do belong to different worksheets such as a contains productivity% to
abandon%
B Has only 1st 3
c has later
so i ahd to bring data to summary sheet through a combobox selection
which do contain months name
data on each sheet is also primarily month based
i do need if i select april all the summary sheet shuould filled with all relative metrics


Help would be gr8ly appriciated
i'm new to excel so isn;t aware about the tech language for these
so i'm attaching the file also with the thread

Thanks and Regards
Ravinder Singh
Ravinder_tigh

Example: A
Is there another formula that works similar to the above formula or description given that will provide desired results?

Thanks

[antoka05]

See attached file... I hope my formula is correct.

Regards,
Antonio

[ravinder_tigh]

See attached file... I hope my formula is correct.

Regards,
Antonio

Thanks a million Antoka05 it works wonders

But i was working on macro for this as due to sensitivity of data i hadn't attached the original file but that also gives the same look in formula

I had to diliver this sheet with a macro
cud u also help me with how to apply this formula to the range("D6:J8").selection through a macro

=AVERAGE(INDIRECT("'"&$C7&"'!c" & ($A$14-4)*5+3 &":c" & ($A$14-4)*5+7))

i'm not that gud with formula's Please Cud u exapliain $A$14-4 part

thanks a lotz of again

Thanks and Regards
Ravinder_tigh

[antoka05]

This code should be easier to understand.
I tried to use elementary instructions for a better clarity.

Please Login or Register  to view this content.

Regards,
Antonio

[ravinder_tigh]

thans a lotzzzz of buddy

[ravinder_tigh]

Hi Antonia


http://www.excelforum.com/excel-prog...selection.html

How r u hay i'm a getting a bit difficulty with this macro it jst fill in the range on one go without matching the metrics defined in the the summary as with sheet "C"'s value it insert the value of
Critical Error Accuracy
Non-Critical Error Accuracy


into


Abandoned
Abandoned %

which are palced earlier

cud u plzz help me with this error other than that

what if i want to take step 5 of month as a variable value as if days on month

for jan 31
feb 28

and so on

Thanks and regards
Ravinder S








I"m Attaching the file with this post


do contains macro

[antoka05]

See attached file, it should do what you need.

Regards,
Antonio

[ravinder_tigh]

its perfect Antonio thanks a million man

is it also going to work when i change weeks with days in Sheet A,B,C
but keeping the summary sheet to show data for a month only

[antoka05]

Yes, if you use days and not weel it should run without problems but it's important you enter month name in the first row of a month (as you are now doing for week).

Regards,
Antonio