Switching between workbooks and populate the data

**hardik.r.shah** · 07-02-2012, 07:21 AM

Hi,

I have 2 workbooks. one is A.xls and other one is B.xls.
structure of whose is as follows.

A.xls->sheet1

FundName securityId SecurityName Position
fund1 rsec reliance_securities
fund1 rcom reliance_comm

B.xls->sheet1

FundName securityId Position
fund1 rsec 100
fund2 rcom 150

Here I have to search for fundname and securityid from A.xls and search it in B.xls and populate A.xls with the corresponding position using VBA.

Thanks

**arlu1201** · 07-02-2012, 08:35 AM

Why do you want to do it using VBA? You can use multiple formulae for this such as match or vlookup.

**hardik.r.shah** · 07-02-2012, 08:43 AM

what I mentioned here is just the part of my requirement. I have to check many more conditions and all. The place where I am struct while coding in VBA is here.

**arlu1201** · 07-02-2012, 09:00 AM

You can do a manual vlookup formula and record it while doing. This will give you the syntax what you should use in your code and alo help you to learn it.