Macro to split out departments

**v2jtb** · 08-11-2012, 05:05 PM

Hi all,

I have been given help on the forum here to be able to make the decimal format calculation. The formula is in columns F and G. I want to split the rows out by the departments (A and B).

Department A allocated 80% of the time.
Department B allocated 20% of the time.

Adding the extra department’s rows.

**v2jtb** · 08-11-2012, 07:40 PM

Okay, would it be possible for some help on where to start, like how to replicate rows with specific departments like A&B? and have them A and another row B?

**venkat1926** · 08-12-2012, 05:30 AM

see attsched file and col H and I

**ratcat** · 08-12-2012, 06:19 AM

G'day

Its my understanding that you want to split the names of the depts ????

See attachment

**v2jtb** · 08-12-2012, 08:03 AM

Hi RatCat,

I am looking to put Department A and B on separate rows i have highlighted in yellow.

The blue columns would not be present as they are just to show the calculation.

Thank you so much for your help.