Taking cell values and copying them to specific cells

Question

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 HoursActivityDate1Date2MonthYearFileNameAdams50project11/1/20221/2/2022122022AdamsProjectWilson70project21/1/20221/2/2022122022WilsonProject

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

Ben_H · Answer

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

mbajic · Answer

Hi @Ben_H ,

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

With respect,

Matej

Ben_H · Answer

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