#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Never mind, just realised you can copy the column and paste as a link which does the job albeit not completely tidily
|
#3
|
|||
|
|||
Quote:
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. |
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 |
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 |