Append data to a specific tab

[Wvictoria428]

hey can i append data to a specific tab,  example: i have a excel that has 31 tabs(they represent dates ) i need   to output Certain names to that file but its base off dates 05/09/2024 needs to be appended to tab#9 )

[AGilbert · Accepted solution]

This will output each day of the month as a tab name in the same excel file. If I misunderstood your ask let me know what needs to change. 

You can build file paths with the formula tool.

Then use the output data tool with this config. 

[Wvictoria428]

[Wvictoria428]

I'm still getting an error