locked
how to split a row in to 2 or 3 rows depands on the data in the rows RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    hey
    I am looking for a way to split a row base on the data inside some of the cells
    The table contains a invoice and receipt data from a different software that i need to change before i upload it into the bookkeeping software 
    I need to change the data so that each row will be split to 2 rows if there is no VAT and for 3 rows if there is a number (VAT) within the vat cell . 
    Can you please give me a direction where to start ? 

    All of your help will be appreciated 

    Ran

    Friday, July 15, 2016 4:52 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Ran,

    >> I need to change the data so that each row will be split to 2 rows if there is no VAT and for 3 rows if there is a number (VAT) within the vat cell

    What do you mean with each row? Is the data in one cell or different cells in one row? No matter what it is, you could insert a new row, and write the values what you want. Here is a simple code for insert a new row, and write data to it.

    Sub Macro3()
'
' Macro3 Macro
'

'
    Rows("14:14").Select
    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
    ActiveCell.FormulaR1C1 = "Test1"
    Range("A15").Select
    ActiveCell.FormulaR1C1 = "Test2"
    Range("A16").Select
End Sub

    Best Regards,

    Edward

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Monday, July 18, 2016 1:39 AM