Re: $$Excel-Macros$$ VBA to populate cells based on cirteria

2014-07-16 Thread Paul Schreiner
esday, July 16, 2014 9:41 AM >Subject: Re: $$Excel-Macros$$ VBA to populate cells based on cirteria > > > >Hi Paul. This works quite well. Such a solution with well explanation! >Thank you! > > > > >On Wed, Jul 16, 2014 at 11:07 PM, Paul Schreiner >wrote: &g

Re: $$Excel-Macros$$ VBA to populate cells based on cirteria

2014-07-16 Thread Renton Cheung
Hi Paul. This works quite well. Such a solution with well explanation! Thank you! On Wed, Jul 16, 2014 at 11:07 PM, Paul Schreiner wrote: > > I used this formula in Cell E2: > > =IF(OR((COLUMN()-4)=$C3,MOD((COLUMN()-4)-$C3,$D3)=0),$B3,"") > > then copied it to the other cells. > > Basically, it

Re: $$Excel-Macros$$ VBA to populate cells based on cirteria

2014-07-16 Thread Vaibhav Joshi
Vry well explained Paul!! Cheers!! On Wed, Jul 16, 2014 at 6:37 PM, Paul Schreiner wrote: > > I used this formula in Cell E2: > > =IF(OR((COLUMN()-4)=$C3,MOD((COLUMN()-4)-$C3,$D3)=0),$B3,"") > > then copied it to the other cells. > > Basically, it uses two concepts: > the "Data" portion occupi

Re: $$Excel-Macros$$ VBA to populate cells based on cirteria

2014-07-16 Thread Paul Schreiner
  I used this formula in Cell E2:   =IF(OR((COLUMN()-4)=$C3,MOD((COLUMN()-4)-$C3,$D3)=0),$B3,"")   then copied it to the other cells.   Basically, it uses two concepts: the "Data" portion occupies (4) cells. A:D, so the column for year 1 is in column E. so, column() - 4 gives the "Year Number" of 1