Hello.. and thanks to all for reading this post.
I have a "Master" worksheet that needs to copy the same cell from multiple different worksheets. The worksheet names are: Results (2), Results (3), Results (4).. and on and on.
This is how I would like to AutoFill Drag to work:
='Results (2)'!$O$32
='Results (3)'!$O$32
='Results (4)'!$O$32
='Results (5)'!$O$32
='Results (6)'!$O$32
='Results (7)'!$O$32
....etc...
I've not been able to get the name of the worksheet to actually change, it just copies Results (2) endlessly.
Bookmarks