Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need advice
Could please anyone help me with problem: I have data row a,b,c,d,e,f,g...... I need to transform it using some functions in Excel to the following row: a,b,c, b,c,d, c,d,e, d,e,f ... etc. Appreciate any advice -- Sergo ------------------------------------------------------------------------ Sergo's Profile: http://www.excelforum.com/member.php...o&userid=31188 View this thread: http://www.excelforum.com/showthread...hreadid=508580 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need advice
You could do something like
Sub ABC() Dim v as Variant, i as Long Dim j as Long, k as Long v = Range("A1:G1").Value k = 1 for i = 1 to ubound(v,2) for j = i to i + 2 cells(1,k).Value = v(1,j) k = k + 1 next j Next i End Sub -- Regards, Tom Ogilvy "Sergo" wrote in message ... Could please anyone help me with problem: I have data row a,b,c,d,e,f,g...... I need to transform it using some functions in Excel to the following row: a,b,c, b,c,d, c,d,e, d,e,f ... etc. Appreciate any advice -- Sergo ------------------------------------------------------------------------ Sergo's Profile: http://www.excelforum.com/member.php...o&userid=31188 View this thread: http://www.excelforum.com/showthread...hreadid=508580 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pls advice | Excel Worksheet Functions | |||
Need advice | Excel Worksheet Functions | |||
Almost got it !! but need advice | Excel Worksheet Functions | |||
In need of advice? | Excel Programming | |||
please advice | Excel Programming |