SOLVED
to append the data of the tabs of excel where the name of the column and the order
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
Fantastico
6 - Meteoroid
‎04-18-2023
11:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all - just came across a situation where i wish to pull in data of multiple tabs of excel.
In all tabs the data have 4 columns. the names are slightly different like one column is site_id and in another its siteid
i have an lookup file for the column headers.
can you guys give me the idea on how to pull the data
Solved! Go to Solution.
Labels:
- Labels:
- Developer
1 REPLY 1
binuacs
21 - Polaris
‎04-19-2023
12:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Fantastico One way of doing this is with the batch macro. Attaching a sample workflow for your reference
