Exception to remove duplicates function

[priyadharshane]

Hello,

I need a exception code for not deleting below content of my packing list.

Let me be clear I wrote below function to clear all unwanted duplicated from my packing list. Unfortunately, some parts has same content as Gross weight and Net weight which below code consider as duplicates and delete it off.

I want some code exception to surpass this content alone. Enclosed spreadsheet which has gross weight content which starts with lots of space as it's imported from a text file.

Need your support please


Sub DeleteRows()

Please Login or Register  to view this content.

End Sub

[priyadharshane]

Hi,

Can we make a condition if A column cell starts with Character 32 which is space it should not delete duplicates. I dont know how to compile in code. Can anyone support please?

Please Login or Register  to view this content.

[Mumps1]

Please attach a file that has more data and then explain in detail what you want to do referring to specific cells, rows and columns. It would help if you could include a sheet that contains the expected results after running the macro.

[priyadharshane]

Enclosed attachment as requested. I dont want rows highlighted in yellow deleted as duplicates

I need this content. I tried to filter out and do remove duplicates but its not working

[Mumps1]

Try this on a copy of your file:

Please Login or Register  to view this content.

[priyadharshane]

@ Mumps1

I'm sorry as im not clear enough to you

I highlighted the cell in yellow only for clarity. This is our packing list and it tends to change as dynamic

If you closely look at highlighted cell it contains Gross weight and Net weight of the boxes shipped.

Sometimes it has same value, when I apply remove duplicates function VBA assuming this as duplicates and deleting it which is needed. As you see all data is in Column A

since i'm importing it from a text file. So, I dont any content in B column which will affect text to column macro which i'm applying latter part

Prime goal of this procedure is to delete all duplicates in Column A excluding cells with gross weight in it. Excel should not consider this cell whilst deleting duplicates

Also, there should not be any content in Column B. I tried to filter and exclude cells with gross weight in it and apply remove duplicates function. Still, It is getting deleted

Please Login or Register  to view this content.

[Mumps1]

Try this version:

Please Login or Register  to view this content.

Column B which is a helper column will be cleared.

[priyadharshane]

@ Mumps1 - Awesome, it's great work and helped us to automate hectic work . You are the best

I have one more question and just let know if it's possible are not. Please let know If I need to post as different one

I will explain you the steps I do - I run a macro - It asks me to upload packing list text file - Macro runs and add new sheet before sheet 1 naming with text file itself.

My question - Is it possible to copy added sheet (Sheet name = Text file name) - Open a new work book - Paste the content and save workbook as Sheet name into specified location in computer

Let says C:\Users\Desktop\Packing list as of now. I will change it later - Text file name = Macro run sheet name = Workbook name should be same. I have already done first two.

last copied sheet must be deleted (Not sheet 1 only Macro run sheet)

Can this be done?

Kudos Mate!! I need to add more reputation for you

[Mumps1]

Can you post the macro you run to upload packing list text file?

[priyadharshane]

Here you go

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[priyadharshane]

@ Mumps1

Few things, I need to copy and save macro file only after it runs. So I added this code to compiled one

Few things causing issue,

One - It is copying sheet 1 as well and saving it in location. I dont want to consider sheet 1 which is empty

Two - New work books added is not closing. I want to get it saved in specific location thats it - I added code close active work book

Three - Active sheet which is being copied is not deleting once pasted

Please Login or Register  to view this content.

[Mumps1]

Please post the ImportPackinglistTextFile macro. You want to loop through all the sheets in the Packinglist(s) file, ignoring "Sheet1". Then you want to copy each sheet to a new workbook and save the new workbook, close the new workbook and delete the copied sheet in the Packinglist(s) file. This this correct?