|
|
#1
03-14-2016, 05:57 AM
|
|||
|
|||
automatically copy FIRST COLUMN ONLy to all sheets in workbook
I have a workbook with three sheets. The first column of each sheet has the heading "Name". Is there a way to automatically replicate the data in Column 1/Sheet 1 to Column 1 in Sheets 2 and 3? For example, if I enter "Gordon" as my first listing in Sheet 1, Column 1, how can I get that to automatically replicate in Column 1 of Sheets 2 and 3? A helpful expert recommended holding down the "Ctrl" key, then selecting each of the worksheet tabs -- but this copies ALL the data in ALL the columns, whereas I want to copy only the data in Column 1. Thank you! Last edited by nrcahill; 03-14-2016 at 05:58 AM. Reason: Clarification 
|
| Tags |
| "copy column" |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 One macro to sort individual sheets in a workbook
|
darbybrown | Excel Programming | 1 | 09-11-2016 12:51 PM |
|
How add 3 footer items to all sheets in workbook?
|
Mendopaul | Excel | 3 | 12-05-2013 02:32 PM |
| Copy Column setting to other spreadsheets in an excel workbook | officeboy09 | Excel | 5 | 11-05-2013 01:49 AM |
|
Combining 2 workbooks into 1 workbook with TWO sheets
|
dguenther | Excel | 1 | 10-06-2011 03:25 AM |
|
How do I merge data from one sheet in a workbook out into multiple sheets
|
nolesca | Excel | 4 | 06-07-2010 08:13 AM |
Windows 10 
Office 2010 64bit
Threaded Mode