August 29, 2008 06:22pm pdt

1. zorvek 2,107,186
2. rorya 2,046,988
3. saurabh726 1,301,130
4. chris_bot... 776,246
5. byundt 680,182
6. nutsch 546,068
7. patrickab 412,280
8. jeverist 407,238
9. spattewar 316,278
10. matthews... 303,769
11. ahammar 281,891
12. webtubbs 256,684
13. jpaulino 245,997
14. RobSamp... 240,914
15. dj88 210,941
16. irudyk 163,728
17. WJReid 150,302
18. weellio 143,519
19. Psychotec 133,785
20. epaclm 119,855
21. GrahamSkan 107,769
22. jell 100,971
23. Merch_Ops 92,593
24. gtgloner 83,427
25. StellanRo... 80,929

1. zorvek 9,411,677
2. byundt 7,423,271
3. rorya 5,741,719
4. matthews... 2,866,897
5. jeverist 2,817,507
6. patrickab 2,167,843
7. roos01 1,919,714
8. mvidas 1,529,753
9. saurabh726 1,394,709
10. webtubbs 1,353,076
11. fanpages 1,234,722
12. brettdj 1,095,751
13. MalicUK 1,059,396
14. chris_bot... 965,752
15. mgh_mgh... 649,110
16. LoNeRaV... 602,049
17. ahammar 582,024
18. ture 570,551
19. nutsch 546,068
20. spattewar 525,227
21. R_Rajesh 468,975
22. jpaulino 358,896
23. david251 355,614
24. RobSamp... 339,463
25. sebastienm 339,407

05.15.2008 at 06:19AM PDT, ID: 23404955

	[x] Attachment Details

Find value, copy and paste to sheet2

Asked by FluidBOX in Microsoft Excel Spreadsheet Software, Microsoft Office Suite, Visual Basic Programming

Tags: Microsoft, Excel, 2003

Good afternoon

Please see attached example. I would like to be able to automatically identify which rows have a description with the value of 29* (where * allows for any 29 value, i.e 29, 291, 2987 etc) is present in column B. The identified rows are copied and pasted to Sheet2.

Is this possible with a macro of some description, allowing it to be run against an existing spreadsheet?

Many thanksStart Free Trial

Attachments:

Experts-Exchange-Example.zip (1 KB) (File Type Details)

Example

Keywords: Find value, copy and paste to sheet2

	Title
1	macro: Lookup value from sheet1 in …
2	Pasting by Cell reference. Easy 50…
3	Find colum A data and replace with col…
4	Moving data from sheet1 to sheet2
5	find and copy and paste goups of cells
6	Scan rows in spreadsheet and based …

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Find value, copy and paste to sheet2

Asked by FluidBOX in Microsoft Excel Spreadsheet Software, Microsoft Office Suite, Visual Basic Programming

Tags: Microsoft, Excel, 2003

About this solution