Thread: Problem with copying when using '=' to link to another worksheet

I have this problem I can't quite figure out.

I have a worksheet with my bills and bank info (called Bills - 2009). I've recently started using a separate worksheet as a raw data sheet for the bank info I download from the website. Previously, I was just making more tabs in the Bills - 2009 worksheet, one for each month, but the worksheet is getting crowded and I know that many people use a raw data worksheet for this type of work.

The gist of the prob... In Bills - 2009, I use the '=' sign to link to a cell in another tab, then I would use the Handle to copy that formula to the next 2 columns (so the first is ='Sheet2'!A2, the next is ='Sheet2'!B2, next ='Sheet2'!C2, ect). However, when using the '=' to link to a cell in the separate raw data form, then trying to do the same copy of the formula's with the Handle, Excel is copying the formula EXACTLY, and I can't stop it (so first cell is ='Sheet2'!A2, but then the next is ALSO ='Sheet2'!A2 and the next ='Sheet2'!A2, instead of being B2, C2, ect). Paste special isn't the answer as this isn't a question of formatting or value.

If I have to manually change the values of the cells, then using a separate Raw data sheet is basically a waste of time. But I know this should work, so I'm now stuck.

I assume that I'm either using the wrong method to link to a cell in another worksheet (maybe I should not be using '=' but another formula option), or that there is some limitation in Excel I never knew about. I'm more inclined to think I'm doing something wrong.

Any help?

thanks!