I have set up a MasterBook with several MasterSheets to record the results of a survey. On each MasterSheet there are a set of columns to record replies from a family of individuals.
Is there a way to select the range of columns and then to copy them across (to next blank column) a fixed number of times (say 40 family set repeats)?
No complications of data or cells to hide or skip. Just replicating out the say 40 times, rather than simply copying and pasting.
I take it that if I Control Select all the MasterSheets and the set of columns (which are common across all sheets) I can replicate out these selected set of columns say the 40 times across the WorkBook?