Zach
Member
I've looked through the forum looking for a subject similar to what i'm trying to accomplish but I can't find anything that gets me off in the right direction.
I have created a fairly large file that is basically a database holding information on multiple tabs, each tab is a has a different category of information on it (OPTION MASTER REBOOT). I was given another file (New Community Plan index) and asked to find a way to pull information from the OPTION MASTER REBOOT to the New Community Plan Index.
Inside the New Community Plan index file on tab "Plan 1", information is input in column A starting on row 22 and moving down. What I'm looking for is a macro that can be run to look at the option number from column A match it to the option number in the OPTION MASTER REBOOT and fill in the description columns G-L. If it is helpful the first 3 letters in the option number will match to a tab on the OPTION MASTER REBOOT.
Basically I need to know of this is even possible, this is way way out of my vba league and I figure trying to create a super-formula opens too many possibilities of it breaking somewhere.
Please look over the two files and let me know if anyone has any suggestions.
I have created a fairly large file that is basically a database holding information on multiple tabs, each tab is a has a different category of information on it (OPTION MASTER REBOOT). I was given another file (New Community Plan index) and asked to find a way to pull information from the OPTION MASTER REBOOT to the New Community Plan Index.
Inside the New Community Plan index file on tab "Plan 1", information is input in column A starting on row 22 and moving down. What I'm looking for is a macro that can be run to look at the option number from column A match it to the option number in the OPTION MASTER REBOOT and fill in the description columns G-L. If it is helpful the first 3 letters in the option number will match to a tab on the OPTION MASTER REBOOT.
Basically I need to know of this is even possible, this is way way out of my vba league and I figure trying to create a super-formula opens too many possibilities of it breaking somewhere.
Please look over the two files and let me know if anyone has any suggestions.