I have an Excel spreadsheet that has a single column A. The column looks something like the attached example Excel spreadsheet where the column has <relation> and several lines below that there is an end point titled </relation>. I need the data to include <relation> and </relation> and everything between those points to be grouped into a single row for every instance where this happens. The Excel column has other data that needs to be ignored if it is not between <relation> and </relation>.
In the attached Excel spreadsheet I highlighted the items in red that would have to be ignored by the Macro. I also highlighted the items in green where the <relation> begins. Starting in column C in the example Excel worksheet you can see how I would like the data to look like when they are made into multiple rows. You can use this example spreadsheet for testing that your macro works.
I need the macro to search for the key word <relation> and </relation> for start and stop end points when creating a new row. I want the macro to use these key words because I will later edit the macro to search for other key words like <test> and </test> and have the data between these two key words create new rows for me.
I searched online for a Macro do to this but the closest items that come somewhat close to what I need are listed below.
[login to view URL]
[login to view URL]
I can definitely do that, and i've done many similar projects before without a single problem. As always if you are interested feel free to message me and i will code this for you immediately. Thanks, Milan
18 freelancers are bidding on average $19 for this job
Hello there, I am an Excel expert and I can create 1 script to do it for you. With 1 button to generate data you need. I can do it for you in 10 mins. Please contact me and I will start working on time. Thank you.
soy actuario con mas de 25 años de experiencia como consultor independiente utilizando VBA excel en mis proyectos. Ya hice el macro y estoy a su orden para enviarlo