Results 1 to 3 of 3

Thread: Want some help to create cell reference in Microsoft Excel

  1. #1
    Join Date
    Feb 2012
    Posts
    11

    Want some help to create cell reference in Microsoft Excel

    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.
    • 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.

  2. #2
    Join Date
    Aug 2011
    Posts
    542

    Re: Want some help to create cell reference in Microsoft Excel

    Did you tried to find information on the help (F1) in Excel. I am not sure what you are trying to do. You can try to find easy templates for the same in office help online. Regarding references it can be done via = giving reference of multiple sheets.

  3. #3
    Join Date
    Aug 2011
    Posts
    582

    Re: Want some help to create cell reference in Microsoft Excel

    That will be very complicated. You will need to link all the files with each other in every cell and also keep a track of whatever changes are done. You have to see properly all the steps. Cross referencing can be done manually and I do not think there is any kind of addin for that.

Similar Threads

  1. How to create fixed lengh cell and rows in Microsoft Excel
    By Henriksen in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 04:52 PM
  2. Replies: 2
    Last Post: 15-02-2012, 04:01 PM
  3. How to avoid cell reference changes after sorting in Excel
    By Wisaal in forum MS Office Support
    Replies: 2
    Last Post: 09-02-2012, 06:23 PM
  4. Replies: 4
    Last Post: 31-12-2011, 05:11 PM
  5. Cell Reference in Excel
    By kamina23 in forum Windows Software
    Replies: 4
    Last Post: 07-10-2009, 11:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •