Append to exiting sheet Range

[hemant86]

Hi All,

I am trying to append to an existing excel file with a sheet which has a certain template as given below.

	Column	A	B
Rows	1	ACS
	2	Wages
	3	Relocation
	4	Total
	5
	6	Maternity Leave
	7	Paternity Leave
	8	Paid Parental Leave
	9	Mat/Adoptin
	10
	11	Total
	12
	13	TMF

Now I have to write the output to this existing file/sheet to a particular rage. In the above case I have to write the output to range B2,B3,B6,B7,B8,B9 individually based on certain calculation. Is there a way to do this without creating a new file or sheet. I have tried using Overwrite sheet option in Output tool. The output is produced in the required range but the problem here is it also prints the column headers.

Appreciate any help. Thanks in advance.  

[mbarone]

What does the configuration of your output tool look like (screenshot maybe)?

[hemant86 · Accepted solution]

Thanks @mbarone for your response. I got it where I was going wrong. I had option 5 & 6 unchecked in my tool configuration. Now I'm getting the result I wanted once checked.

Correct Configuration:

[mbarone]

Awesome, glad to hear it!