![]() |
#4
|
||||
|
||||
![]()
Then try with this macro:
Code:
Option Explicit Sub test() Dim i As Long Dim x As Long Dim col As Long i = 2 col = Cells(1, Cells.Columns.Count).End(xlToLeft).Column 'use if there is no data after the last used column in row 1 'col = Cells(1, 1).End(xlToRight).Column 'use if there are no empty columns before the last used in row 1 Do Until Cells(i, 1) = "" For x = 1 To col Cells(i, col * 2 - x + 1) = Cells(i, x) + 1 Next x i = i + 1 Loop End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
auto fill up | mare1984 | Word | 1 | 06-27-2019 08:09 PM |
![]() |
pgilbert0824 | Excel | 2 | 10-30-2016 01:02 AM |
![]() |
officeboy09 | Excel | 8 | 01-14-2014 05:52 PM |
auto fill a word doc from another program | hcubed | Office | 0 | 06-19-2013 09:42 PM |
![]() |
Kinar | Excel | 3 | 05-14-2013 07:46 AM |