Luke that’s great works a treat!! Just one more big thing where the Mother data is split into 50 rows I need the last row finding in the child data and the child data needs to be split into rows of 500 and put into child tabs.
Mother Data example.
Number Site Date
XXX...
i have a workbook with 2 worksheets Mother and child, i need the mother worksheet to be split into rows of 50 and pasted into new worksheet named "data1" and the next 50 rows of data to new worksheet "data2" till all the data is split ( the data is in coloums A2 to K2 and the rows can be any...