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

[vbanoobz]

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?

 

[skywriter]

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

https://www.dropbox.com/

 

[vbanoobz]

https://www.dropbox.com/

Thanks Bruce.

Now, is there anyone online that can help me? I'm kind of desperate to get this solved before I go to work tomorrow.

Here's the workbook https://www.dropbox.com/s/j75kxxfnnvokm8x/Workbook12.xlsx?dl=0

 

[skywriter]

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
	D	E	F	G	H	I	J	K	L
9	BUilD & RETAIN			CHALLENGE			ACT
10	John Obregon	John Chu		John Lad	John Alcoriza		John Vance	John Afkhamian
11	John Kovacs	John Szeto		John Skelton	John Lofstrom		John Wong	John Percival
12	John Chin	John Whitelock		John Lu	John Xie		John Pierron	John Li
13	John Raizman	John Stevens		John Bowker	John Levy		John Weyermars	John Raheja
14	John Barham			John Wong	John Young		John Moser
15	John Yacob			John Leung	John Solomon		John Xue
16	John Pereira			John Rauterberg	John Wan		John Chiu
17	John Albert			John Wei			John Wong
18	John Oliveira			John Moutsias			John Pittom
19	John Khanna			John Marshall			John Lalla
20		OBSERVE		CULTIVATE			IDENTIFY NEXT MOVE
21	John Paunovic	John Sandrasegarampillai
22	John Qian
23	John Roh
24	John Liu
25	John MacPherson
26	John Hou
27	John Maly
28	John Bourgeois
29	John Tikoo
30	John Williams
31	MAINTAIN
32	John Qin	John Bruce
33	John Greenberg	John McDougall
34	John Sims	John Whitney
35	John Majid	John Rodriguez
36	John Hong
37	John Gibbs-Hurd
38	John Ngan
39	John Johnston
40	John DiPaolo
41	John Chinsen
Sheet1

 

[skywriter]

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).