Append the New data into Existing Template file!!!

Question

Hello All,

I have two files:

1. Master Template - contains formulas and specific formatting.

2. New File - Contains current week data.

I need to copy the data from the New File into the Master Template without affecting the existing formulas or formatting.

I have attached both files for reference. Please advise on the best way to process this, and if possible, a sample workflow would be helpful.

Thanks

Dhilip

Master Template.xlsx

New File.xlsx

Dhilip_Kumar · Answer

@davidskaife Thank you for your quick response. I am looking for the option to automate the process completely. Is there a way to find the last row of the first filed and update the data into the next row. just thoughts

davidskaife · Answer

You'll need to remove the formula from row 12 onwards, run Alteryx to populate the data, then drag the formula back down. I don't think you can do it any other way (i.e getting Alteryx to place the data in rows 12 onwards while the formula are there)

Dhilip_Kumar · Answer

@davidskaife  Is there a way to update the new data from row 12 since the formula also required to calculate the days.