Filipino

[phoenix0315]

Hello,

ask ko lng po kung mayroon dito n marunong mgtagalog n expert o my knowledge s excel especially s paggaw ng Macro o VBA?

 

[c23lemon]

Hi Phoenix,

Pinoy ako. How can I help?

 

[phoenix0315]

ask sana ako about macro..ung VBA..expert kb dun o my knowledge k pno gumawa ng VBA?

 

[c23lemon]

Yes may knowledge sa vba/macro. Eto ung specialization ko sa trabaho ko sa investment bank. Ano kailangan m n tulong?

 

[phoenix0315]

Nghhanp kc ko ng tmng code pr dun s macro s file ko, ung automtic nyng cocompare ung data s column A ng 2 sheets ko n magktulad.. Then if ever n my mgktulad n data dun s column A ng 2 sheets automtic nmn nyn n iccopy ung data n ns column B at C from sheet2 to sheet1 n my mgktulad n data s columnA................eto ung sample data ng sheet1 at sheet2 at ung result. Sheet1
Col A Col B Col C Col D Col E
b
c
f
g
h
z
t

Sheet2
Col A Col B Col C Col D Col E
b 35 3 6 9
c 5 4
f
g 6 2
h 3 2 45 3

Result:
Sheet1
Col A Col B Col C Col D Col E
b 35 3 6 9
c 5 4
f
g 6 2
h 3 2 45 3
z
t
Sana mtulungn mo ko.. Salamat

 

[c23lemon]

Hindi mo na kailangan ng vba para magawa ung gusto mo. Suggest ko gumamit ka ng vlookup na function. Built in na to at madali gamitin.

=vlookup("value to search","Range to lookup", "column placement to return", false).

Kung gusto mo send mo sa akin ung email address mo at bigyan kita ng sample pano gamitn ung vlookup.

 

[phoenix0315]

Repost

Nghhanp kc ko ng tmng code pr dun s macro s file ko, ung automtic nyng cocompare ung data s column A ng 2 sheets ko n magktulad.. Then if ever n my mgktulad n data dun s column A ng 2 sheets automtic nmn nyn n iccopy ung data n ns column B up to E from sheet2 to sheet1 n my mgktulad n data s columnA................eto ung sample data ng sheet1 at sheet2 at ung result. Sheet1
A B C D E
b
c
k
q
f
g
h
z
t

Sheet2
A B C D E
b 1 2 3 4
c 2 3 4 5
f 3 4 5 6
g 4 5 6 7
h 5 6 7 8

Result:
Sheet1
A B C D E
b 1 2 3 4
c 2 3 4 5
k
q
f 3 4 5 6
g 4 5 6 7
h 5 6 7 8
z
t
Sana mtulungn mo ko.. Salamat.. Eto email ko andhiedelarosa@yahoo.com

 

[phoenix0315]

Hi c23lemon, salamt ha....Actually yn nmn tlg ung formula n ginmit ko, ang problema lng pg nagka sheet3 ako need ko bguhin ulit ung "range to look up" ko dhil ang mgiging reference ko nmn eh ung sheet2 at hindi n ung sheet1,so kung my macro ako o vba hindi ko n need n bguhin ung reference ko s " range to lookup " everytime n mgdagdag ako ng sheet.. Naisip ko lng un...