This is the macro I'm after.
Populating information to column s
Few things before I start. I'm not very good with codes but I will try to do my best to get the point across. I Sincerely hope that someone can help me especially after spending 2 days to create this following post.
To understand me bit better
Let me explain of my vocabulary and what I mean by saying certain things. Whenever I say populates to I mean to col S respective row and when I talk about columns I also mean cells of the respective rows. Its just to make the reading bit shorter. Row 1 should always be excluded from the macro calculation as its a header row. The terms "blank" and "is not blank". By blank I mean there is no info in the columns respective row and cell, By "is not blank" I mean it contains either date, or writing or some other info.
What I refer to as carry on with the main code, I mean that go to the next step in the main code.
What I refer to as valid dates. Easiest way for me is to clarify this is what are not valid dates
01//01/1900 - we sometimes get this date in spreadsheets
blank
#N/A
Rest of the dates are all valid dates.
What I refer as normal date rules
The new dates generated from col V depend mainly what week day that date in col V happens to be. Its important because if we will get the goods Monday it will take us 3 days to deliver. If its Wednesday it will take us 5 days to deliver. Lets call this as normal date rules. Here is the breakdown of how the dates are calculated. IF cell in col V is:
normal date rules
Monday then +3 days (effectively current weeks Thursday)
Tuesday then + 3 days (effectively the date of current weeks Friday)
Wednesday then +5 days (effectively the date of next weeks Monday)
Thursday then +5 days (effectively the date of next weeks Tuesday)
Friday then +4 days (effectively the date of next weeks Tuesday)
Sat then +3 days (effectively the date of next weeks Tuesday)
Sun then +3 days (effectively the date of next weeks Wednesday)
I have left the first 7 dates in Col V from row 2 to row 8 are from Monday to Friday for a testing purposes.
As explained before I don't know much about coding, how they run, and in which order they should be but this here is sort of a main rule or formula. In plain words this is how I imagine
CONTINUES IN NEXT POST. had to split up because of the characters limitation in posts. Didnt know how to make it any shorter to still get the point across.
Bookmarks