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.

File_1.xlsx

File_2.xlsx

Workflow

Developer

Input

Best Practices

Transformation

Preparation

Optimization

Accepted answers

Qiu

@cshiv
Thanks.

0127-cshiv-r1.yxmd

All comments

Qiu

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

0127-cshiv.yxmd

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.

Output.xlsx

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

@cshiv
Thanks.

0127-cshiv-r1.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703