VBA to copy and paste information from c4:c25 in worksheet to specific tabs based on C4

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:

Please Login or Register  to view this content.

Any help is much appreciated.

The code in the attachment is different than the listed one.

Try instead of:

Please Login or Register  to view this content.

such code

Please Login or Register  to view this content.

Check if column names in Ward1 are the same as rownames in Form, (at some point one item is skipped)
So treat above as a idea not a ready made solution (I started from C5 because c4 describes sheet name and is not present in a sheet

Please Login or Register  to view this content.