Thread: automatically copy FIRST COLUMN ONLy to all sheets in workbook
View Single Post
 
Old 03-14-2016, 05:57 AM
nrcahill nrcahill is offline Windows 10 Office 2010 64bit
Novice
  
Join Date: Mar 2016
Posts: 3
nrcahill is on a distinguished road
Default 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
Reply With Quote