Hey guys,
New to VBA so struggling here.
I want to copy and paste data to a specific sheet (paste onto the next available column) depending on the value of a cell. Ex. If J6 says "Broadway", I want to copy and paste J6:J33 to sheet named "Broadway" to the next available column. Any help would be much appreciated.
New to VBA so struggling here.
I want to copy and paste data to a specific sheet (paste onto the next available column) depending on the value of a cell. Ex. If J6 says "Broadway", I want to copy and paste J6:J33 to sheet named "Broadway" to the next available column. Any help would be much appreciated.