Hi,
I would need your help to create a macro for the following task.
In the attachment yuo can find sample workbook.
From sheet ("Main") I have values in cells B2:E2. I have to find the value of B2 in worksheet ("DB") and copy C2 and E2 to the related rows (column B and C) in ("db").
I tried the following without success:
Please Login or Register to view this content.
Last edited by ccsmith; 12-05-2016 at 11:26 AM.
Try the attached.
Thanks. It is working perfectly.
AB33: Just one thing. Can you modified the copy row to paste only the value (without formula and formatting). Many thanks in advance.
Replace the single line with
Union(.Range("C" & rng.Row), .Range("E" & rng.Row)).Copy
acell.Offset(, 1).PasteSpecial xlValues
Application.CutCopyMode = 0
Thanks for your kindness.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks