ruggerman1968
New Member
- Joined
- Nov 3, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
First Post, I hope its not too simple or silly ....
I have spent some time trying to read or watch various options but do not seem to find an easy way to solve my problem on the interne or this forum.
One of my colleages with guidance from myself has produced an EXCEL with macros enabled to import any quanitiy of CSV files, the number of files selected for import and the names do not follow any pattern.
Once the files are imported there are multiple worksheet tabs with various names added to a new workbook.
These Worksheets do have identical rows and columns
I would like to open a new worksheet for an report/overview and then compare the worksheets in the workbook ( except one att the beginning named init) and identify the data where the value differs across the worksheets. either all the worksheets or if more simple, two worksheets we can select
I have spent some time trying to read or watch various options but do not seem to find an easy way to solve my problem on the interne or this forum.
One of my colleages with guidance from myself has produced an EXCEL with macros enabled to import any quanitiy of CSV files, the number of files selected for import and the names do not follow any pattern.
Once the files are imported there are multiple worksheet tabs with various names added to a new workbook.
These Worksheets do have identical rows and columns
I would like to open a new worksheet for an report/overview and then compare the worksheets in the workbook ( except one att the beginning named init) and identify the data where the value differs across the worksheets. either all the worksheets or if more simple, two worksheets we can select