how to retrieve a value from one file and place it into a specific cell in a dif. file

[GraceGu]

Hi~

I'm encountering some issues with my workflow. I'm working with a large dataset, and at the stage where I need to transfer the total amount into a different file. To illustrate my problem, I'll use a simple example: the total amount of 1,300 should be moved to another file. This way, I can apply a formula to calculate the current month's I/C charge-out amount. So how could i get the total from one file and place it in a specific cell in another file?

Any help would be greatly appreciated!

Thank you,

Grace 

[alexnajm · Accepted solution]

How about reading in the data and calculating the total? Then you can output to a range, with the range being the cells you need the total to go to in the output 

You could also input a range, but I assume the data location may shift so the previous suggestion is safer

[OTrieger · Accepted solution]

@GraceGu 
You can read the file that contain the total, get that value and write it to a specific cell in the other file. You can define the range of your output path.
\file.xlsx|||'Sheet1$D5:D5'
In this example the value will be saved in to D5 cell

@alexnajm sometimes you would like to have a given total and compare it with what Alteryx did, so just summing up the values might not give the expected value, nevertheless I do not know if this is the case. I would go with your solution if only the total is needed. However if the total is coming from a different source and needed for validation then another solution is needed.

[alexnajm]

Sure @OTrieger , completely fair point. The assumption is that the total cell is the sum of the cells above based on the amount matching

[OTrieger]

I know and I would do the same as your above solution

[GraceGu]

I really appreciate your help! I now understand how to make this work.

[GraceGu]

Thank you so much for your help! This is my first workflow, I have spent so many hours trying to figure out this >v<