HI
have to re arrange the data (file attached)
the target is to create sheet 2 based on info in Sheet 1 column C ( take only data containing words "Renovation", "Disposal", "New sites" )
Sheet 2 row A is hard coded so no code is required
how the code may be?
thanks in advance
AC
Bookmarks