Pull Data From One Worksheet To Another

[richardSmith]

I posted this thread earlier today and @GTO saved the day for me! http://www.vbaexpress.com/forum/show...eet3-to-Sheet1 but now after delivering the data a few updates to that formatting are being requested. How would these changes be made?


Data Worksheet still holds the data returned by the query
New Format worksheet contains the 'new' format that the query should be displayed in. A few small tweaks (or at least I hope they are small)
And yes the data should be duplicated on one row and same data on the row below it.DayCareNumbers.xlsx

EDIT --
Also what if I need to increase the size of the array? (IE Add a few more doggiedaycare centers or add additional weeks?)