copy and paste by VBA based on criteria

[DocAElstein]

Hi
There are very many different ways to do something like this.
So this solution would be just one of many ways.

Example:

Before:

_____ Workbook: 1.xlsx ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Stock Name	Data	Data	Data	Data	Data	Data	Data	Data	Data	Data	Data	Data
2	ACC	800	700	600	500	400	300	200	100	90	80	70
3	ADANIENT	800	700	600	500	400	300	200	100	90	80	70
4	ADANIPORTS	800	700	600	500	400	300	200	100	90	80	70
5	ADANIPOWER	800	700	600	500	400	3	200	100	90	80	70
6	AMARAJABAT	800	700	600	500	400	300	200	100	90	80	70
7	AMBUJACEM	800	700	600	500	400	300	200	100	90	80	70
8	ONGC	800	700	600	500	400	300	200	100	90	80	70
9

Worksheet: Sheet1 (2)

run macro here: http://www.excelfox.com/forum/showth...ll=1#post13059

Output results After running macro

_____ Workbook: 2.xlsx ( Using Excel 2007 32 bit )

Row\Col	A	B	C
1	ACC	500
2	ADANIENT	700
3	AMARAJABAT	400
4

Worksheet: Tabelle2

---

macro is here : https://imgur.com/Rs0EaVf , and also in uploaded file.
Attachment 2838