On Sunday, July 28, 2013 6:10:00 PM UTC-7, GS wrote:
Usually, source data sheets are either not formatted or they're

pre-formatted. Thus the target sheets would be pre-formatted for the

expected data, or the data/range formatted as desired after populating

the respective cells. Ultimately, it's up to you or your client how the

target sheet looks!<g



--

Garry


Okay, after a bit more thought, seems a fairly simple macro to format say 20 to 35 sheet is really not much of a hurdle.

The Sunday afternoon laziness must have over come me.<g zzzz

Thanks, Garry, back to your nap too.

Regards,
Howard