Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet + 1
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet + 1
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 , CarlaInJax ha scritto: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions |