Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Want some help to create cell reference in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 23-02-2012
Member
 
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.

Reply With Quote
  #2  
Old 23-02-2012
Member
 
Join Date: Aug 2011
Posts: 539
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.
Reply With Quote
  #3  
Old 23-02-2012
Member
 
Join Date: Aug 2011
Posts: 578
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Want some help to create cell reference in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
How to create fixed lengh cell and rows in Microsoft Excel Henriksen MS Office Support 2 21-02-2012 05:52 PM
Need help to create cross Reference table/Matrix in Microsoft Excel Eas!war MS Office Support 2 15-02-2012 05:01 PM
How to avoid cell reference changes after sorting in Excel Wisaal MS Office Support 2 09-02-2012 07:23 PM
Microsoft Office Excel cannot create or use the data range reference because it is too complex Error Finian-- MS Office Support 4 31-12-2011 06:11 PM
Cell Reference in Excel kamina23 Windows Software 4 08-10-2009 12:53 AM


All times are GMT +5.5. The time now is 02:55 PM.