Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2013, 01:40 AM
Cemetery Cemetery is offline Copying column to column automatically? Windows 7 32bit Copying column to column automatically? Office 2007
Novice
Copying column to column automatically?
 
Join Date: Aug 2013
Posts: 2
Cemetery is on a distinguished road
Default Copying column to column automatically?

I have a spreadsheet where from day to day there will be a varing number of rows containing data on sheet 1.



I would like a way to automatically have the data from column B on sheet 1 displayed on column L on sheet 2 without having to manually enter =Sheet1!B2 & dragging the formula down as I won't know without checking every time how many rows there are to do this for. Is there a way of doing this without macros?

Cheers in advance.
Reply With Quote
  #2  
Old 08-09-2013, 02:24 AM
Cemetery Cemetery is offline Copying column to column automatically? Windows 7 32bit Copying column to column automatically? Office 2007
Novice
Copying column to column automatically?
 
Join Date: Aug 2013
Posts: 2
Cemetery is on a distinguished road
Default

Never mind, just realised you can copy the column and paste as a link which does the job albeit not completely tidily
Reply With Quote
  #3  
Old 08-10-2013, 05:20 PM
excelledsoftware excelledsoftware is offline Copying column to column automatically? Windows 7 64bit Copying column to column automatically? Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Quote:
Originally Posted by Cemetery View Post
Never mind, just realised you can copy the column and paste as a link which does the job albeit not completely tidily

If your worksheet can handle as many formulas as you need you could place this formula in every cell that would need it.
=if(Sheet1!a1="","",Sheet1!a1)

Keep in mind that VBA can make this extremely easy. I use to always want to do just formulas as well until I actually learned VBA now I almost always use VBA for large sets of data.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Columns. How to move the left column so it's to the right of the 'right' column ? Vit Word 9 11-21-2012 12:57 PM
Copying column to column automatically? Automatically enter date into a column and make that column read only Mr Davo Excel 1 10-29-2012 01:07 AM
Is there a way to automatically highlight the column and the row that of the current Jamal NUMAN Excel 8 02-14-2012 02:58 PM
Can I change the horizontal scrollbar to scroll smoothly rather than column by column carpat Excel 0 01-10-2012 09:34 AM
Copying column to column automatically? Need to search a column for a macth and return a result from a third column pdfaust Excel 2 02-03-2011 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:24 AM.


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