Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-14-2016, 05:57 AM
nrcahill nrcahill is offline automatically copy FIRST COLUMN ONLy to all sheets in workbook Windows 10 automatically copy FIRST COLUMN ONLy to all sheets in workbook Office 2010 64bit
Novice
automatically copy FIRST COLUMN ONLy to all sheets in workbook
 
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
 

Tags
"copy column"



Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically copy FIRST COLUMN ONLy to all sheets in workbook One macro to sort individual sheets in a workbook darbybrown Excel Programming 1 09-11-2016 12:51 PM
automatically copy FIRST COLUMN ONLy to all sheets in workbook 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
automatically copy FIRST COLUMN ONLy to all sheets in workbook Combining 2 workbooks into 1 workbook with TWO sheets dguenther Excel 1 10-06-2011 03:25 AM
automatically copy FIRST COLUMN ONLy to all sheets in workbook How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft