Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 15th 07, 03:42 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 1
Default 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   Report Post  
Old June 15th 07, 06:56 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,123
Default 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   Report Post  
Old June 15th 07, 06:59 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,123
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically copy cells from two week day sheets based from today MMs4MSU Excel Discussion (Misc queries) 0 November 25th 09 03:23 PM
AUTOMATICALLY CHANGING DATA FROM CELLS ON DIFF SHEETS VROSARIO7 Excel Worksheet Functions 2 July 2nd 09 01:24 PM
Automatically copy data from large worksheet into individual workb richzip Excel Worksheet Functions 0 February 25th 08 10:10 AM
XL 2003 Automatically filling in cells on two sheets on opening... Birmangirl Excel Discussion (Misc queries) 1 August 9th 06 08:16 AM
Printing sheets with large amts of text in some cells Michael Miller Excel Programming 2 June 10th 04 05:10 PM


All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017