Hey guys I've tried a bunch of different things to make this work more efficiently and I cant figure it out. Basically I need a macro to look for a company I specify then pull the price and the name of the mall associated with it across the two tabs and put it on a new sheet. Any help would be greatly appreciated thanks.
Bookmarks