Reply to thread

Message: [QUOTE="Fred Smith, post: 3122989"] Using addresses with $ does work properly in Excel. When you dragged the '$C14' formula, did you drag it to a different column, or a different row? You need to drag it to a different row in order for the address to change. I suspect your problem is the 'different sheet which is set up in rows'. It sounds like your data needs to be transposed before your formula is going to work. My other suggestion is to mask the file names you are posting. Posting the acutal file names gives out too much personal information. Use a generic names like Sheet1 and Sheet2. It will also make your posts much easier to read. Regards, Fred. [/QUOTE]