A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

VB Macro for Match Index



 
 
Thread Tools Display Modes
  #1  
Old December 21st, 2006, 07:36 AM posted to microsoft.public.excel.setup
Anift
external usenet poster
 
Posts: 13
Default VB Macro for Match Index

HI All,
I need your help to write a Macro which will match a string in all the
sheets and Index the corresponding values next to it.

Eg i have 4 sheets in a Workbook. in the sheet4 i have values

A1: 8001
A2:8002
A3:8003
....
....

and sheet1,sheet2,sheet3 as values like this

A1:7001 B1: Sold
A2:8002 B2:Not sold
A3:6005 B3: Not sold
....
....
....

Now in Sheet4, I want to search for values in range A:A(sheet4) in all the
other sheets in the workbook and Index the corresponding values in Range B:B.

I know how to use Match Index function, but i want to write a code what will
match the value in all the sheets in the workbook and retrieve the
corresponding value.

In addition to that.. I would also like to know the code snippet if i want
to run this code to retrieve values from other excel file and not from the
other sheets of the same file.

Hope I am able to express my query. Any help will be appreicated

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.