I'm sure there's a solution for this and will search for it. I just played with what I learned from your tutorial and made the formula straight away! Thanks again! The only problem is that when pasting the formula all that way down column C, it lists the value in the last row of data entered all the way. Can you tell me how to make a formula that references the output of a previously calculated formula and keeps changing row by row? Many thanks. Thank you so much for your excellent tutorial. What I want is that when I pull down the cell formula from A2 to A3 from the first sheet it should pick up the value in the next cell in the next column in in the same row in the second sheet ie from A2 to B2. In my other sheet I have the data that is to be populated which is plotted in one row. Is there a quick way of making them all absolute? I want something like below when i drag down: I have a column in one sheet where I want data to be populated. If I remove the absolute I can then drag it down and get what I want - relative numbers but, I then want to make them absolute. Why use dollar sign ($) in Excel formulas - absolute and relative cell references
If I am bringing in the contents from a cell in another spreadsheet, it makes it absolute. Your articles are excellent and I usually find a fix to an issue.
