VB script to read data from another sheet
Closed
srini4547
Posts
1
Registration date
Thursday January 31, 2013
Status
Member
Last seen
January 31, 2013
-
Jan 31, 2013 at 09:36 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Feb 2, 2013 at 12:28 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Feb 2, 2013 at 12:28 PM
Related:
- VB script to read data from another sheet
- Ps3 won't read disc - Guide
- How to read news on kindle - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
1 response
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Feb 2, 2013 at 12:28 PM
Feb 2, 2013 at 12:28 PM
Hi srini4547,
As you have posted in Forum > Office software > Excel, I assume your sheets with values are in Microsoft Excel. Instead of using VBScript for this purpose please use VLOOKUP() worksheet function. You can read more about VLOOKUP() worksheet function from the below mentioned link:
http://office.microsoft.com/en-001/excel-help/vlookup-HP005209335.aspx
Please reply if you have any further questions.
As you have posted in Forum > Office software > Excel, I assume your sheets with values are in Microsoft Excel. Instead of using VBScript for this purpose please use VLOOKUP() worksheet function. You can read more about VLOOKUP() worksheet function from the below mentioned link:
http://office.microsoft.com/en-001/excel-help/vlookup-HP005209335.aspx
Please reply if you have any further questions.