| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy and Paste in certain format
I have two worksheets -- Lets say ws1, ws2. Data in ws1 looks like column1 data1 data2 data3 Data in ws2 looks like column1 column2 data1 value1 data1 value2 data1 value3 data2 value4 data2 value5 data3 value6 data3 value7 data3 value8 data3 value9 So now I would like to copy all the values in column2 of ws2 corresponding to each data row in ws1 and I would like to take transpose while pasting these in ws1. So, the finished data looks like this below.... Final data in ws1 looks like.. column1 column2 column3 column 4 column 5 data1 value1 value2 value3 data2 value4 value5 data3 value6 value7 value8 value9 I can do this manually by sorting ws2 by first column and copying the rows for same data in column1 and then do paste special and transpose data....but I have to do this for a list that is thousands of rows long.... Any help is very appriciated. Jay -- sa02000 ------------------------------------------------------------------------ sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747 View this thread: http://www.excelforum.com/showthread...hreadid=526157 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Copy / Paste Warning | Excel Discussion (Misc queries) | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| Copy and Paste and keep format the same | Excel Discussion (Misc queries) | |||
Threaded Mode
