Replies

Hi Sir Maudibe ,
The File provided by you works great . Well done :clapping::clapping:

Thanks you very much.

Hi Maudibe,
Many thanks for support & help. Working great.

Hi Maudibe,
Many thanks for your help !
Works great just little change required when there is no data ,formula shows nothing instead of zero value.
I am attaching screenshot.

Hi Respected,
Thank you for your suggested code works good & faster.

Hi
Do you need activesheet.UsedRange ..

If so then you might have to activate the sheet first

Code:

Application.ScreenUpdating = False
Sheets("sheetName").activate
LastRow = activesheet.Usedrange .Rows.Count

Geof

I dont want to activate the sheets only needs to run the code on specific two sheets.

LastRow = SheetName.UsedRange.Rows.Count

Invalid qualifer

Hi super !
Sorry i did not understand you…
I see your file you did excellent job for me…
Thank you it works for me..

I have a data in all the sheets ( different data) , need to plot a graph in each sheet based on each sheet data.

note that every time when generate a report, new sheets auto created and the data retrieve on those sheets.I want to run a vb code to plot all the graph in each sheets.

i am reattaching the sample added two more sheets as a sample .

hope i understand well.

You only provide ONE sheet. However, You need NOT do in each sheet when you can simply use ONE graph and indicate which sheet to graph. What is this for?

Hi i have many sheets this is just an sample i give , all sheets having same format of data. On which needs to plot a graph

Sir Steve,

Thank you very much formula you provided works perfectly !

Sorry due to Writing English I mean that value when we put like in decimal points e.g ( 0.21, 0.2, ) the formula not works showing is incorrect results.

Thank you.

Dear

While Google I search one file from forum which is attached . It perfectly works according to my needs but I face problem in Average if vales starts from without decimal the average works fine but when example I need to average 0.21 values like the average not correct .

Any one help me out

{=AVERAGE(IF(YEAR($A$5:$A$64)=YEAR(D5),IF(MONTH($A$5:$A$64)=MONTH(D5),$B$5:$B$64)))}

Thank for your reply
Actually I have years of data every time filtering the data may do the human mistake and get the wrong figures. Is it any way to get data in different sheets
Weekly,Monthly,Quartely and yearly ?

Sorry correction !

Require 4 sheets
Weekly
Monthly Quartely
Yearly.

Hi
I have attached the file sum columns needs to get weekly sum, some get weekly average .Same for Monthly and Yearly.
My week always starts from Thursday to Wednesday

Sir,
Please find attached the sample excel file please.