LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bill Nash
 
Posts: n/a
Default How do I reference non-contiguous columns in another sheet and th.

I have a worksheet that contains several years of montlhy data on cost
increases and decreases. I have another sheet w/ one column that summarizes
the first quarter's data. How do I fill across on the second sheet so that
the cells contain the correct data from the monthly sheet and the correct
forlmulas from the first column on the quarterly sheet? This means the second
sheet has to reference non-contiguous columns on the first sheet.
This

Thank you

Bill Nash


 
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
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
Formulas: Keeping same row/column reference when columns are inser Mike Excel Discussion (Misc queries) 5 February 11th 05 09:37 PM
print excel columns on less pages a_ryan1972 Excel Discussion (Misc queries) 1 February 9th 05 05:41 PM
Incrementing rows (or columns) to a reference in another worksheet Ignobilitor Excel Worksheet Functions 2 January 20th 05 03:45 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM


All times are GMT +1. The time now is 06:44 AM.

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

About Us

"It's about Microsoft Excel"