Would anyone be able to look at the document attached and tell me why the macro used fills down A2:CM2 to A3:CM3 (sheet 'Personnel (All Fields)')when there is only data present in A2 ('timeware Personnel data'). It works as intended if more is present in column A3 onwards, so I'm racking my brain trying to get around this.
Bookmarks