Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking worksheets
I have a workbook set up where my worksheets are linked. When I use a fill
handle one my dependant worksheet, it will not change the number by one. The number in represents the name of the independant worksheets. Will the fill handle not work in this case because the number is actually a name for the worksheet itself? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking worksheets
You can use the indirect function
This will use the row number where the function is copy this in C1 for example to display the value of Sheet1!A1 =INDIRECT("Sheet"&ROW()&"!A1") You can copy down for Sheet2.........Sheet? -- Regards Ron de Bruin http://www.rondebruin.nl "cjgeorge" wrote in message ... I have a workbook set up where my worksheets are linked. When I use a fill handle one my dependant worksheet, it will not change the number by one. The number in represents the name of the independant worksheets. Will the fill handle not work in this case because the number is actually a name for the worksheet itself? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking worksheets
This is helpful but I still have a glitch somewhere. In my dependant
worksheet (sheet 1), It will pull the information in cell A7 from sheet 18 cell a17. The fill handle will then only pull 2 more pieces of information - in cell A8 it pulls from sheet 19 cell A17 and in cell A9 it pulls from sheet 20 cell A17. This is the right idea, however in cell A7 I need to pull from sheet 2 cell A17; in cell A8 I need to pull from sheet 3 cell A17; in cell A9 I need to pull from sheet 4 cell A17 and so on. I want to be able to use the fill handle so that it just changes to the next sheet but still pulls data from A17. Starting with sheet 2, my sheet name is CO_1; sheet 3 is named CO_2 and so on. "Ron de Bruin" wrote: You can use the indirect function This will use the row number where the function is copy this in C1 for example to display the value of Sheet1!A1 =INDIRECT("Sheet"&ROW()&"!A1") You can copy down for Sheet2.........Sheet? -- Regards Ron de Bruin http://www.rondebruin.nl "cjgeorge" wrote in message ... I have a workbook set up where my worksheets are linked. When I use a fill handle one my dependant worksheet, it will not change the number by one. The number in represents the name of the independant worksheets. Will the fill handle not work in this case because the number is actually a name for the worksheet itself? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking worksheets
Confused
You use 3* the cells A7:A9 If you want to display in A7 the info of Sheet18 then add 11 to the row() function =INDIRECT("Sheet"&ROW()+11&"!A17") -- Regards Ron de Bruin http://www.rondebruin.nl "cjgeorge" wrote in message ... This is helpful but I still have a glitch somewhere. In my dependant worksheet (sheet 1), It will pull the information in cell A7 from sheet 18 cell a17. The fill handle will then only pull 2 more pieces of information - in cell A8 it pulls from sheet 19 cell A17 and in cell A9 it pulls from sheet 20 cell A17. This is the right idea, however in cell A7 I need to pull from sheet 2 cell A17; in cell A8 I need to pull from sheet 3 cell A17; in cell A9 I need to pull from sheet 4 cell A17 and so on. I want to be able to use the fill handle so that it just changes to the next sheet but still pulls data from A17. Starting with sheet 2, my sheet name is CO_1; sheet 3 is named CO_2 and so on. "Ron de Bruin" wrote: You can use the indirect function This will use the row number where the function is copy this in C1 for example to display the value of Sheet1!A1 =INDIRECT("Sheet"&ROW()&"!A1") You can copy down for Sheet2.........Sheet? -- Regards Ron de Bruin http://www.rondebruin.nl "cjgeorge" wrote in message ... I have a workbook set up where my worksheets are linked. When I use a fill handle one my dependant worksheet, it will not change the number by one. The number in represents the name of the independant worksheets. Will the fill handle not work in this case because the number is actually a name for the worksheet itself? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking worksheets
In cell B7 on my dependent worksheet (sheet 1), I want to display the
information from Sheet2 cell A17. I would then like to use the fill handle so I don't have to retype the formula in each B cell. Cell B8 on Sheet 1 should display info from Sheet 3 cell A17. Cell B9 on Sheet 1 should display info from Sheet 4 cell A17. Cell B10 on Sheet 1 should display info from Sheet 5 cell A17. Hopefully this makes sense. I am still not able to get this to work quite right. "Ron de Bruin" wrote: Confused You use 3* the cells A7:A9 If you want to display in A7 the info of Sheet18 then add 11 to the row() function =INDIRECT("Sheet"&ROW()+11&"!A17") -- Regards Ron de Bruin http://www.rondebruin.nl "cjgeorge" wrote in message ... This is helpful but I still have a glitch somewhere. In my dependant worksheet (sheet 1), It will pull the information in cell A7 from sheet 18 cell a17. The fill handle will then only pull 2 more pieces of information - in cell A8 it pulls from sheet 19 cell A17 and in cell A9 it pulls from sheet 20 cell A17. This is the right idea, however in cell A7 I need to pull from sheet 2 cell A17; in cell A8 I need to pull from sheet 3 cell A17; in cell A9 I need to pull from sheet 4 cell A17 and so on. I want to be able to use the fill handle so that it just changes to the next sheet but still pulls data from A17. Starting with sheet 2, my sheet name is CO_1; sheet 3 is named CO_2 and so on. "Ron de Bruin" wrote: You can use the indirect function This will use the row number where the function is copy this in C1 for example to display the value of Sheet1!A1 =INDIRECT("Sheet"&ROW()&"!A1") You can copy down for Sheet2.........Sheet? -- Regards Ron de Bruin http://www.rondebruin.nl "cjgeorge" wrote in message ... I have a workbook set up where my worksheets are linked. When I use a fill handle one my dependant worksheet, it will not change the number by one. The number in represents the name of the independant worksheets. Will the fill handle not work in this case because the number is actually a name for the worksheet itself? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking worksheets
In B7 this formula
=INDIRECT("Sheet"&ROW()-5&"!A17") and copy down -- Regards Ron de Bruin http://www.rondebruin.nl "cjgeorge" wrote in message ... In cell B7 on my dependent worksheet (sheet 1), I want to display the information from Sheet2 cell A17. I would then like to use the fill handle so I don't have to retype the formula in each B cell. Cell B8 on Sheet 1 should display info from Sheet 3 cell A17. Cell B9 on Sheet 1 should display info from Sheet 4 cell A17. Cell B10 on Sheet 1 should display info from Sheet 5 cell A17. Hopefully this makes sense. I am still not able to get this to work quite right. "Ron de Bruin" wrote: Confused You use 3* the cells A7:A9 If you want to display in A7 the info of Sheet18 then add 11 to the row() function =INDIRECT("Sheet"&ROW()+11&"!A17") -- Regards Ron de Bruin http://www.rondebruin.nl "cjgeorge" wrote in message ... This is helpful but I still have a glitch somewhere. In my dependant worksheet (sheet 1), It will pull the information in cell A7 from sheet 18 cell a17. The fill handle will then only pull 2 more pieces of information - in cell A8 it pulls from sheet 19 cell A17 and in cell A9 it pulls from sheet 20 cell A17. This is the right idea, however in cell A7 I need to pull from sheet 2 cell A17; in cell A8 I need to pull from sheet 3 cell A17; in cell A9 I need to pull from sheet 4 cell A17 and so on. I want to be able to use the fill handle so that it just changes to the next sheet but still pulls data from A17. Starting with sheet 2, my sheet name is CO_1; sheet 3 is named CO_2 and so on. "Ron de Bruin" wrote: You can use the indirect function This will use the row number where the function is copy this in C1 for example to display the value of Sheet1!A1 =INDIRECT("Sheet"&ROW()&"!A1") You can copy down for Sheet2.........Sheet? -- Regards Ron de Bruin http://www.rondebruin.nl "cjgeorge" wrote in message ... I have a workbook set up where my worksheets are linked. When I use a fill handle one my dependant worksheet, it will not change the number by one. The number in represents the name of the independant worksheets. Will the fill handle not work in this case because the number is actually a name for the worksheet itself? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Worksheets | Excel Worksheet Functions | |||
I am getting #VALUE! when linking worksheets - what am i doing wro | Excel Discussion (Misc queries) | |||
Linking Excel Worksheets | New Users to Excel | |||
Linking Several Worksheets to One Worksheet | Excel Discussion (Misc queries) | |||
Linking across worksheets not working as desired | Excel Worksheet Functions |