macro to find cells & copy to another sheet

[djarum11]

i would like create a button that when pressed copies specified values from column B, sheet B (i will pick 20 out of maybe ~30 cells) to the latest open row on destination Sheet A starting in column G. i would like to specify by the value in column A of the source sheet B, and return the value from column B. i am using excel 2013.

example: search for 'Units sold USA' in Sheet B is found in A15, return the value of B15 onto Sheet A first blank row after row 20 in column G. repeat for about 20 more pieces of data.

after searching, there seem to be many VBA ways to search for the last used row on a sheet or in a range. i really don't have the experience to know which is the best approach. i'm looking for a straightforward but fairly robust solution that a newbie might learn from & understand. thank you.

example source data on source sheet B, starting at cell B12:
82
82
0
0

82
82
0
28
21
21
0
-4
-3
-3
0
28
-4
1.2764
1.2744
0

6
100.00%
6
0
0
6

14
14
0
0

22
0
26.83%
0.00%

6
0

34:04:00
34:04:00
0:00
1:10:39
0:00

12
12
0

2
2
0
0

14

0
0
0
0
0
82

[dolphino]

Hi djarum11,

would you to insert the sample workbook for your question, perhaps someone can reply fastly. thankyou

[djarum11]

it's proprietary information. thanks anyway.

[bdogg33830]

Dim whatever as range
Set whatever = range("b:b").find(what:="whatever")
Whatever.select

Or
Range("b:b").find(what:="whatever").select

[djarum11]

i am very good with formulas but i'm sorry i don't understand VBA much at all. i would need more details

also, finding the last row for pasting into: i have a cell that specifies this, so for the correct paste row it just needs to reference this cell. let's call this cell D5