Hi All,
Good day. I have scenario where I want to paste my output to nth row ,because I am using a template that has used the 1st few rows for standard information. So I need the output records from header need to get pasted from 6th row. I have 200 odd files that has variety of information from row 1 to row 8 and I want a workflow that will not disturb the header and get the output pasted below 8th row. Though I referred some of the community workarounds, but it not fitted my need.
example:
Output, which gets pasted to 1st row of the excel file now
Client Name
ABC
EFG
HIJ
However, my template has
Date:
Client
# of Records
Expected output
Date:
Client
# of Records
Client Name
ABC
EFG
HIJ
Solved! Go to Solution.
@Naga
I think you are looking for the "Preserve Formatting on Overwrite (Range Required)" option in the output tool?
Thanks @Qiu ...this was really helpful to achieve my need
@Naga
Glad to be helpful and thank you for accepting my answer. 😁