I am trying to do some extensive formula writing that involves complex sheet referencing. In my attempts, I do not understand the numbers that come after the R and C in the following. They do not seem to be linear like row and column headings. Could someone explain to me how these numbers work?
Hello E-Coli !
the square brackets are used for relative adressing :
if the active cell is C3 (third row / third column), R[-2]C corresponds to J1 (2 rows backwards and 7 columns forward)
For absolute adressing, do not use the square brackets :
R2C7 corresponds to $G$2 (second row / seventh column)
Thank you very much. I can't believe something so simple was causing me such problems.
I have another one for you:
How can I automatically create and name worksheets in a workbook based on a list that exists in another sheet "Summary" in the workbook? The list begins at cell A10. Mind you, this list will vary from workbook to workbook. Do you have some code already compiled to perform this?