Copy only specific cells contents to another sheet and paste at the bottom of a column

Hi AB33

I doubt you will appreciate how joyous I feel when I open a file and it works so beautifully. Just what I asked for. I will now study it and do my best to understand it. Thank you very much. I am so indebted to you and others like you. All i can do is pass on your kindness whenever I get the chance.

Thank you
Mark

Hi Mark,
You are welcome!

Hi AB33

I am trying to get to grips with your code. I am altering it to move some more stuff. Sadly I don't understand it and it won't work. I will upload the sheet again.
I am attempting to do the same filter in another table (actually the table you moved the entries to) to another table in the control sheet. Below is your code and mine below. I also upload the sheet.

Please excuse me if this is not within the Forum's rules. And I should repost it. Not sure.

Please Login or Register  to view this content.

Thanks Mark

Please feel free to have this moved to a new post if necessary.

Hi Mark,
The thread is closed but will have a last shot.
I have amended two lines of the code. The filter column is 3 not 4 as the table starts at column B. The table name is not what you have, please check the table name as the name keep changing. Column H is no longer part of the table.
The syntax in a list( Table) is quite complicate as compare to a range. There are not many documents on lists.

Hi AB££

Thanks I will keep studying it. Again thanks for all your help.

Mark

Hi AB33

I've got it. Thanks. I am thrilled.
mark