Forum Discussion
Populating multiple cells on multiple sheets from one cell/sheet?
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 distr...
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.
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
