VBA Copy, Find and Paste Values to Different Sheet


New Member
Jun 8, 2020
Office Version
Hi All,

I have a file which is essentially a record of projects (+150) e.g. project title, leader, start date etc., and there is a second sheet containing some formulas to calculate project value.
I'd like to be able to copy the calculations from sheet 2, and paste them as values on a specific row in sheet 1.

However, the pasted values need to be on the row of a particular project.
For example, if I was to calculate project value now, I want to copy values from A2, B2 and C2, and paste the values in columns E, F and G on the same row as "Project XYZ".

I own the file, so I can add a dropdown with the project title on the calculations sheet if that is required.
Any help would be appreciated, as I am totally out of ideas.

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.


Well-known Member
Nov 1, 2008
So the calculation of project value on sheet 2 is done for a specific project. When you have done the calculation for project XYZ, you then want to transfer it to the XYZ row on the 1st sheet.

  • Is a little macro OK to use?
  • Are A2, B2, C2 the correct output cells on sheet 2?
  • Are columns E, F and G the correct input cells on sheet1?
  • When you do the calculation, do you have the project name filled in in a certain cell in sheet 2? which cell? Or do you want to transfer it to the selected row in sheet1?
  • In which column on sheet1 can i find the project names?

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...