#Excel split cells into two rows how to

so you can try to download it and use it 60 days for free. which means you need to purchase this Addin. Then you can follow the instruction mentioned in that link to split the data. This Tab is not a by default tab that provided by MS Excel.Д«elow is the link from where you can download it. It means if you want to use that functionality provided by that Addin then you have to install that Addin first. What you had find is a Third Party Addin for Excel.

#Excel split cells into two rows how to

How to split data into multiple worksheets based on column in Excel? So I think that you visited the link mentioned below.

Still on the Developer tab of the ribbon, click Macros.ДЇrom the description of thread I understand that you are talking about 'Enterprise' Tab.

Change the two constants at the beginning of the code as needed - lngNameCol is the number of the NAME column and lngFirstRow is the first row with data *excluding the header row).

WshSource.Rows(lngRow).Copy Destination:=wshTarget.Cells(lngTargetRow, 1) WshSource.Rows(lngFirstRow - 1).Copy Destination:=wshTarget.Cells(1, 1) WshTarget.Name = wshSource.Cells(lngRow, lngNameCol).Value Set wshTarget = Worksheets.Add(After:=Worksheets(Worksheets.Count)) If wshSource.Cells(lngRow, lngNameCol).Value wshSource.Cells(lngRow - 1, lngNameCol).Value Then LngLastRow = wshSource.Cells(, lngNameCol).End(xlUp).Row

Copy the following code into the code module that appears:Д¬onst lngNameCol = 2 ' names in second column (B)Д¬onst lngFirstRow = 2 ' data start in row 2.

Activate the Developer tab of the ribbon.In the list of 'Main Tabs' on the right, tick the check box labeled Developer.Select 'Customize Ribbon' in the navigation pane on the left.