Copy a cell's contents across many cells

macropod · #10 09-19-2016, 07:17 PM

For Monday, Wednesday & Friday, you could bookmark the sub-tables for each, then insert cross-references to their bookmarks wherever you want the sub-tables replicated. Likewise for Thursday mornings (you'd need a separate sub-table for Thursday afternoons). That would leave only Tuesdays & Thursday afternoons requiring individual attention. Even then, if the times are the same, you could create one sub-table for each, which you replicate via copy/paste, then fill in only the variable details.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
Linking cells: can sub-cells move with their master-cell when sorting?	kw01	Excel	1	06-30-2015 05:02 PM
Selection from cell with list contents autopopulates contents of another cell	markharper80	Excel	3	02-16-2015 04:18 PM
Copy table cell formatting across multiple cells / tables	pakistanray	Word Tables	2	10-31-2011 08:07 AM
Copy all comments & cell contents (i.e. data) to word?	IanM	Excel	0	07-03-2010 11:14 PM