Hi All,
First time on this forum and hoping you can help! I have a very simple 'formula' that just refers to a cell on another sheet e.g. (A1 = 'Q1 2012'!A5). Problem is, cell A1 is a merged set of cells (A1:A20) and when I drag the formula down the sheet the next cell references cell A26 from the other sheet when I need it to reference A2. Is there amy way to get it to reference the next cell each time i drag it down? I have 750 rows to do this for and don't fancy entering it every single time.
Many thanks for your help in advance. If you need more information from me please let me know.