Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatically numbering cells for large data from other sheets
I am creating an Excel sheet that summarizes data from other sheets in a
workbook. Each column of data on the summary sheet represents a certain cell of each of the other sheets. (i.e., the data from cell C6 of sheet 1 appears in cell A1 of the summary page, the data from cell C6 of sheet 2 appears in cell A2 of the summary page,...) So, the formula I am entering in cell A1 of the summary page is ='sheet 1'!C6 My question is: How can I fill the rest of column A of the summary page with the data I want without having to actually type in every formula for every cell? I would like the formula for cell A2 of the summary page to be ='sheet 2'!C6 and so on. The fill handle does not seem to work even if I use C$6 instead of C6. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatically numbering cells for large data from other sheets
See
http://www.rondebruin.nl/linksum.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "chichi0918" wrote in message ... I am creating an Excel sheet that summarizes data from other sheets in a workbook. Each column of data on the summary sheet represents a certain cell of each of the other sheets. (i.e., the data from cell C6 of sheet 1 appears in cell A1 of the summary page, the data from cell C6 of sheet 2 appears in cell A2 of the summary page,...) So, the formula I am entering in cell A1 of the summary page is ='sheet 1'!C6 My question is: How can I fill the rest of column A of the summary page with the data I want without having to actually type in every formula for every cell? I would like the formula for cell A2 of the summary page to be ='sheet 2'!C6 and so on. The fill handle does not seem to work even if I use C$6 instead of C6. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatically numbering cells for large data from other sheets
Or see
http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... See http://www.rondebruin.nl/linksum.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "chichi0918" wrote in message ... I am creating an Excel sheet that summarizes data from other sheets in a workbook. Each column of data on the summary sheet represents a certain cell of each of the other sheets. (i.e., the data from cell C6 of sheet 1 appears in cell A1 of the summary page, the data from cell C6 of sheet 2 appears in cell A2 of the summary page,...) So, the formula I am entering in cell A1 of the summary page is ='sheet 1'!C6 My question is: How can I fill the rest of column A of the summary page with the data I want without having to actually type in every formula for every cell? I would like the formula for cell A2 of the summary page to be ='sheet 2'!C6 and so on. The fill handle does not seem to work even if I use C$6 instead of C6. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically copy cells from two week day sheets based from today | Excel Discussion (Misc queries) | |||
AUTOMATICALLY CHANGING DATA FROM CELLS ON DIFF SHEETS | Excel Worksheet Functions | |||
Automatically copy data from large worksheet into individual workb | Excel Worksheet Functions | |||
XL 2003 Automatically filling in cells on two sheets on opening... | Excel Discussion (Misc queries) | |||
Printing sheets with large amts of text in some cells | Excel Programming |