Example
Hi Phil,
My abbreviated spreadsheet is attached. All I am trying to do is to copy the customer name down next to all rows in columns B and C with data in them. I have to do this many times and the number of rows alters each time.
The Macro which Paul gave me works wonderfully but carries on down to the end of the formatting (in the larger spreadsheet I have it set up as a table) and when the number of records changes each time the formatting stays the same for some reason or another and I cannot delete it (if any of that makes sense to you).
Many thanks - Rod
|