Is it possible to enter a formula in the format of, "='Sheet1'!A1" and then
just click and drag and have the formula automatically go the the next sheet?
i.e "='Sheet2'!A1" instead of "='Sheet1'!A2"
Is it possible to enter a formula in the format of, "='Sheet1'!A1" and then
just click and drag and have the formula automatically go the the next sheet?
i.e "='Sheet2'!A1" instead of "='Sheet1'!A2"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks