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
Confused on your question-if there’s one...:face_with_rolling_eyes: . I suggest: try to learn more excel with pivot tables, power query and power pivot. Or create databases and import your complex stuff in ms Access. Have a nice Weekend 8)
