Suggestions:Looping

[Embalmer]

Hi
I have a a P & L in excel that changes depending on what dept is entered into a particluar cell.
In the same book i have a list of the depts in a column. What i want to be able to do is have a macro that goes through the column placing each dept into the cell with in the P & L sheet so that a new P&L is created for each dept until all depts have been done i.e raches a blank cell.

Thanks

[Paul W Smith]

Dim c as range
For each c in {range containing dept list}

target cell (you called it 'a particular cell) = c

Next c



"Embalmer" <Embalmer.21bnna_1136733602.5526@excelforum-nospam.com> wrote in
message news:Embalmer.21bnna_1136733602.5526@excelforum-nospam.com...
>
> Hi
> I have a a P & L in excel that changes depending on what dept is
> entered into a particluar cell.
> In the same book i have a list of the depts in a column. What i want to
> be able to do is have a macro that goes through the column placing each
> dept into the cell with in the P & L sheet so that a new P&L is
> created for each dept until all depts have been done i.e raches a blank
> cell.
>
> Thanks
>
>
> --
> Embalmer
> ------------------------------------------------------------------------
> Embalmer's Profile:
> http://www.excelforum.com/member.php...o&userid=17907
> View this thread: http://www.excelforum.com/showthread...hreadid=499165
>