Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello everyone,
Im new to the list and havent done any programming in a while, but am working on a spreadsheet for a customer and need help with something i think is relatively simple (I just can't get it) I have data in a set of 11 rows, which could be of varying quantites.. but always 11 rows... row1-11 ... text of various sorts row12-22... text in same pattern as above.. what i need is a loop that will select the first 11 rows, and transpose and paste into another sheet, and then select the next 11 rows and do the same, and continue on until all data has been picked up. Thanks in advance to anyone who can help. Let me know if it needs clarification Rgds Sach |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
3 Different Data Sets | Charts and Charting in Excel | |||
need a formula to transpose sets of data from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
how do i link up 2 sets of data into 1 set of data in excel | Excel Worksheet Functions |