VBA To Split cell values and put it into the row below

[svkroy]

Hi,

I am in a fix. I have this data.

Column 1 Column 2
xyz 1234.76 (18.98)
xyz 6321.76/(9765.34)
xyz 85.76 765
xyz 785
xyz (234)

The logic being if values in Col 1 has "xyz" then insert a blank row below and split the corresponding second values of Col 2 in the row just beneath that, also fill "xyz" in blank Col 1 cells. If it has only one value keep the next row blank. The output is as below:

Column 1 Column 2
xyz 1234.76
xyz (18.98)
xyz 6321.76
xyz (9765.34)
xyz 85.76
xyz 765.00
xyz 785.00
xyz
xyz (234)
xyz

Any help, ideas. Thanks in advance.

 

[hiker95]

svkroy,

Thanks for the feedback.

You are very welcome. Glad we could help.

And, come back anytime.

 

[svkroy]

That was very nice of you guys, in hindsight any suggested readings/books on vba ?

 

[hiker95]

svkroy,

any suggested readings/books on vba ?

See the below link:

Training / Books / Sites as of 10/15/2013
http://www.mrexcel.com/forum/genera...-visual-basic-applications-2.html#post3604871

 

[dita87]

Hello everyone,
I have an issue figuring out how to split the rows based on data in a column. Practically this is how it looks like:

Every day to be separated by the corresponding number in cell 3. If day 1 has a 6,to be repeated 6 times and the rest of the numbers to move further.
I do not know if this is possible,but I have to do it for 365 days and it is quite a lot.
If you can help me, I will truly appreciate it
Thank you a lot in advance

 

[hiker95]

dita87,

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


To start off, and, so that we can get it right on the first try:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot try one of the following:

Excel Jeanie
Download

MrExcel HTML Maker
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here


Or, you can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[dita87]

Hello hiker95,

Thank you very much for answering.

1) I am using Excel Mac 2011 version: 14.4.7
2) I do use MacbookPro

Here is a link of the excel problem
https://drive.google.com/file/d/0B5TnUKwRO9fQR2RMLUpNV1NwamM/view?usp=sharing

Thank you again

 

[hiker95]

dita87,

1) I am using Excel Mac 2011 version: 14.4.7
2) I do use MacbookPro

I have no experience with either of the above.

You may want to try changing/adding to the your thread title: VBA To Split cell values and put it into the row below, on a Mac

This will help you find someone with Mac experience.


And, when I click on your link, my PC Security Package WEBROOT SecureAnwhere is reporting This website has been reported as unsafe.


Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.