Creating a function to select and copy data automatically

%3CLINGO-SUB%20id%3D%22lingo-sub-2198340%22%20slang%3D%22en-US%22%3ECreating%20a%20function%20to%20select%20and%20copy%20data%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2198340%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIf%20the%20output%20file%20has%20the%20following%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EColumn%20A%3D%20time%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EColumn%20B%20%3D%20BP%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EColumn%20C%20%3D%20TCD%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EColumn%20D%20%3D%20marks%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EFor%2099%25%20of%20the%20rows%2C%20%E2%80%9Cmarks%E2%80%9D%20has%20no%20data%20(or%20a%20dash%20or%20some%20form%20of%20place%20holder.%26nbsp%3B%20Then%20it%20indicates%20%E2%80%9Cstart%E2%80%9D%20and%20later%20on%20it%20indicates%20%E2%80%9Cstop%E2%80%9D.%20Is%20there%20any%20way%20to%20use%20the%20%22IF%20command%22%20to%20make%20excel%20copy%20data%20from%20columns%20B%20and%20C%20into%20column%20E%20and%20F%2C%20from%20the%20start%20point%20to%20the%20stop%20point%3F%20Or%2C%20what%20would%20be%20the%20best%20approach%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2198340%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2198911%22%20slang%3D%22de-DE%22%3ESubject%3A%20Creating%20a%20function%20to%20select%20and%20copy%20data%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2198911%22%20slang%3D%22de-DE%22%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20a%20file%20(without%20sensitive%20data)%20to%20your%20project.%3CBR%20%2F%3EExplain%20your%20plans%20in%20relation%20to%20this%20file.%20So%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3CBR%20%2F%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3CBR%20%2F%3EA%20win-win%20situation%20for%20everyone.%3CBR%20%2F%3EPlease%20no%20Picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20also%20be%20an%20advantage.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20and%20patience%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Occasional Visitor

If the output file has the following:
Column A= time
Column B = BP
Column C = TCD
Column D = marks

For 99% of the rows, “marks” has no data (or a dash or some form of place holder.  Then it indicates “start” and later on it indicates “stop”. Is there any way to use the "IF command" to make excel copy data from columns B and C into column E and F, from the start point to the stop point? Or, what would be the best approach?

1 Reply
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

* Knowing the Excel version and operating system would also be an advantage.

Thank you for your understanding and patience

Nikolino
I know I don't know anything (Socrates)