Search : in
By :

Change cell reference mutliple sheets formula

Last answer on Oct 20, 2009 10:13:49 am BST Olivia, on May 14, 2009 2:44:31 pm BST 
 Report this message to moderators

Hello,

I have 7 spreadsheets that I am currently using the IF formula for. These spreadsheets all have the same format so currently the formulas sits at:

=IF(Sheet1!C5="",Sheet2!C5,Sheet1!C5)

This is want I am trying to say, if Column C has one of the cells that is empty, then move to column C in the next sheet and so forth. The problem is sheet 2 does not start specificly with cell 'C5', instead, it references with the cell in the previous sheet.

Example:
=IF(Sheet1!C6="",Sheet2!C6,Sheet1!C6), all at C6's
=IF(Sheet1!C7="",Sheet2!C7,Sheet1!C7), all at C7's
=IF(Sheet1!C8="",Sheet2!C8,Sheet1!C8), all at C8's

I want each sheet to start at cell C5 no matter where the previous sheet cell ends off. When it finds a cell in column C that is empty, go to the next sheet starting at C5.

I hope I made sense.

Thanks in advance for helping.

Olivia

Configuration: Windows XP Internet Explorer 8.0

Best answers for « Change cell reference mutliple sheets formula » in :
[VBA] Detecting changes in cell Show [VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
How to make a cell change colour Show
Excel Formula Display in Cell (Solved) Show
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
Changing the color of the command prompt(shell) ShowChanging the color of the command prompt(shell) Purpose Methods Purpose Changing the color of characters in the prompt (or shell), make them more readable. If you are using colors group, you can sense by color, this will eliminate the...
[VBA] Deleting a word in a range of cell Show[VBA] Deleting a word in a range of cell In the case you want to delete a word in a sentence, just create a small macro that removes the word. But it will become difficult when you have word like, for example, "Theword" or "THEWORD" or...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

mubashir aziz, on May 19, 2009 8:10:56 am BST
  • +2

If sheet1 cell C5 is not empty then it will never go to Sheet2!C5 and will give the value of sheet1!C5 ..... make blank your sheet1!C5 then your formula will go onward ........ Just check and tell me if there is still problem .....

Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz

2

msi, on Oct 13, 2009 6:48:32 am BST

How can i translate of 200.25 resulting to two hundred & 25/100

   
Reply to msi

3

 mubashir aziz, on Oct 20, 2009 10:13:49 am BST

Just select the cell and then go to Format>Cell>Number>Fraction and on left side window select desired format .....

Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

   
Reply to mubashir aziz
Ask your question Reply
They need your help