Auto filling linked data from another table in Excel 2007
Hello, need some help. i am new to excel 2007. When I attempt to autofill the link ='[Item Master List.xls]Master List'!$C$602
Instead of giving me the data in result, it gives me just pastes the link over and over again.
i want to drag the autofill so it automatically changes the link and goes to C603?
Thanks for any help.
Processor: AMD Athlon(tm) 64 X2 Dual Core @ ~2.2 GHz
Memory: 1024MB RAM
Hard Drive: 200 GB
Video Card: RADEON X300/X550 Series
Bookmarks