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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.


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?

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...