Thank you for your help. On the sample worksheet you can see three groups of rows, each separated by a merged cell with bold outline. The first two groups are populated with sample data, the third is not. This represents my master list, which will contain several hundred such groups, each with it's own sub-total line (labled "Direct Construction Cost"), a blank row, and a merged/bold row. The columns shaded grey here only contain data, the rest contain formulas.
The individual sheets will already be populated with formulas that have various links. I don't want to mess those formulas up. That is why I only want to copy/paste the data columns that are shown on the sample as grey.
When I select a cell in a group of rows, I want to select only the data columns from the merged/bold row above the selected cell down to and including the merged/bold row below the selected cell. I want to copy those 4 ranges and paste at the bottom of my individual sheet.
I have two problems. The first is selecting the rows between merged/bold rows. The second is overcoming the limitation on copy/paste of discontinuous ranges.
I hope that makes it more clear. Thanks again for your help.