Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-30-2012, 06:58 AM
msheyworth msheyworth is offline linked cells Windows XP linked cells Office 2007
Novice
linked cells
 
Join Date: Mar 2012
Posts: 21
msheyworth is on a distinguished road
Default linked cells


I am trying to series fill linked cells from sheet 1 to sheet 2 but when i copy the first cell and link it ( sheet 1 $a$7) and try to series fill to the next columns it dose not offer to series fill just lets you copy
Reply With Quote
  #2  
Old 03-30-2012, 08:19 PM
JBeaucaire JBeaucaire is offline linked cells Windows XP linked cells Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

The $ symbols are "locks". Remove the "locks" on the part of the reference you want to adjust itself when copied.

$A$1 = locked column, locked row
$A1 = locked column, adjustable row
A$1 = adjustable column, locked row
A1 = adjustable column, adjustable row
Reply With Quote
  #3  
Old 03-31-2012, 03:05 AM
msheyworth msheyworth is offline linked cells Windows XP linked cells Office 2007
Novice
linked cells
 
Join Date: Mar 2012
Posts: 21
msheyworth is on a distinguished road
Default

I have tried that it works if you are going down a column but i want to go across columns ie. sheet 1 a1,a2,a3,a4,etc to show in sheet 2 b1,c1,d1,e1 etc without having to copy each one at a time as it may go to sheet 1 a???.
Reply With Quote
  #4  
Old 04-03-2012, 08:08 AM
JBeaucaire JBeaucaire is offline linked cells Windows XP linked cells Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

No, that's completely different. But you can create a formula that resolves to the same effect as that. On Sheet2 in cell B1, enter this formula, then copy to the right:

=INDEX(Sheet1!$A:$A, COLUMN(A1))
Reply With Quote
  #5  
Old 04-03-2012, 08:32 AM
msheyworth msheyworth is offline linked cells Windows XP linked cells Office 2007
Novice
linked cells
 
Join Date: Mar 2012
Posts: 21
msheyworth is on a distinguished road
Default

that works i would like to know what the how the formula is put together for other parts of my workbook thanks
Reply With Quote
  #6  
Old 04-03-2012, 03:12 PM
JBeaucaire JBeaucaire is offline linked cells Windows XP linked cells Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

Press F1 and read the tutorials in Excel on the functions:

INDEX
COLUMN
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
placing linked Excel cells in Word next to a chart Paul-NYS Word 4 03-16-2012 12:59 PM
linked cells listing linked graphics eng1ne Drawing and Graphics 5 02-28-2012 06:42 AM
Linked graphics eNGiNe Word 2 02-20-2012 10:52 PM
Linked Tables afpapa2 PowerPoint 0 12-01-2011 09:25 AM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft