hi guys
Im looking to copy a range of cells (aa1 to aa20 ) from sheet 'Mid v Bla' ( the sheet tab name changes dependant on whats selected in cells
In this case the game is Middlesbrough v Blackburn but could easily be Mil v Hul ie Millwall v Hull
and then paste by transpose into the next row available starying in column ab of sheet 'Championship'
is this at all possible please guys?
Last edited by swfarm; 12-12-2018 at 01:56 PM.
See if this is what you want.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
hi JLG will this still work if the sheet name changes ?
compile error syntax error
Forgot the comma after xlPasteValues.Originally Posted by swfarm
Please Login or Register to view this content.Which sheet? Based on thishi JLG will this still work if the sheet name changes ?you are selecting the cell with the sheet name for the source sheet, so the 'Sheets(Selection.Value)' should cover that. You would have to manually change the other sheet reference.the sheet tab name changes dependant on whats selected in cells
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks