Macro to move information from one workbook sheet to another

[cory0789]

I have 2 workbooks, say workbook1 and workbook2 for example. workbook2 is blank, workbook1 has all of my information.

I need workbook1 to have the information on sheet1 to be copied onto sheet 1 of workbook2.

Say workbook1 has sheet1 with the following information, i ONLY want the information that does NOT have an X in column C to copy over to the other workbook.
So it should search each row and if there is NOT an X in column C it should copy the row to the other workbook.
COLUMN
A B C
APPLES 500 X
ORANGES 400
GRAPESN 550 X
LEMONS 480 X
LIMES 558


Thanks for all the help!!!

[spitfireblue]

Hi,

Probably the easiest way is to copy all the data to a new workbook and delete any rows where the X is in column 3. Something like this...

Please Login or Register  to view this content.

You can then add to the code to save the new workbook etc. if you wish.

[cory0789]

I will be using the other sheets in the workbook I need to copy this data to though... so that wont work. Any other ideas?

[spitfireblue]

No problems, here you go. You will need to modify the name and location of the workbook you are copying to though.

Please Login or Register  to view this content.