<div>
Expected outcome unclear<br />
<br />
Are you saying that if you changed Cell 1A in Sheet 1 for example, that you want Cell 1A in Sheet 2 to be automatically updated with the new information?
</div>


Expected outcome unclear

Are you saying that if you changed Cell 1A in Sheet 1 for example, that you want Cell 1A in Sheet 2 to be automatically updated with the new information?

<div>
Hi Andrew. Yes that’s exactly. For example if A1 changes in one sheet I like the other sheet to update with that information along with the row information in sheet one to sheet 2
</div>


Hi Andrew. Yes that’s exactly. For example if A1 changes in one sheet I like the other sheet to update with that information along with the row information in sheet one to sheet 2

<div>
There's no way to do it within excel itself that I'm aware of, however I've now added &quot;VBA&quot; to your topic selection for some coders to maybe jump in as there's a chance an automatic Macro could help you out. &nbsp;I don't code.
</div>


There's no way to do it within excel itself that I'm aware of, however I've now added "VBA" to your topic selection for some coders to maybe jump in as there's a chance an automatic Macro could help you out.  I don't code.

29081704.xlsx

<div>
Hi thanks, i used the =sheet1!A2) which works great, but i would like the remaining information in that row to be transfered to the other sheet as well. when that text changes<br />
<br />
if thats possible?<br />
<br />
Thanks <br />
Dave
</div>


Hi thanks, i used the =sheet1!A2) which works great, but i would like the remaining information in that row to be transfered to the other sheet as well. when that text changes

if thats possible?

Thanks
Dave

<div>
<blockquote>
but i would like the remaining information in that row to be transfered to the other sheet as well. when that text changes
</blockquote>
can you provide a sample file and illustrate what you trying to achieve?
</div>


> but i would like the remaining information in that row to be transfered to the other sheet as well. when that text changes

can you provide a sample file and illustrate what you trying to achieve?

<div>
<div class="content wysiwyg-content">
Hi. I have created a excel sheet with columns of information, I would like one cell in the rows when changed to add the row information to another tab. Is that possible .
</div>
</div>


Hi. I have created a excel sheet with columns of information, I would like one cell in the rows when changed to add the row information to another tab. Is that possible .

Duplicating information

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

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

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.