countinue numbering from the last duplicate number

Hi everyone, thank you so much for reading this post. Any help on this is truly appreciated.

I have a list starting in column H5 and a VBA that counts the duplicate per week up to 5 and restart the count every monday (that someone here helped me with) and the count will be displayed in the column starting from I5. I would like the VBA to be able to continue the last duplicate number

I already have the code(changed from the code I gotten) but it seems to be not working not sure where I went wrong.

I would like it to do something like this:

Previous Week Friday:-

Column H-----Column I (count)
5.Apple-------1
6.Pear -------1
7.Apple ------2


This week Monday after restarting the numbering:-

Column H-----Column I (count)
8.Apple-------1
9.Pear -------1
10.Apple -----2

This week tuesday
11. Apple-----3
12. Apple-----4


Right now the coding I have instead of continue the counting in tuesday like the above(like what I wanted it to do). Right now it just starts to renumbering it back to 1
Below is the code:

Please Login or Register  to view this content.

Please help me . Thank you so much.Disclaimer:I have post in another forum hoping to get an answer https://www.mrexcel.com/forum/excel-...mbering-4.html I'm so sorry should have read the rules first .

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Hi,

The paperclip attach icon isn't working. To upload a workbook choose the Go Advanced Button and underneath the post area pick the Manage Attachments and take it from there.

Were you aware that the last used row is rge very bottom, 1048576. which makes the file. 5 Mb. you need to delete all the rows after your last data item and then save the workbook.

Why are the weekday in column M not in order? Any solution will be simplified if that is the case.

But this is clearly a much simplified example and probably doesn't contain all relevant data (like dates) or represent the size/format of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

Your Invoice and Due Date columns say they are irrelevant. If you're looking to reset a counter each week surely dates are relevant, your current column M must be based on knowing the date and I'd suggest it's that which is probably irrelevant.

As I say upload the real workbook and no doubt we can help further.

Perhab

Please Login or Register  to view this content.

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

No further help to be offered, please, until the OP has complied with this request.

Still not sure what you want perhab

Please Login or Register  to view this content.

Thank you so much @daboho for the reply .I hope the below
would explain it in detail for you to understand. again my gratitude for helping me out

I don't think we've yet seen the file uploaded in this forum - see post #4

You may get more of a response if it is. Pictures alone are rarely much use.