Need to copy my output by leaving 1st 6 rows

[Naga]

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

[Qiu · Accepted solution]

@Naga 
I think you are looking for the "Preserve Formatting on Overwrite (Range Required)" option in the output tool?

[Naga]

Thanks @Qiu ...this was really helpful to achieve my need

[Qiu]

@Naga 
Glad to be helpful and thank you for accepting my answer. 😁