Allocation of data in a column to 4 members

[harikrishnareddy]

Hello All,

I am new to this forum, i have posted the same querie in other excel forums but not received any response. My problem was, i need a macro that allocates the data in column "A" of a sheet to 4 different persons in teh same work book.

Assue A workbook has five sheets and Sheet 1 has data in Column "A", And That data should be allocated to "Sheet 2, Sheet 3 , Sheet4 & Sheet5.

The data in first cell of column"A" of sheet 1 should be copy and paste in First available cell in sheet 2
The data in second cell of column"A" of sheet 1 should be copy and paste in First available cell in sheet 3
The data in third cell of column"A" of sheet 1 should be copy and paste in First available cell in sheet 4
The data in fourth cell of column"A" of sheet 1 should be copy and paste in First available cell in sheet 5

Now

The data in fifth cell of column"A" of sheet 1 should be copy and paste in First available cell in sheet 2
The data in sixth cell of column"A" of sheet 1 should be copy and paste in First available cell in sheet 3
The data in seventh cell of column"A" of sheet 1 should be copy and paste in First available cell in sheet 4
The data in eighth cell of column"A" of sheet 1 should be copy and paste in First available cell in sheet 5

the above cycle should be repeated till the macro allocates the data in the last cell of column "A" in sheet1.

If need further details pls ask me.

[spitfireblue]

Please Login or Register  to view this content.