Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Select the data, do edit =Copy, select another location, do Edit=Paste
Special and select the Transpose box at the bottom of the dialog. -- Regards, Tom Ogilvy "yaoming " wrote in message ... well imagine a sheet is like this all filled: 1234 4567 8910 So, i want a macro with data that is already on the sheet to switch spots, or positions to this. 148 259 361 470 Is this possible. But for now, i just want to find out a way to copy and paste the cells. Formulas are not important. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy / paste as values | New Users to Excel | |||
Need help with macro to copy, paste, and clear cell values | Excel Discussion (Misc queries) | |||
Copy and paste up to values in last row | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
copy / paste values for certain range | Excel Programming |