Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2015, 09:15 AM
MatthewR MatthewR is offline Automatically Fill Cells in Other Worksheets Windows 7 64bit Automatically Fill Cells in Other Worksheets Office 2010 64bit
Novice
Automatically Fill Cells in Other Worksheets
 
Join Date: Jul 2015
Posts: 3
MatthewR is on a distinguished road
Default Automatically Fill Cells in Other Worksheets


Hi, everyone. I have a workbook with 5 worksheets. Each worksheet contains a cell in which the user types the name of their organization. I'd like to make it so that when the user types the name into one worksheet, it automatically inserts the same name into the other worksheets.

Is there a way to make this happen, regardless of which worksheet the user fills out first? Thanks for your help.

Matthew
Reply With Quote
  #2  
Old 07-08-2015, 12:35 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Automatically Fill Cells in Other Worksheets Windows 7 64bit Automatically Fill Cells in Other Worksheets Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
it can be done if the worksheets are grouped, which can be done, or manually, or with VBA.
As I'm not at all savvy, I hope someone else can help ( or perhaps on Google somewhere?)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 07-08-2015, 05:43 AM
MatthewR MatthewR is offline Automatically Fill Cells in Other Worksheets Windows 7 64bit Automatically Fill Cells in Other Worksheets Office 2010 64bit
Novice
Automatically Fill Cells in Other Worksheets
 
Join Date: Jul 2015
Posts: 3
MatthewR is on a distinguished road
Default

Thanks for the response. But if I group worksheets, won't that mean that if I add or delete rows in one worksheet, it'll add or delete rows in all of the worksheets? I don't want that to happen.

Please let me know if that's correct. Thanks.
Reply With Quote
  #4  
Old 07-08-2015, 06:44 PM
NoSparks NoSparks is offline Automatically Fill Cells in Other Worksheets Windows 7 64bit Automatically Fill Cells in Other Worksheets Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Matthew, more info please.

Are you dealing with only 5 cells, or are you talking about "sets" of 5 cells ?

If 5 cells only, what are the cell addresses on the individual sheets ?

Are you open to a VBA solution to this ?
Reply With Quote
  #5  
Old 07-09-2015, 07:13 AM
MatthewR MatthewR is offline Automatically Fill Cells in Other Worksheets Windows 7 64bit Automatically Fill Cells in Other Worksheets Office 2010 64bit
Novice
Automatically Fill Cells in Other Worksheets
 
Join Date: Jul 2015
Posts: 3
MatthewR is on a distinguished road
Default

NoSparks,

I had to finish it yesterday, so I just made the cells on worksheets 2 through 5 equal to the corresponding cell on worksheet 1.

My hope is that they'll fill out worksheet 1 first- that's the only way it'll work. But if they don't- oh well, it's not the end of the world. They'll just have to retype it 5 times.

Thanks so much for your reply. I appreciate it.

Matt
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically Fill Cells in Other Worksheets Mirror 2 cells across 2 worksheets csp Excel 1 04-16-2014 06:58 PM
Can you copy & paste cells across worksheets and preserve reference to worksheet? New Daddy Excel 2 11-27-2013 07:19 AM
Automatically Fill Cells in Other Worksheets How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM
Automatically Fill Cells in Other Worksheets Cells from other worksheets apear on current worksheet Equilar Excel 3 05-03-2010 01:40 AM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:38 AM.


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