I have a workbook with several worksheets. I am creating a summary worksheet
page within the workbook. Here is what I have:
=+'Sheet1 (3)'!$H$52
I need to be able to copy that for several rows on the summary worksheet
page AND have it automatically change the sheet reference to the next sheet.
Example:
=+'Sheet1 (3)'!$H$52
=+'Sheet1 (4)'!$H$52
=+'Sheet1 (5)'!$H$52
When I copy and paste it keeps the sheet reference the exact same and
doesn't change the sheet reference to the next # automatically. Please HELP
if you know how. I have done about 2 hours of research and can't figure it
out :(