Hi Raghu,
Most things seem very simple when you are familiar – A good friend of mine I had to help a lot in the school and still do in further life as he is very slow at understanding the simplest things. But he was very motivated and now is a very successful pilot flying the largest passenger machines – he is very familiar with flying machines and all that goes with it, but that’s about all he can do, Lol..( Even amongst his colleagues he is still known as a bit of an idiot ( but a confident Pilot I might add )
I have a large File used daily by my wife for her necessary diets. I find it so simple that it bores me to try to explain it to her. But this winter I have been trying for days to explain it to her so that she takes over it all herself.. but after days she still understands very little… I expect I will give up and try again next Winter, Lol…
I am not a professional programmer, but some I know tell me that the most difficult thing they ever have to do is understand someone else’s code. So once again , it is very good that you have persevered and got your own solution. I personally would always use a more complicated code that I undrsatand rather than a “seemingly” simpler which I do not understand. My goal is always to have a clever/ simple code which I also understand. Only sometimes I manage that, lol..
For two years I have been learning VBA programming now and I am continually surprised how many very experienced programmers use some very elegant codes which they do not understand. I find that quite worrying.. Much of the coding controlling our lives is understood by nobody. I can’t help thinking that will lead to a catastrophe one day….
_.___________-
Thanks for the further explanation.
I see now that the start point, as far as the code discussions in this thread are concerned is the running of the final code from your other Thread, http://www.excelfox.com/forum/showth...them#post10543 . That is perhaps obvious with hindsight , but it wasn’t initially.
So, just for future reference…
From Zip Foldere, “WorkDistributed 15MAR18”
running the macro which I used from the following site and you helped modify.
https://stackoverflow.com/questions/...-a-column?rq=1
The above macro also populates the column F.
“WorkDistributed 15MAR18”
“Work Distribution”
All Files there are the “Afters”
File “zMaster.xlsm” would be the “Before” if the dates were removed from column F
So this was your after
Row\Col
Worksheet: OriginalData
Row\Col
If I delete the dates in column F then I get the before:
Worksheet: OriginalData
Row\Col Raghu John Greg Margaret
If in the before I run the code Sub ExportByName on the before then I get
_ the after ( but with today’s data )
Worksheet: OriginalData
Row\Col 02.Apr.2018 02.Apr.2018 02.Apr.2018
¬_ In addition to the above change to the master file I get the 4 data files , Raghu , John , Greg, Margaret.
For example “Raghu.xlsx”
Worksheet: Tabelle1
Row\Col 02.Apr.2018 Raghu 02.Apr.2018 Raghu 02.Apr.2018 Raghu
This is the same as the File from Zip File, “WorkDistributed 15MAR18” you gave , but just the date, as expected is different.
Worksheet: FromRaghu
Row\Col ABC01 Raghu ABC05 Raghu ABC09 Raghu
So that is the situation finished with the “Work Distribution”
Reply With Quote
Bookmarks