Worksheet + 1


C

CarlaInJax

I am working with multiple spreadsheets that contains many worksheets. These
spreadsheets are a compilation of work documents, each of the worksheets are
numbered sequentially. There is also a master spreadsheet to track all of
the multiple spreadsheets and their worksheets. The master spreadsheet has
links to each of the worksheets, but I would like to be able to do my link
one time and then copy and paste so that my link would be the last worksheet
plus 1. If my work sheet is 50, I'd like to be able to go to my master
spreadsheet and tell it to copy the info from work sheet 50, then the next
line would copy from work sheet 51, and the next line would copy from work
sheet 52. Is there a way to do this?
 
Ad

Advertisements

F

Franz Verga

Hi Carla,

I think you can try something like this:

=INDIRECT("Sheet"&ROW()-20&"!B23")


You should adapt accordingly to your need, this is just to give you an
idea...

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
Nel post:[email protected],
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top