Jan 12 2019 12:21 PM
Good afternoon,
I have a large quantity of ever expanding data on multiple worksheets in one workbook and I would like to count certain aspects and have them tabulated on another worksheet (report) of which I have made a copy from another work book. Essentially creating one workbook from two that ultimately share the same basic data information. I have attempted to use countifs sumifs vlookup and indexmatch. What if any would be the best formula(s) to utilize to gather specific bits of information from certain columns in the multiple worksheets and tabulate it on the report
Thanks in advance
Jan 12 2019 01:04 PM