Append new data to the top of preexisting excel tab, shifting down + keeping existing data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
I've got a workflow which gets my data into the format below, with the week ending date in red dynamically updating (also with null values across A-L) and then the correct columns with the correct data below them. My problem: appending my output to a preexisting tab in excel, above the previous week ending data table - which looks like the below.
Any idea how to get the week ending 12th April data to sit on top of this data here, with one blank row separating them (ideally with the same formatting but this may be a stretch so fine without)? This process is run weekly so needs to be able to add the week after's etc. on top when the flow is run too.
Ideal output:
Thanks in advance for any help/suggestions/ideas.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You should be able to accomplish this with a Union tool. Have your workflow run whatever calculations it needs to for the current Week Ending and Union it to the existing worksheet. The issue you will likely have is with formatting. You'll likely need to create a Run Command to trigger a VBA macro within excel to reformat the sheet the way you want it to look.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@cjaneczko thanks! much simpler than i was thinking, that has done the trick. i'll have a look into triggering the run command and see what can be done, thank you!
