Question about creating a macro that can take the value and copy some fields to a different worksheet

vbanoobz

New Member
Joined
Oct 2, 2014
Messages
17
Hi Guys,

Just wondering if anyone online now can help me solve this little problem I have.

I have a spreadsheet with columns such as first name, last name etc.

And I need to create a macro that can look at the value in a field called "matrix" and based on that value, copy the first and last name fields to a different worksheet.

In the second worksheet(Sheet2), the first and last name will be copied into the appropriate matrix box based on that column in Sheet1.

Also, Is there any way I can attach the workbook in this thread?
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

skywriter

Well-known Member
Joined
Feb 15, 2014
Messages
1,642
Paste each formula into it's appropriate cell and confirm each formula with Control + Shift + Enter.
After a formula is confirmed you can copy it down in it's appropriate box. There are three formulas for each box as you can see. Make sure to put each formula in the correct cell, confirm each formula individually with control shift enter which will put curly brackets on either side of the formula and then copy down, but only to the last row of each appropriate box. The results you see are all from formulas, none of them are typed in. You should see the same results if the formulas are entered correctly. Do some spot checking to make sure everything appears to be okay. I'm not too good with code so I went with this solution. I may be able to do something with code, but I don't know how long it would take me. Good Luck.

Excel Workbook
DEFGHIJKL
9BUilD & RETAINCHALLENGEACT
10John ObregonJohn Chu John LadJohn Alcoriza John VanceJohn Afkhamian 
11John KovacsJohn SzetoJohn SkeltonJohn LofstromJohn WongJohn Percival
12John ChinJohn WhitelockJohn LuJohn XieJohn PierronJohn Li
13John RaizmanJohn StevensJohn BowkerJohn LevyJohn WeyermarsJohn Raheja
14John BarhamJohn WongJohn YoungJohn Moser
15John YacobJohn LeungJohn SolomonJohn Xue
16John PereiraJohn RauterbergJohn WanJohn Chiu
17John AlbertJohn WeiJohn Wong
18John OliveiraJohn MoutsiasJohn Pittom
19John KhannaJohn MarshallJohn Lalla
20OBSERVECULTIVATEIDENTIFY NEXT MOVE
21John PaunovicJohn Sandrasegarampillai       
22John Qian
23John Roh
24John Liu
25John MacPherson
26John Hou
27John Maly
28John Bourgeois
29John Tikoo
30John Williams
31MAINTAIN
32John QinJohn Bruce 
33John GreenbergJohn McDougall
34John SimsJohn Whitney
35John MajidJohn Rodriguez
36John Hong
37John Gibbs-Hurd
38John Ngan
39John Johnston
40John DiPaolo
41John Chinsen
Sheet1
 

skywriter

Well-known Member
Joined
Feb 15, 2014
Messages
1,642
Important note:

If you paste a formula into a cell and the curly brackets {} on each end of the equation are still there then erase both of them before using control **** enter. After you do that you should see those brackets surrounding the formula if you look at the formula in the formula bar (the box with fx on the left side of it).
 

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,309
Members
409,862
Latest member
lbisacca
Top