Hello Board !
Thank u all for always paying attention to my problems :
I have got a situation here.. Pls Try to solve it.
I have 41 Sheet in my Workbook.
Sheet1 Contains all the Data
For Example:
Now For every Staff I have Four Individual Sheet of "Seg"
For Example:
Sheet2 : Ajj A, Sheet10 : Las A
Sheet3 : Ajj B, Sheet11 : Las B
Sheet4 : Ajj C, Sheet12 : Las C
Sheet5 : Ajj D, Sheet13 : Las D
Sheet6 : Cas A, Sheet14 : Dud A
Sheet7 : Cas B, Sheet15 : Dud B
Sheet8 : Cas C, Sheet16 : Dud C
Sheet9 : Cas D, Sheet17 : Dud D
And so on.........
Format of each Sheet is as follow :
What I want is to Copy Data From Sheet1 to each sheet of the Staff according to there Respective Details.
For Example:
Lets take Third & Sixth record of sheet1
Cas Bought 10pcs of DF @ 60 on 02/07 of Segment B,
Cas Sold 2Pcs of OM @ 150 on 02/07 of Segment A
I want is :
1st record to be copied automatically to Sheet7 (CAS B) in Bought Side Column,
2nd record to be copied automatically to Sheet6 (CAS A) in Sold Side Column
with name of toys in both the sheet.
Kindly Help
Thanks
Thank u all for always paying attention to my problems :
I have got a situation here.. Pls Try to solve it.
I have 41 Sheet in my Workbook.
Sheet1 Contains all the Data
For Example:
And so on........Seg....Staff......Toys......Date......Rate......Qty......Value
A...... Ajj..........AJ...... 02/07...... 100...... 2....... 200
A...... Ajj.......... JJ...... 02/07....... 50...... -6...... -300
B...... Cas.......DF...... 02/07....... 60...... 10...... 600
C...... Las........ER...... 02/07...... 500...... 1...... 500
C...... Dud........LT...... 02/07...... 200...... 2...... 400
A...... Cas........OM...... 02/07...... 150...... -2...... -300
D...... Tom........WE...... 02/07...... 100...... 4...... 400
Now For every Staff I have Four Individual Sheet of "Seg"
For Example:
Sheet2 : Ajj A, Sheet10 : Las A
Sheet3 : Ajj B, Sheet11 : Las B
Sheet4 : Ajj C, Sheet12 : Las C
Sheet5 : Ajj D, Sheet13 : Las D
Sheet6 : Cas A, Sheet14 : Dud A
Sheet7 : Cas B, Sheet15 : Dud B
Sheet8 : Cas C, Sheet16 : Dud C
Sheet9 : Cas D, Sheet17 : Dud D
And so on.........
Format of each Sheet is as follow :
Toys.......................Bought........................................Sold............
.................Date....Rate....Qty....Value........Date....Rate....Qty....Value
What I want is to Copy Data From Sheet1 to each sheet of the Staff according to there Respective Details.
For Example:
Lets take Third & Sixth record of sheet1
Cas Bought 10pcs of DF @ 60 on 02/07 of Segment B,
Cas Sold 2Pcs of OM @ 150 on 02/07 of Segment A
I want is :
1st record to be copied automatically to Sheet7 (CAS B) in Bought Side Column,
2nd record to be copied automatically to Sheet6 (CAS A) in Sold Side Column
with name of toys in both the sheet.
Kindly Help
Thanks