Export Rows based on value in column. Delete Row in current doc.

[basketcase]

Fairly new to VBA, sure this is probably quite simple!

I have a data file where column AF on sheet1 contains a reference.
I need to export all records where value is "CBL" and delete from current worksheet.
Can I use current macro in new worksheet to append 3 columns of lookup data and save as etc?

Thanks in advance.
Dave

[Naveed Raza]

Hi,

Welcome to the Excel Forum.

Could u please provide example workbook bcz its more easy to resolve ur query.

[Naveed Raza]

Hi,

Welcome to the Excel Forum.

Could u please provide example workbook bcz its more easy to resolve ur query.

[basketcase]

Hi Naveed

Please see attached. Personal data removed hence blank columns of data. This data would be in my xlsm file with other columns appended etc. Record numbers vary 10k-25k

Thanks

[Naveed Raza]

This workbook contain only 1 tab where u want to move the CBL data in new tab in this current worksheet or else u want to move to new workbook.

[basketcase]

Hi

Move to new workbook as CBL.xlsx or CBL.txt (tab delimited).

Thanks

[Naveed Raza]

plz have review the attached workbook and let me know if u hv any question

[basketcase]

Hi

Export works perfectly, can the CBL rows in Original Macro file be deleted or autofilter turned off so I can run a delete row script?

Thanks

[Naveed Raza]

Hi,

I have updated the macro and now have review and let me know if u have any question.

[basketcase]

That's great thanks.

[Naveed Raza]

k good anythng else u want frm my side

[basketcase]

I don't think so it seems to work great so just need to put into my Master macro.

Thanks again.
Dave

[Naveed Raza]

i didn't get u

macro will save in xlsm format only if u r copying macro to another workbook and that workbook format is xlsx then macro will not work.

[basketcase]

That's ok. Now the autofilter is reset I can run a script to remove rows containing "CBL".
Is it easy to change the save as to csv? If so I can import again to make my changes.