How to update specific cell value of one excel file from another excel file

[cshiv]

Hi Team,

I have two excel files (.xlsx) where I need to update a specific cell value of File_1 by copying the value from File_2 

Ex: In attached File_1 i need to update the value "D1" with the value the is present in "B1" of File_2.

Could you please help me in solving this.

[Qiu]

@cshiv 
It seems that your file 2 is empty.
I have to assum that your question can be resolved by a Join tool.

[cshiv]

Hi Qiu,

I need to update the cell/field value "ZIP" with "PIN CODE" the data remains to be the same.

And Yes my file_2 will always be empty, as i need to change the value of D1 with B1 everyday.

Sample which i have shared is an scenario of my daily data, where in need to keep updating the value from File_2

[Qiu]

@cshiv 
I am sorry, but I am a bit confused.
Can you kindly provide a sample output? 😁

[cshiv]

Hi @Qui,

attached is the sample output file.

[apathetichell]

you want to read in file2 and isolate the entry in the pinhole field (say select pinhole if there are a variety of values). Then you want to output to File_1.xlsx|||Sheet1$D1:Dn (where n is an approximation of your range). This starts on 1 if you are overwriting the header - otherwise you toggle off write out headers and start on D2. You want to set your output data to overwrite range or sheet. Include keep formatting if you have specific formatting.

[Qiu · Accepted solution]

@cshiv 
Thanks.