Hi
1. I have previously managed to copy and paste cells from one worksheet (named: Form) to another Worksheet (selected in Cell C4). I have managed to get it to copy the column into a row on the correct sheet, but I can't get it to go to the next available line.
2. I also want it to go to another tab, where all the data will be stored (in the same workbook, tab = "Data")
3. If one of the Cells (C28) = a specific word I want the data to also be copy and pasted into the tab i.e "B"
this is my current code:
Any help is much appreciated.
Bookmarks