Hi,
I have tried to solve this problem myself, but am struggling with some of the code that is online as I am very new to VBA.
What I want to do is write data in one tab and then run a macro that copies the data and pastes it into another tab, it then wipes the original data that was input and is ready for more data to be loaded. The difficulty I am having is getting the code to find the next blank cell and then post the data there rather than overriding the data from running the first macro.
Specifically my coding is as such.
Sub Macro2()
Sheets("INPUT").Select
Range("B4:J15").Select
Selection.Copy
Sheets("USERDATA").Select
Range("B9:J20").Select ******Instead of pasting into this range I want it to find the first blank space in column B9 and then paste********
ActiveSheet.Paste
Sheets("INPUT").Select
Range("B4:J15").Select
Selection.ClearContents
End Sub
Any help on how I would code that specific part would be appreciated.
Thanks
Dom
Bookmarks