Home

Populating multiple cells on multiple sheets from one cell/sheet?

oliviagarde
New Contributor

So I am trying to populate text from one sheet and one cell to multiple sheets/cells.  So for instance I am trying to have it where the user can type text in a cell and then it is automatically distributed to multiple sheets and specific cells on the those sheets.  What I am trying to do is make a weekly Plan of the Day my boss can fill out on Monday and it will fill all the other days (sheets) after to Friday.  Can this be done....I cant quite figure out what function in auto sum does this...I am assuming its in there somewhere.  Thanks!

3 Replies
Hi

If you have separate sheets for Monday to Friday and they are all exactly the same structure then by Ctrl Clicking each sheet you can highlight them all then anything you type in one cell on one sheet will be replicated on all sheets.

Is that the sort of thing you are wanting to do?

Anything more advanced than that would likely require VBA (Macro) to be written.
How do you do this on Excel online?
It doesn't appear to be possible in Excel online
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies