Copy And Paste From One Workbook to Another

[accjduncan]

Hi,
I have used MrExcel for answers more times than I can mention. You folks are great!
My problem is this: I have a Workbook (I'll call it "My Workbook") with multiple sheets, and a seperate database (I'll call it "My Database"). I'm trying to take the value of Range("O8") from sheet 4 of the workbook ("My Workbook"), search column A of the excel database ("My Database") to find a match. If a match is found, the macro will add data from Range("O12") and Range("O18") to that row, in columns B and C. If no match is found, the macro adds the data from Range("O8"), Range("O12"), and Range("O12") from sheet 4 of the workbook ("My Workbook")to the next bank row in columns A-C of the database ("My Database").

Any help would be greatly appreciated!

 

[accjduncan]

My bad: The macro should add data to the database from Range("O8"), Range("O12"), and Range("O18") of sheet 4 of the workbook if no match is found.
I'm using excel 2003

 

[accjduncan]

Wow! Nothing yet?!