|
|
#1
08-09-2013, 01:40 AM
|
|||
|
|||
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. 
|
|
|
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 |
 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 |
|
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 |
Windows 7 32bit 
Office 2007
Threaded Mode