Copy and Paste to and from specific cells on a different worksheet

Hi,

I feel like this should be more simple than it's proving to be but I can't find any tutorials or information on how to do specifically what I am asking for.

I'm finding it hard to get my head around VBA so any help would be very gratefully recieved.

I am looking to create a button which copies and pastes data from and to specific cells. Ideally, I would like data to move from one worksheet to another but have found a way around that by replicating one cell on a different worksheet. The complication seems to come from me wanting the 'Copy Button' to be on the pasting worksheet.

The ideal solution would be to have a button on sheet 2 which copies data from multiple specific cells on sheet 1 to specific cells on sheet 2.

If that is difficult then I would also be happy with a button on sheet 2 which copies data from multiple specific cells on sheet 1 to elsewhere on sheet 1.

Many thanks

Originally Posted by Mumps1

What specific cells do you want to copy on Sheet1 and to which specific cells do you want to paste on Sheet2?

It will change because I want to have a number of buttons doing pretty much the same thing.

It could be a range, say sheet 1 B4:D44 copied to sheet 2 G4:I44 but with the button on sheet 2 with the resulting data.

Would that be possible?

Thanks

I've created a mock up of what I'm looking for. (I hope it's attached)

I would have sent the original document but there are a lot of different things going on and it'll only be more confusing.

If you open the document you will see that I want to create a series of buttons which will copy the continuous data into the relevant cells when pressed. On sheet 1 the data will continue to change but periodically I would like to press the button and copy the data into the cells below.

For example.
Autumn 1 button would copy and paste cells B3:D9 from sheet 1 to cells B5:D11 in sheet 2.
Spring 1 button would copy and paste cells B3:D9 from sheet 1 to cells E5:G11 in sheet 2.

The number of cells in the finished document are likely to be considerably more rows and columns but as long as it's possible, I think my limited skill could handle that.

Alternatively, the button could be in sheet 2 and the data could be copied to elsewhere in sheet 1 and I could duplicate the data into sheet 2. If this is also possible, could this option be offered too as I don't know which will work best in the whole project.

I have tried to record a macro and use the commands for the button but this didn't work. This is about the limit of my ability.

Thank you in advance.

That's worked perfectly.

Thank you

Hi,

This worked perfectly in my trial spreadsheet but I didn't take into account the fact that the cells that were copied contained a value as a result of a formula. When I pasted the information it pasted the formula and not the value in the cell. Therefore, the value in the cell was different. Is it possible to adapt it so that it only pastes the value and not the formula?

Thanks

This seems to have solved the problem. Thank you again.

HI everyone,

I have a similar problem but a little bit more complex.

Depending on the content of column P in sheet RFQ List I want to have the complete line removed to another sheet.
If the content in any cell in column P says lost, rejected, closed or nominatedthe complete line should be moved to a different sheet History RFQ. Column P can also have other content which will lead to the lines staying in RFQ List.
The order in the sheet History RFQ is not critical. It could be same as in RFQ List.

Once it is moved to History RFQ it should be deleted from RFQ List.

I cannot attach the excel so I am attaching a screenshot of the file for your reference.

I appreciate any support you can provide

Thank you,
Judy
Excel Macro.PNG

Noted. I am sorry.