Dear Friends,
I am working with excel on sorting alphanumeric code to let my colleagues find the data easily.
See the attached sheet for more information. Please write back to me if you have any queries.
Thank you in advance.
Subash P
Dear Friends,
I am working with excel on sorting alphanumeric code to let my colleagues find the data easily.
See the attached sheet for more information. Please write back to me if you have any queries.
Thank you in advance.
Subash P
not sure you require VBA for this
a helper column should suffice
put this in H2 and fill down then sort by column H
Formula:Please Login or Register to view this content.
if you must vba it...
make VBA put this formula into h2 to last row in H
sort
then delete column H
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Can anyone help on this regards. Look forward for your support.
Further information about my work.
Data is randomly filled in "client sheet".
After the data is filled,
Segregate client type "New" & “Old” to respective sheets.
Alphanumeric “Client code” needs to be in ascending order
Criteria of sorting client code is on the basis of the last set of numbers (after the last“|”)
The code needs to be alphanumeric (as it is even after sorting it)
All the details have to automatically be and go to respective sheet that is "New" & "Old". In new sheet the "client code" has to be listed in ascending order.
In “Old” sheet there is an additional column “Repeated Times”. The unique code should not be repeated in different rows as in “Client Sheet”. Instead the number of times client visited to be indicated in “Repeated Times” column (2 or 3 or 4)
If “Client Type” “Old” is seen only once in the “Client” sheet the number of “Repeated Times” has to be “2” because he/she has already visited the place first time as “New” client. So, 1(new)+1(old)=2
Look forward for you kind support
Please Login or Register to view this content.
i have no idea what you are requesting/trying to do in post #5
this is much more complicated then what you first asked....
Any Experts to solve this problem.
please explain what it doesnt do?
you explained what you did but you did not explain what it did not do
the code works by in 3 sections
1st one is extracting client number into column K and sorting clients sheet by this then sub sort by date by descending order (last date first)
2nd section does the same to OLD sheet
as OLD sheet, it does not add new lines to this sheet
it then does a countif in column J to see how many repeats occur based on client number
then it changes the date based on first line of client in clients sheet
3rd section wipes cells from A2 to k200
this can be increased if required
it then goes back to clients sheet and looks for any NEW clients and copies across the rowPlease Login or Register to view this content.
then finally cleans it up by deleting column K in every sheet
this does all the things you noted on your instructions
No it doesn't work. I can send you one file that was made with the help of an expert from this site.
I want it to be similar like that but with some additional conditions.
Could you pls see that and add additional conditions as I had stated in my previous posts.
Thank you in Advance.
so you had a file of which already has code in it of which you just wanted amended but instead of posting this from the start you decided to post a blank sheet with instructions to replicate what this code already does on sheet
and then you wonder why my code doesnt do the same thing as the sheet you just attached
added to this
you still have not explained what doesn't work?
you keep saying it doesn't work without telling me what doesn't work
did you even run my code or were you expecting it to auto run based on triggered event like the attached sheet?
Dear Sir,
I am not that good on VBA. I am just a beginner. I just want it to be auto filled when I enter data randomly in the first sheet. I was expecting that the sheet you had send would work as the sheet I had attached but it didn't.
I want my file to be like the one attached but as explained I want it to be filled automatically.
But the only changes to be made are as I had described in my previous post.
Thank you.
Dear Sir,
Where and how do in insert the code you had provided?
Look forward for your response.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks