Duplicating information

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 .
DavidAsked:
Who is Participating?
 
Ryan ChongCommented:
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

using VBA (macro) is a way to go if you got complex logic, else you may just set the formula

such as in another sheet, apply formula:

=Sheet1!A2)

Open in new window

or
=TRIM(Sheet1!A2)

Open in new window

29081704.xlsx
0
 
DavidAuthor Commented:
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
0
 
Andrew LeniartSenior EditorCommented:
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.
0
 
DavidAuthor Commented:
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
0
 
Ryan ChongCommented:
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?
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.