Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 14th 12, 11:35 PM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2012
Posts: 2
Default Help with cell referencing.

I have an Excel file which contains multiple worksheets.

Worksheet 1 has data that is imported from an external source. The data is imported in rows. For example row 1 is the data name (header). Row 2 is data set 1, row 3 is data set 2, row 4 is data set 3......etc. etc.

Worksheet 2 just has the data transposed into columns. So the header is column A, column B is data set 1, colum C, is data set 3......etc. etc.

Worksheets 3, 4 ,5....and so on are the presentation sheets (printed reports will be generated from these sheets.

Worksheet 3 only requires data from column B of Worksheet 2. However the presentation of Worksheet 3 requires the data to be in certain cells (not in a single column format)

What I have done is set up Worksheet 3 to look exactly as I need it by referencing the appropritate cells in Worksheet 2, column B. So Worksheet 3 is basically a sheet of cells referenced back to Worksheet 2, column B in a user friendly format that can be printed.

Here is where I need help. Worksheet 4 is an exact copy of Worksheet 3 but needs the data in column C of worksheet 2 instead of column B with the rows being consistent. For example cell D35 in Worksheet 3 needs the data in cell B15 of Worksheet 2 and cell D35 of Worksheet 4 needs the data in cell C15 of Worksheet 2.

Since worksheet 3 is set up I made a copy of it to become Worksheet 4. My question is how do I change all of the cell references to column C without manually doing it? Is there a function I can use ?

Any help would be appreciated.

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
Cell Referencing truthband Excel Discussion (Misc queries) 1 June 30th 08 10:38 PM
cell referencing [email protected] Excel Worksheet Functions 5 February 20th 08 11:11 PM
Referencing Cell Next To Today's Date Cell Docktondad Excel Discussion (Misc queries) 5 May 16th 07 10:25 PM
referencing a name from a cell value name Excel Discussion (Misc queries) 1 July 3rd 06 03:55 AM
Cell referencing ED Excel Programming 3 July 23rd 04 11:23 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017