i want to be able to enter data into a column on sheet 1, and have it automatically update the data in a column in sheet 2. how do i do that?
i want to be able to enter data into a column on sheet 1, and have it automatically update the data in a column in sheet 2. how do i do that?
=Sheet1!A1
Never use Merged Cells in Excel
thanks for that. another question--it works for the 1st cell in the column only. how do you make it work for the entire column?
In right bottom corner of the cell a black cross will appear. With left mouse click grab it and pull down. This will extend your formula down.
make sure that you go down enough as you have data in sheet 1.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks