Hello,
I have a general question involving 2 worksheets. Basically one has a column that data is constantly being entered into, thus increasing the # of rows in that column. What I would like to learn to do is to copy the second to last value entered in that column and paste it into another worksheet (doesn't matter exactly where right now as long as in another sheet). I would like it to update the 2nd sheet each time I enter another value in the 1st sheet column.
For example, in sheet 1, column A, there are 50 rows with numbers in them. I want to take the number from row 49 and paste it into any place in the 2nd sheet. After I enter the 51st value in that column, it should then paste the number from row 50 into the 2nd sheet.
I know that is a beginner's question but I would really appreciate any specific links or anything else I could read to learn this.
Thanks
Bookmarks