• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vba to populate inputs on multi Sheets with Index Sheet and hyperlink between


New Member
Crosspost https://www.excelforum.com/excel-programming-vba-macros/1309288-vba-to-populate-inputs-on-multi-sheets-with-index-sheet-and-hyperlink-between.html#post5294291

Hi everybody,

As being seen in my attached example file which is also very similar to my original, I have 4 constant sheets and lots of dynamic sheets of Hotels can be extended 1500 in total. The yellow tabs (first 3 sheets) are mostly hidden and the rest starting from INDEX Sheet will always be visible. On INDEX Sheet, I have 3 main locations and 4 columns under each location which are referring to the information in Hotels' Sheets. The range adresses and sizes of the referred information on Hotels' sheets are always constant and INDEX sheet row number leads to 507 can host 500 hotels in each location. You may also see some explonations on INDEX sheet top.

So I wonder how a macro can compare the locations on INDEX with Hotels Sheets and auto fill the required information in each column with respect to hotels' sheets then auto hyperlink the Hotel names on INDEX with appropriate Hotel' s tab?

Thanks in advance for your kindest helps.


Marc L

Excel Ninja
I think the main reason why nobody answer in the other forum is you had merge cells (hell for many Excel users / VBA coders !)​
as there is obviously no reason to merge any cell for your need …​