Macro to copy range and paste to other sheet

[Will29]

Hi all!

I'm new to the forum and a bit of a novice at VBA though I've had a little experience with it in the past. So my question...

I'm using a macro. Every time a click it I want it to copy information from cells A1-4 in Sheet 2 and paste it in cells B2-E2 in Sheet 1 (that's the easy bit for me as I just use the record macro function).

I then want the macro to move to the next row in Sheet 1 (B3-E3) when I click it again. However the information it will be getting is still from A1-4 in Sheet 2 (as I will be changing it when I need to).

Cheers all!

[OllieB]

Try

Please Login or Register  to view this content.

@Arlu, I posted the answer before I saw your notice. Sorry

[Will29]

Sorry about that. But thank you. Problem solved.

[Sean Thomas]

Please Login or Register  to view this content.

[arlu1201]

Sean,

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

[arlu1201]

Will29,

Its good that you received the solution. But for the benefit of others who will be looking for a similar solution, its better if you change the title.

[zbor]

OllieB, you didn't see unadequately title?
Sean Thomas, you didn't see pending request?

Hardly to belive...

[arlu1201]

Zbor,

OllieB and my post were around the same time, so timing issue.

Sean Thomas has been given an infraction.

[OllieB]

OllieB, you didn't see unadequately title?

Request was clear, I indeed should have picked up on the poor title. Sorry

[zbor]

Zbor,

OllieB and my post were around the same time, so timing issue.

Sean Thomas has been given an infraction.

I saw. I wasn't pointin OlliB for that. AlsoI've cganged title since Will29 is gone.

[Sean Thomas]

Sorry guys,
when i first viewed the question there was no moderators request, only the original thread.
I was working on solution and entered my answer on the page i had open. therefore my response was added after moderators request.
Therefore i feel it was a bit harsh giving me an infraction (didnt even no what that was or that it existed until now).
I shall watch out for that one in future.

Sean