try this
Sub test()
Dim i, j As Long
Dim s As String
j = 1
For i = 3 To Sheets(1).Range("a2").End(xlDown).Row
s = ""
k = i
Sheets(1).Range("h" & j).Value = Sheets(1).Range("a" & i).Value
Do Until Sheets(1).Range("a" & i).Value <> Sheets(1).Range("a" & i +
1).Value
s = s & "-" & Sheets(1).Range("c"
hi please use this simple procedure
Excel Text to Column Command
The Text to Column command allows you to break text in one column into
several columns. For example, if you have LastName, FirstName in a column,
you can break the text into two columns—one containing LastName and the
other containi
Hi Guys,
Pls check attached excel sheet.
I have data in across 2 columns which i want move in one row through macro,
is it possible?
actually the data is extracted from access database so if its poss through
macro then i can process in access rather trolling it through excel.
appreciate your ef