I need to count the records in each sheet and have a new sheet with consolidated results along with the sheet name.
Attached are the sample Input and Output sheets.
Thanks in advance.
@Lakshmikanth_2021
We can first get all the Sheet Names and File path with input tools.
Then a batch macro and Dynamic Input to read the contents of each Sheet then get ccount of records of Count Record Tool.
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |