Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 25-12-2008
Member
 
Join Date: Aug 2006
Posts: 162
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
Reply With Quote
  #2  
Old 25-12-2008
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: Auto filling linked data from another table in Excel 2007

Hey your data contain "$ " sign so it is considered absolute
delete the $ sign and try again, this makes the reference relative.
Reply With Quote
  #3  
Old 25-12-2008
Member
 
Join Date: Aug 2006
Posts: 162
Re: Auto filling linked data from another table in Excel 2007

hello, I did exactly what you have said and it worked for me. thanks man
__________________
Processor: AMD Athlon(tm) 64 X2 Dual Core @ ~2.2 GHz
Memory: 1024MB RAM
Hard Drive: 200 GB
Video Card: RADEON X300/X550 Series
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Auto filling linked data from another table in Excel 2007"
Thread Thread Starter Forum Replies Last Post
Getting Error message while creating Pivot table in Excel 2007: ?data source reference is not valid? Man-Than Windows Software 5 14-05-2011 10:49 AM
How to create a table of assumptions in Excel 2007 EricTheRed Tips & Tweaks 1 30-09-2009 10:10 PM
Convert Excel data to HTML Table Chalina Software Development 2 04-08-2009 11:21 PM
A Data Table in Microsoft Office Excel kattman Guides & Tutorials 7 29-04-2009 05:58 PM
Pivot Table in Excel 2007 NIcaBoy Windows Software 2 02-03-2009 03:16 PM


All times are GMT +5.5. The time now is 12:35 AM.