Macro needed to extract two rows from one row

[Andy booth]

Hi,

I have generated a row of calculated data and from that I want to split the data out into two other rows.

Calculated data is displayed:

aaa bbb cccc date figure 1 figure 2 xxxx yyyy

I want to split it out like this

aaa cccc date figure 1 xxxx
bbb cccc date figure 2 yyyy

This will happen multiple times as there could be up to 30 rows of original calculated data, which will end up extracted to 60 rows.

Is there a possible macro that can do this? I have tried building a macro for this and I can loop it down so it picks up the calculated data and extracts the first row needed, however, I cant get it to extract the second row successfully as the range changes as the loop proceeds.

Can anyone assist me with this?

Thanks
Andy

 

[hiker95]

Andy booth,

We can not tell what cells, rows, columns, your raw data is in. And, we can not tell what cells, rows, columns, your results are in.

What version of Excel are you using?

Can you post a screenshot of the raw data worksheet, and, post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker
Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.

If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data scrubbed/removed/changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[Andy booth]

Hi,

I got a bit confused with the threads yesterday and had to repost my question under the thread "VBA macro to extract data from one row to two rows".

This explains what I need in greater detail.

Thanks