according to sheet two delete first sheet data

[johncena]

dear friends here i have attached my work sheet.in my document has two work sheets.first one is "dye que" & second one is "production sheet".this production sheet data has machine wise.my question is if second sheet column "G" is not empty & same row column "B" value match with sheet one any cell,that cell all data should delete.pls any body can make macro for this.it's very big help for me.thanks..

[JBeaucaire]

Since row 7 has a value in G7 and B7 is 128801 which is found on the Dye Que sheet in cell C4, then the entire row 7 should be deleted from the Production Sheet?

If so, this will do that:

Please Login or Register  to view this content.

[johncena]

thanks JB.your comparing is correct.but i need to delete dye que C4 cell(as per your example).no need to do anything in production sheet.according to production sheet dye que need to update,

[JBeaucaire]

Try this then:

Please Login or Register  to view this content.

[astrikor]

I send files to a third party automatically via dropbox, but I first need to delete confidential macros contained in one of the files. Can anyone suggest code which will clear some (or preferably all) of the macros in the file?
Thanks
Astrikor

[JBeaucaire]

Save the file as an Excel 2007 .xlsx file. That is not a macro-enabled workbook, and a nifty way to strip them all at once.

If you're using Excel 2003, like I am, just install Microsofts compatibility addin and you will be able to read and write Excel 2007 formats.

[shg]

astrikor,

Please take a few minutes to read the forum rules, and then start your own thread.

[johncena]

thanks u very much JB.your macro work very well,thanks a lot again...