SOLVED
Merge 3 excel files into one with dynamic sheet names
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
akvsachin
8 - Asteroid
‎11-28-2024
12:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What I have:
3 input excel files and I've Extracted filenames (3) from the file name
Correspondingly sorted data for each file (3)
What I need:
An output file where the extracted filenames are used as sheet names, with the sorted data from the corresponding file in each sheet.
Also, please give a suggestion If I can do the same thing while using FileBrowse Tool + Action Tool
Solved! Go to Solution.
Labels:
- Labels:
- Developer
- Macros
- Preparation
1 REPLY 1
nagakavyasri
12 - Quasar
‎11-28-2024
05:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@akvsachin Can use any of 2 workflows attached.
