Good Morning all, I could use some help creating vba code to copy columns O and P from sheet “work” to sheet “Print” based column N being either “Premier League”, “Championship”, “League One”, “League Two”, or “Vauxhall Conference” and paste values into the relevant columns in the Print sheet.
The data will be changing each week and each league will grow or shrink, I was thinking the best way to go about this is to look for criteria in column N then copy O:P then past values in Print sheet in the next available cell starting at A3 for “Premier League”, D3 for “Championship” etc.....
Any help for this would be greatly appreciated as I am stumped as to where to start.
Thanks
Bookmarks