I have two spreadsheets in one workbook. One is a "Master" work sheet with about 800 names in Column A separated by 24 rows. For example rows 6, 30, 44.... Up to 16302. In the areas between the names is data in columns B through L twenty deep, for example B9:L28, B33:L52 etc up to B16305:L16324.The other spreadsheet called "Update" has 120 names in column A. These names are in groups of eight separated by 24 rows. For example A6, A30 up to A174. This is repeated with a different set of 8 names starting with A214, A422, A630 so that there is a total of 15 sets of 8.
What I would like to do is fill the area in the "Update" with the data of the corresponding name in the "Master". For example, the first name in the "Update" is in "A6". The corresponding name in the "Master" happens to be in "A14190". I would like to copy the data from the block B14193:L14212 or the data in the block which is shifted one column and three rows from the name and Is 11 wide by 20 deep, and paste it into the corresponding area in "Update". In other words into B9:L28. This needs to be done for all 120 names in "Update".
I've tried to do this by modifying the code you sent me to solve what I thought was a similar problem, but had no luck. I hope you can help me again.
Many thanks in advance.
Lou
