I have a workbook with 31 worksheets. I want to use the formula
=Sheet2!$a$1 and be able to drag it down with the sheet number
incrementing to =sheet31!$a$1. Is there a way to do this?
I have a workbook with 31 worksheets. I want to use the formula
=Sheet2!$a$1 and be able to drag it down with the sheet number
incrementing to =sheet31!$a$1. Is there a way to do this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks