in sheet 1 i have data like name and phone number a1: sally b1:555-1212
i put that in sheet 2 easy enough by clicking sheet 2 a1 then =sheet1a1 got it.....
ok so when i add a new name in a new row, "a2: janet" i want excel to know that it has to put that name sheet 2 as well. (i realize i could drag and copy but i dont want to drag and copy like 1000 rows just awaiting for data to be filled in
What is the formula that says "if data is put into sheet 1 new row, then add this to sheet 2 new row also...."
Bookmarks