Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match Value in Range and Then Paste
Hi all, I am looking for macro which should do something (see below)
EXAMPLE : Sub test () set OldWbk = Workbooks("Main.xlsm") Workbooks.Open Filename:= "C:\My Document\" & OldWbk.Range("A1").Value & ".xlsm" ActiveWorkbook.Range("I2:J15").Copy OldWbk.Select If (any cell.value) in OldWbk.Range("D1:F1") = OldWbk.Range("A1").Value Then Select.Offset.(of that cell).Paste End Sub Above is just rough example that what I want macro to do. Basically I want macro to open workbook of which name is in Range("A1") and then copy data from that workbook and then come back to old workbook and look in each cell of Range("D1:F1") and if any cell have same value to Range("A1") then Paste data one cell below of that cell. Please can any friend help me on this |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match, copy, paste, & color | Excel Programming | |||
Match , copy paste (using find?) | Excel Programming | |||
Compare col and match then copy and paste | Excel Discussion (Misc queries) | |||
Match name colums and paste corresponding values | Excel Discussion (Misc queries) | |||
help with match, copy, paste please | Excel Programming |