VBA code needed

[vikas9385]

Workbook 1 (Main data is available in it)....format of the data is given below:

	workbook 1: Data
			1501		1502		1503
			S	T	S	T	S	T
A	1	+	30	42	24	57	85	24
A	2	-	82	25	17	75	52	17
A	3	+	45	44	82	89	82	82
A	1	-	79	95	50	83	67	50
A	2	+	90	80	55	74	50	55
A	3	-	48	34	18	40	50	18
A	1	+	83	91	57	67	50	57
A	2	-	27	40	49	90	88	49
B	3	+	93	10	75	13	25	75
B	2	-	92	22	19	15	61	19
B	3	-	38	12	70	14	59	70
B	2	-	26	43	53	46	72	53
B	3	-	79	55	83	14	68	83
B	1	-	14	17	51	58	93	51
C	1	+	74	37	29	51	45	29
C	2	+	29	41	10	56	38	10
C	3	+	37	24	52	77	15	52
C	1	-	77	16	43	12	94	43
C	2	-	36	48	34	82	70	34
C	3	-	38	79	88	22	54	88

<colgroup><col span="9"></colgroup><tbody>
</tbody>

Want to copy data in various workbooks with the name of 1501 / 1502/1503 like that which is mentioned above each T & S group.

Step 1: open workbook on the basis of 1501 / 1502 / 1503 criteria

Step 2: paste the values as per below mentioned criterias

	1501
	S-total	T(1-total)	T(2-total)	T(3-total)
A
	T(1-total)	T(2-total)	T(3-total)
B
	T(1-total)	T(2-total)	T(3-total)
C

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>

<colgroup><col width="64" span="5" style="width:48pt"></colgroup><tbody></tbody>

Each group values (A-S-1, B-T-1 LIKE THAT) should be pasted in respective column as per + or - sign

Any small help in this regard will be highly appreciated.

Thanks in advance

Vikas Negi