Hello and thanks for taking the time to read my post/plea for assistance.
I an currently using Office 2013. I am relatively competent with excel formulas but know absolutely NOTHING of VBA coding or Macros. I have a workbook that has roughly 30 spreadsheets in it. 25 of these sheets contain tables that are identical in formatting and number of columns/column headers. The number of rows, however, differs between each table/sheet. The goal is to create a new table, on a separate sheet, which would summarize the information of all the tables. Some columns may have duplicate values, and others may not. I do not want to copy the unfilled rows from each table into the new one, only those which contain data. As I mentioned, the data to be combined is within "only" 25 of the sheets of the 30 sheet workbook. I would prefer for the summarization to happen as items are entered, verses having to press a button, or cntrl+Shift+ something key combination. I'm not entirely sure this is even possible, but thought I'd take the chance and ask. The file is slightly larger than the upload limit will allow so I deleted a good majority of the sheets, hopefully what remains will be enough to provide a better idea.
I may well have forgotten to provide some key points of information needed so please let me know if there are crucial elements I neglected.
Thanks
Robert
Bookmarks