| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code Required to Get Data Which is In Coloums Into Rows
Dear All, I could really really do with some code which would allow me to get m data from rows into columns by this i mean i have my data in the form id_no picture_of 1 cat 1 dog 1 horse and i would like in id_no picture1 picture2 picture3 1 cat dog horse does anyone have the code for this - if so please i would be extremel extremely grateful. st -- stublai ----------------------------------------------------------------------- stublair's Profile: http://www.excelforum.com/member.php...fo&userid=1870 View this thread: http://www.excelforum.com/showthread.php?threadid=49412 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Code Required to Get Data Which is In Coloums Into Rows
Try this:
Sub test() Range(Cells(1), Cells(4, 2)).Copy Cells(4).PasteSpecial Paste:=xlPasteAll, _ Operation:=xlNone, _ SkipBlanks:=False, _ Transpose:=True Application.CutCopyMode = False End Sub RBS "stublair" wrote in message ... Dear All, I could really really do with some code which would allow me to get my data from rows into columns by this i mean i have my data in the form id_no picture_of 1 cat 1 dog 1 horse and i would like in id_no picture1 picture2 picture3 1 cat dog horse does anyone have the code for this - if so please i would be extremely extremely grateful. stu -- stublair ------------------------------------------------------------------------ stublair's Profile: http://www.excelforum.com/member.php...o&userid=18702 View this thread: http://www.excelforum.com/showthread...hreadid=494127 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Code Required to Get Data Which is In Coloums Into Rows
Sub test()
Range("C1:K1") = Application.Transpose(Range("A1:A10")) End Sub -- HTH Bob Phillips (remove nothere from email address if mailing direct) "stublair" wrote in message ... Dear All, I could really really do with some code which would allow me to get my data from rows into columns by this i mean i have my data in the form id_no picture_of 1 cat 1 dog 1 horse and i would like in id_no picture1 picture2 picture3 1 cat dog horse does anyone have the code for this - if so please i would be extremely extremely grateful. stu -- stublair ------------------------------------------------------------------------ stublair's Profile: http://www.excelforum.com/member.php...o&userid=18702 View this thread: http://www.excelforum.com/showthread...hreadid=494127 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another VB Code Required | Excel Discussion (Misc queries) | |||
| VB Code Required | Excel Discussion (Misc queries) | |||
| how to delete repeated character in the coloums or rows | Excel Discussion (Misc queries) | |||
| Code required please | Excel Programming | |||
| For....Next loop code required | Excel Programming | |||
Linear Mode
