Arrange exported raw case sheet

Hi

I fixed the tag issue as it was my first post in this section

Gents is there any suggestion for fixing the macro to work on dynamic range of excel sheet in column A and C ? currently it only check the range which is selected like A2-A200
and same on C I wanted to macro to check irresepctive of the range as it changes on daily basis A:A or C:C like this

Here's how I read your problem.

Please Login or Register  to view this content.

Hi Jindon

I change the macro on list of 1800 cases for one week - the code you provide is not picking the column C data that is i dont want to miss

I created another macro that does not move the data but keep it in same sheet - but remove the duplicates Empty C columns and then arrange it date wise with last row of data
with non duplicate

can you please check this code and tell me how i can make it dynamic whatever is the range it does not matter but execute what I am seeing in 1800 records

many thanks

Please Login or Register  to view this content.

You just need to help me remove the range that is static to (excel need to check if duplicates without C columns data are remove) please arrange the sheet
without duplicates (with C column owner info) and then the second part mix it with the columns that are empty with C column

IF and else is i think required

Please Login or Register  to view this content.

Hi Jindon

I have a suggestion for your code - can you add another check in the macro that check first Display ID for duplicates and then column C (if its empty) -select all rows

Duplicate from DisplayID with empty from C row it shall be deleted

rest your code is working fine but the results are removing everything that contains C(owner) filled row in that column

thanks

I don't understand what you are talking about.

As I said the code was based on my guess, so if it is not working, just ignore it.