Forum Discussion
Change references from one sheet to another
nobiaiIt's probably best to use "Find and Replace" (Ctrl-H) to update the links to the previous sheet. For example, when you create a new sheet for "04.10" from sheet "03.10", select all cells in the new sheet, Find "02.10!' and replace with '03.10!'. Takes about three seconds to accomplish.
nobiai ,,,
Q1: Is there a way, once I make a copy of the last sheet to create a new one, that the formula picks form itself the references from the previous sheet?
Copied version is just an identical to the source and if the source sheets does have any FORMULA LINKED with sheet/sheets or Workbook, will remain as previous.
Q2: 2) Is there a way, once I insert manually the formula on the first cell, to drag that formula to the following cells but maintain the skip of line references?
For alternate row reference, you need to work with MOD(Row(Range),Rowtopick)=0 for example,,,
=SUM(IF(MOD(ROW($A$1:$A$15),2)=0,$A$1:$A$15,0))
This will SUM value from every second Row /SUM every second value in Range A1:A15
Thanks for answering.
I'm not that smart to understand the whole hint, but I will sit on that for a while and make some practice. Hopefully I will get through that.
Thanks again
