Hello Lilit2222,
All the sheets have exactly the same headers...........
Note that a sheet might not have a data
and header at all
Isn't this contradictory?
For proper use and manipulation of data sets, Excel requires uniformity. Please ensure that all sheets at least have headings, including the "ALL" sheet then try the following code assigned to a button:-
The code assumes that you are consolidating all data from all worksheets into the "ALL" worksheet.
I hope that this helps.
Cheerio,
vcoolio.
Bookmarks