Forum

Hi, This doesn't help as each file to extract data from may have >100 Worksheets. I need to setup 1 master file and would like to extract dat...

Hi again, Getting specific cell reference from multiple sheets in same workbook is now working fine for me. New similar question: How do i no...

Hahaha... the number of sheets are > 500 sheets. Thank you anyway for your advice and tips. Will try to look into it.

Thank you very much for your response. very much appreciated. The solution is very helpful. P/s: The merge cells are actually from the extract ...