Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping
Dim c as range
For each c in {range containing dept list} target cell (you called it 'a particular cell) = c Next c "Embalmer" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not Looping | Excel Discussion (Misc queries) | |||
Looping | Excel Discussion (Misc queries) | |||
Looping | Excel Programming | |||
Looping | Excel Programming | |||
Need Looping Help | Excel Programming |