Creating Multiple rows

I would like to create multiple cells from a given data, the code should be able to read the data from a defined cell and split into multiple rows provided certain creteria is met. For instance if the workday is split between two states I would like it to show the name of each of these two states in two rows.

In this instance the client has stayed in two states as he was traveling, I would like to split this into two entries using VB. It should scan the range, identify such instances and create a separate table with multiple values.

Creating Multiple rows

Top Contributor Asked 9 hours ago in VBA.
Add Comment
0 Answer(s)
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.