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
"Relax. What is mind? No matter. What is matter? Never mind!"
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.
"Relax. What is mind? No matter. What is matter? Never mind!"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks