Taking cell values and copying them to specific cells

[mbajic]

Hello Community,

I have a question. Below is the sample table, formatted the way I get it. The table I get is in Excel and the final Table/Tables is also Excel.

Name	Hours	Activity	Date1	Date2	Month	Year	FileName
Adams	50	project1	1/1/2022	1/2/2022	12	2022	AdamsProject
Wilson	70	project2	1/1/2022	1/2/2022	12	2022	WilsonProject

I need to take the data from this "master" table and convert it to 1 Excel sheet or file per person, but I need to copy these cells into specific cells in my final template which is premade. This is the template, for example:

Name goes to C4

Hours go to B11

Activity goes to A10 

Date1 goes to B26

Date2 value should go to E29 cell.

Month goes to B7

Year goes to C7

FileName would be the desired name of the sheet or .xls file

I hope that I described the problem well and that someone more knowledgeable than me helps. Thank you in advance. Any idea would help.

With respect,

Matej

[Qiu]

@mbajic 
I dont think alteryx can really output the result to specific cell.

What we can do is to create a dummy table, where your desired data falls into the specific cell.

[mbajic]

@Qiu Thank you for your response, could you explain how would that dummy table work?

With respect,

Matej

[Ben_H]

Hi @mbajic,

You could also just output the data as one table to a named range in a seperate location in your excel template and have the cells you need updating just reference the appropriate part of the table.

Regards,

Ben

[mbajic]

Hi @Ben_H ,

Could you explain because I am not sure I follow your explanation. Thank you.

With respect,

Matej

[Ben_H]

Hi @mbajic,

So with excel outputs you can indeed output data to specific parts of an excel sheet.

Cribbing from a response @ChristinaFPE gave in another thread there are a couple of methods.

Output to specific cells:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Writing-to-a-specific-cell-in-Excel/td...

Or you can create a named range and output to there:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-Output-to-Named-Range/td-p/45491

For your purpose rather than trying to output all of the individual cells (which as far as I know would require a seperate output tool for each) I would have a named range within your template file. Then the cells that need updating can just be pointed at that.

Super crude example -

That way you only have to output once. Obviously the named range can be anywhere in your excel sheet. I use this method for templated outputs all the time, output whatever data I need into a specific data tab and then just have the reporting side reference it.

Hope that makes some sense.

Regards,

Ben