| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming - copying and arranging selective data ...pls help....i know u can...
i am a normal staff working in a office....i need you guys help i this...really...please..... there are 2 worksheets (worksheet A and worksheet B). worksheet A: cell E1 = A cell E2 = A cell E3 = B worksheet B: cell A1:C1 = A, apple, peach cell A2:C2 = B, monkey, elephant my problem is... can I combine these 2 worksheet in this way:- If any cell in (worksheet B eg. A1) = (cell E1 & cell E2, worksheet A copy row A1:C1 worksheet B) and paste to cell F1 & F2 (worksheet A). In verbal, i need a formula, or programming text which can help me t copy data from worksheet B and paste next to the same cell in workshee A. I hope you guys can understand what I am trying to say... :) coz I m dealing with 4 thousands of cells which I need to copy an paste in these ways...so plzz.....help me.....my eyes hurt after doin that.... many many thanks in advance..... -- kaichie ----------------------------------------------------------------------- kaichiew's Profile: http://www.excelforum.com/member.php...fo&userid=1601 View this thread: http://www.excelforum.com/showthread.php?threadid=27479 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Selective Data Between Worksheets | New Users to Excel | |||
| Copying selective data | Excel Discussion (Misc queries) | |||
| re-arranging the data | Excel Discussion (Misc queries) | |||
| Arranging Excel Data | Excel Discussion (Misc queries) | |||
| Re-Arranging a Block of Data | Excel Programming | |||
Linear Mode
