VBA (Buttons) To copy and paste into separate sheet

[T.Turner]

Hi,

I am trying to write a code so that I can insert a command button and it will copy 4 separate columns and drop them into a second sheet.
There are three sheets which I want to take information from, and paste into one drop point, what I can't work out is how to get it to paste under information that has already been dropped across.

There are also headers in the 3 sheets which I need to omit.

I have attached a template worksheet for an example of what i'm trying to do.

In Spreadsheet "BACS Prepay"
The columns I am trying to pull through are "D", "F", "H", and "K" - "Row 5 is the Header" to omit

In Spreadsheet "BACS"
The columns are "B", "D", "H", and "K" -"Row 3" is the header

In Spreadsheet "Cards"
The columns are "B", "D", "F", and "J" - "Row 4" is the header

So this ideally would drop into Spreadsheet "Report" to
"A","B","C", and "D" respectively with "Row 1" being the header.
the problem I had was that it would just paste over information that I copied across and I couldn't get it to go under what had already been carried over.

I have been trying to learn through youtube tutorials but struggling a bit!

Any help would be greatly appreciated!

[AC PORTA VIA]

there is nothing in row 8 and 9 in BACS Prepay sheet-why?

[T.Turner]

I forgot to delete the rows when i copied it over to this dummy sheet but normally there isn't that gap.

Would it impact the VBA if there was a gap in the rows?

[AC PORTA VIA]

ok here is the macro for you then -just run this after you delete row 8 and 9

Please Login or Register  to view this content.

[T.Turner]

Thank you, I will try it tomorrow when I'm back at work and see how it goes.

How can I learn to write code like you?
Are there any links or sites you could recommend so I can learn a bit more.

[AC PORTA VIA]

basic you can learn by recording macro yourself and playing around with that
that is pretty much how i learned (little bit) with help of this and other forums and some great websites

[T.Turner]

Thanks again, Ill give this a shot tomorrow.

[T.Turner]

Due to my limited knowledge of VBA would it be possible to set up a sample code so that I can apply it across all sheets?

[AC PORTA VIA]

Here is macro for each sheet

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

and this is one macro for all

Please Login or Register  to view this content.

[T.Turner]

Thank you, that works on the main worksheet.

Is there a bit of code you could add in so that it picks up the workbooks name automatically or so that it didn't need the workbooks name included?
It get's re saved under a different name once a week every time we do a payment run, so for example it would be 22.01.2020 Bacs and the week after 29.01.2020 Bacs

[AC PORTA VIA]

If sheet names will be changed use this as long as they are always in the same order- for example basc prepay regardless of date will be always sheet1

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[T.Turner]

Thank you for taking the time to write all of this and help me understand how VBA coding works.