Hi and thank you for helping. (Excel 2010) I have a workbook with three worksheets. Each worksheet has the same first column, with the heading "Name." I type the words "Cloud Array" into the first cell in the "Name" column in worksheet 1. Is there a way to AUTOMATICALLY copy that cell text (Cloud Array) into the corresponding cell in ALL three of the worksheets?
Hi nrcahill
Yes
If you hold down shift click tab sheet 1 them tab sheet 3 (assuming they are in order) they will all be highlighted so anything typed or formatted will go across all the sheets, to get back to one sheet then shift and select the tab required.
Also
If you use control instead of shift you can select the sheets individually.
And, if you've already added data to the first sheet, Use ForestView's method to select the other sheets and , on the Home Tab, to the left of "Sort and Filter", there is a blue arrow pointing down. If you select that, you'll see a dropdown menu. One of the options (which is grayed out unless you've selected other sheets) is "Across Worksheets..." This will copy what you've selected on sheet1 across all other selected sheets.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
MAGIC! Worked perfectly -- thank you so much!
thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks