Posts by GaneshGopinath

Re: Run a vba on multiple worksheets when month changes in a specific cell

I was wondering if anyone could help m e out with this vba

Hello Gurus,

Please see below a macro that I would like to modify I would like this VBA to run only once every month on 4 worksheets (total worksheet in workbook=10) when there is a change in date. Please note that template is same on all the 4 worksheets. month in Cell D10 changes from March to April on each worksheet.

Sub TestCopy2()Dim Rw As Long, LR As LongLR = Range("A" & Rows.Count).End(xlUp).RowFor Rw = 1 To LR    If Range("A" & Rw).Value = "Orders per day" Then Range("C" & Rw).Value = Range("D" & Rw).ValueNext Rw End Sub

Please advice, your response is greatly appreciated. I have included a workbook with 2 sheets and have marked the appropriate cells

Re: Trying to use Offset, Index and Match to narrow down a particular activity

Thank you Smallman for calling out on the error, my apologies. Appreciate your timely response with solution.

Hats off to all you folks on this forum for helping build a strong excel community.

Regs
G

Re: Trying to use Offset, Index and Match to narrow down a particular activity

Thank you FDibbins for the directions. It seems to be working for me. I really appreciate your speedy response. Sorry for the late response, just getting back to normal after digging our way out of the snowstorm here in Fargo, ND

Big thank you.

Rgs
G

Re: Trying to use Offset, Index and Match to narrow down a particular activity

Thank you for reading my post.

My apologies for the typo on S250 (there is no space). I will be using column E (ModelFamily) from the Data tab. And the sample values in sheet 2 for BU(NA) is the sum of retails from data tab.

Rgs
G

Greetings to All Excel Gurus,
I am working on a project and need to extract a particular activity on a monthly basis (e.g Retails) from combination of multiple criteria. I tried using Offset, Index and Match function =OFFSET(INDEX(A2:AE21,MATCH(E2,H2:AE21,0)),2,) but did not have much success.
I have attached a Sample file, the original files runs in to about 10,000 rows of data with multiple Supply Org, Demand Org, BU(Business Unit), Products, Model Family, Model and Activity. I need to extract Individual activities based on BU, Product and Model Family on a monthly basis.

I was wondering if some of the experts here could guide me with how to extract the data. I have attached a sample data and a Template into which the data need to be inserted.

Regards,
G