I have two sheets and in Sheet 2 Column A I want to duplicate all of the values from Sheet 1 column A so that when I add a new value to Sheet1 Column A it displays in sheet 2. There are roughly 30000 rows so I don't want to have to drag the fill handle each time.
I thought I could do this by defining a name giving it a Range of Sheet1!A:A but I can't figure out how to get this to fill the entire column in Sheet2.
Hope this makes sense.