Forum Discussion
consolidate multiple (188) tables, all formatted the same, into a single worksheet. The tables are A
I have a file that I want to consolidate into a single worksheet for purposes of analysis. It is in the form of 188 tables all formatted the same and of consistent size. The tables are columns A to D...
If we speak about structured tables perhaps Power Query is the easiest way. Start with blank query, add = Excel.CurrentWorkbook()
as the first step, if necessary uncheck other than 188 table names and expand the content.
Many thanks I will try it now
Ray
Ray