Lookup date in ws1 and find same date in ws2 copy and paste

Spaceballs_fan · Mar 22nd 2018

Hi. I have also posted this question here: https://www.mrexcel.com/forum/…-date-ws2-copy-paste.html
I have an worksheet that is updated every week.
However, I want to copy and paste the values from 2 different cells into another worksheet.
Worksheet 1 will have a date entered in cell H1.
I want to find the date from Sheet1 H1 in Column A on worksheet 2, and then I want it to copy the value (as the cell contains a formula and I don't want the formula to copy) and paste it into the same row Column B. I would like to do the same for another cell into the same row in Column C.

Your help is much appreciated.

chirayuw · Mar 22nd 2018

sample file please

Spaceballs_fan · Mar 22nd 2018

Quote from chirayuw

sample file please

Here is a sample. Thanks for looking.

**Ger Plante** · Mar 22nd 2018

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

*

chirayuw · Mar 26th 2018

try this

Code

Sub VAL_PASTE()


Dim Bval As Double
Dim CVal As Long
Dim DT As Date


With Sheets("Sheet1")
    DT = .Range("G1")
    Bval = .Range("F3")
    CVal = .Range("H5")
End With


Sheets("Sheet2").Select
Range("A:A").Find(what:=DT, LookIn:=xlValues, lookat:=xlWhole).Activate
Range("B" & ActiveCell.Row) = Bval
Range("B" & ActiveCell.Row).NumberFormat = "0%"
Range("C" & ActiveCell.Row) = CVal
Sheets("Sheet1").Select


End Sub

Display More

Lookup date in ws1 and find same date in ws2 copy and paste

Participate now!

Share