Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to copy multiple cells into one cell
This site helps me a lot during my intership. Thanks for everyone post here. I got a problem now, quite complicated.
I have two workbooks and I am copying data from LP to MS. In LP the data is arraged like this: dates product u97 u95 mt no (six columns, seperate by space) 01/08 quantity 80 90 08/08 quantity 89 09/01 quantity 87 The format in the destination is like: dates product (two columns) 01/08 u97 = 80 mt=90 (in one cell, not merge) 08/08 u95 = 89 09/01 no = 87 Can anyone help me write a macro to run this? I really appreciate your help! Thanks a lot a lot!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy multiple cells to one cell | Excel Discussion (Misc queries) | |||
How to Copy single Cell into Multiple cells | Excel Worksheet Functions | |||
macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
How to copy multiple cells between worksheets | Excel Discussion (Misc queries) | |||
List box, copy multiple Cells | Excel Worksheet Functions |