T
thepartydj
I have one workbook ("WB1") with two worksheets (Sheet1 & Sheet2). Eac
worksheet has most of the same information, and I want to create
macro that will cobine each worksheet. Also some information i
different on both sheets. Here is what I want to do....I just don'
know how to write the macro code.
**************
Start on "Sheet1"
Look at cell B1 (phone number) if B1 matches a phone number in "Sheet2
column A, cut the whole line from "Sheet2" and paste the line i
"Sheet1" starting in F1.
Then move to line2 and go all the way through to end of file.
***********
Does that make sense? ThankS
Please help me out. Thank you
worksheet has most of the same information, and I want to create
macro that will cobine each worksheet. Also some information i
different on both sheets. Here is what I want to do....I just don'
know how to write the macro code.
**************
Start on "Sheet1"
Look at cell B1 (phone number) if B1 matches a phone number in "Sheet2
column A, cut the whole line from "Sheet2" and paste the line i
"Sheet1" starting in F1.
Then move to line2 and go all the way through to end of file.
***********
Does that make sense? ThankS
Please help me out. Thank you