Report segregation

[vinni.prasad]

Hi,
I need a coding for the below mentioned 3 conditions for single report,

Condition 1
I have one excel work book in the total 9 sheets are there
Cover (Sheet 1)
Raw Data (Sheet 2)
S+2 (Sheet 3)
S+1 (Sheet 4)
T+3 (Sheet 5)
T+2 (Sheet 6)
T+1 (Sheet 7)
Final (Sheet 8)
T+1 B&C (Sheet 9)
Step 1:
(S+2)
I have a data in sheet S+2 from column "A" to Column "W", out of which column A, D, G, I, K, P, Q, T, U, W should be deleted.
Step 2:

After deleting those columns sheet S+2 will have data from column "A" to column "M"
Step 3:
The Entire data of column "M" should be cut and instered in between column "F" and "G"
Step 4:


The Enter data of column "C" should be cut and instered in between column "H" and "I"

Step 5:
The entire data should be filtered with Column "G" and column "J" (Data has a headings)
End


****************************************************************************************************************************************************

Condition 2

I have one excel work book in the total 9 sheets are there
Cover (Sheet 1)
Raw Data (Sheet 2)
S+2 (Sheet 3)
S+1 (Sheet 4)
T+3 (Sheet 5)
T+2 (Sheet 6)
T+1 (Sheet 7)
Final (Sheet 8)
T+1 B&C (Sheet 9)
Step 1:
(T+3)
I have a data in sheet T+3 from column "A" to Column "W", out of which column A, D, G, I, K, P, Q, T, U, W should be deleted.
Step 2:

After deleting those columns Sheet T+3 will have data from column "A" to column "M"
Step 3:
The Entire data of column "M" should be cut and instered in between column "F" and "G"
Step 4:


The Entire data of column "C" should be cut and instered in between column "H" and "I"
Step 5:
:- Find "BT01B" from Column "D" and delete enire ROW
:- Find "BT01C" from Column "D" and delete enire ROW
:- Find "BT01E" from Column "D" and delete enire ROW

Step 6:
The entire data should be filtered with Column "G" and column "J" (Data has a headings)

End

****************************************************************************************************************************************************

Condition 3

I have one excel work book in the total 9 sheets are there
Cover (Sheet 1)
Raw Data (Sheet 2)
S+2 (Sheet 3)
S+1 (Sheet 4)
T+3 (Sheet 5)
T+2 (Sheet 6)
T+1 (Sheet 7)
Final (Sheet 8)
T+1 B&C (Sheet 9)

Step 1:
(T+1)
I have a data in sheet T+1 from column "A" to Column "W", out of which column A, D, G, I, K, P, Q, T, U, W should be deleted.
Step 2:

After deleting those columns sheet T+1 will have data from column "A" to column "M"
Step 3:
The Entire data of column "M" should be cut and instered in between column "F" and "G"

Step 4:


The Entire data of column "C" should be cut and instered in between column "H" and "I"

Step 5:
Filter the data from column "D" with BT01B and BT01C, copy the entire data (Along with the heading) and paste it to sheet T+1 B&C

Step 6:
(Go to sheet T+1 B&C)
The entire data should be filtered with Column "G" and column "J" (Data has a headings)

Step 7:
(Go to sheet T+1)
:- Find "BT01B" from Column "D" and delete enire ROW
:- Find "BT01C" from Column "D" and delete enire ROW

Step 8:
The entire data should be filtered with Column "G" and column "J" (Data has a headings)
End

****************************************************************************************************************************************************

Many thanks in advance

Selvi

 

[JackDanIce]

Firstly, I think the board rules state you need to seperate these into three seperate threads as the requirements are not related

Secondly, have you tried to record a macro to do what you want? If not, I suggest you record a macro, then post the code and then re-ask your queries