Basically I have about 300 excel files many of which have the same properties in Column 1 (Company Name). I would like to create a macro to search Column 1 for the company name, and then when it matches, paste the corresponding website in Column 2.
I am assuming that I would have to preset the URL to the Company name in another file.
Any help would be greatly appreciated!I don't really know where to start.
Last edited by watchoverme; 07-25-2013 at 06:27 PM.
Administrative Note:
- We would love to help you with your query, but first, before we can proceed…
- Please see Forum Rule #1 about proper thread
- Please PM me when complete and this post will be removed which will reset the replies to zero…
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
watchoverme, thanks for the change, but the new title is hardly any more descriptive of what your problem is. Perhaps something like "create a macro to search multiple files"
Changed it. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks