Macro button to append data to another work sheet

[kiwikiki718]

I have a spread sheet that contains 2 worksheets. the first worksheet labeled "information" and the second one labeled "updated list" when the user enters data in the "information" worksheet in column A1 and B1 I want the data to be added to the "updated list" worksheet cell Al and B1.

 

[Logit]

.
If you are talking only of A1 and B1, one simple method is to use the following formulas in "Update List" sheet :

In A1 of Updated List paste this formula :

=Information!A1

In B1 of Updated List paste this formula :

=Information!B1