<div>
Yes, it would simply be an equal formula (except for 2 different files)<br />
<br />
Your VBA has to say (lets say you have to update the value in cell A1)<br />
<br />
activesheet.range(&quot;A1&quot;).va<wbr />lue = otherworkbookname.otherwor<wbr />kbooksheet<wbr />.range(&quot;A1<wbr />&quot;).value<br />
<br />
Let me know if this is the logic you are looking for, then I can design a quick VBA
</div>


Yes, it would simply be an equal formula (except for 2 different files)

Your VBA has to say (lets say you have to update the value in cell A1)

activesheet.range("A1").value = otherworkbookname.otherworkbooksheet.range("A1").value

Let me know if this is the logic you are looking for, then I can design a quick VBA

<div>
Yes this is the logic. &nbsp;It is slightly more complicated. &nbsp;I will have a member ID in Sheet1!A4. &nbsp;This ID will be used to update the &nbsp;respective row in column K in Sheet2 where the member ID will be i ncolumn A with the value from Sheet1!H3.
</div>


Yes this is the logic.  It is slightly more complicated.  I will have a member ID in Sheet1!A4.  This ID will be used to update the  respective row in column K in Sheet2 where the member ID will be i ncolumn A with the value from Sheet1!H3.

<div>
The question was answered in another question so I just copied the solution in. &nbsp;I am not sure how to bring the other question into this one.
</div>


The question was answered in another question so I just copied the solution in.  I am not sure how to bring the other question into this one.

<div>
<div class="content wysiwyg-content">
I have a spreadsheet that has membership information on it. &nbsp;I have another spreadsheet that allows the user to select answers to questions from a listbox on another spreadsheet.<br />
<br />
I know using vlookup I can read data. &nbsp;Is there a way to update a spreadsheet with a value that has been entered on another spreadsheet and save the value.
</div>
</div>


I have a spreadsheet that has membership information on it.  I have another spreadsheet that allows the user to select answers to questions from a listbox on another spreadsheet.

I know using vlookup I can read data.  Is there a way to update a spreadsheet with a value that has been entered on another spreadsheet and save the value.

updating an excel spreadsheet from data input through another Excel spreadsheet

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.