Good afternoon everyone,
I have a small problem with a macro I am trying to use. Basically, I have a master sheet called grant totals. In this sheet information is entered, obviously, detailing grants that have been awarded for various regions. I then have 6 other sheets titled Cardiff, Swansea, Newport etc etc. What the macro I have below does is look in column J2 where the region name is, and matches is with the sheet names and pastes it to that sheet. It works brilliantly but, it doesn’t find the next available line it simply always copies and pastes in the second row. So if I have information on a grant it will simply overwrite this and not copy and paste below it so a list forms. I hope I have explained this clearly and hope someone, anyone can help!!
Many thanks
Bookmarks