| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy & Paste
Hi all
I am looking for a vba solution for copy&paste or something else to join 3 sheets to one sheet like this sample: sheet1: sheet2: sheet3: ___date_______amount1 ___date_______amount2 __date_______amount3 1 2006/01/01 11111.00 1 2001/01/01 44444.00 1 2002/01/01 77777.00 2 2002/01/01 22222.00 2 2003/01/01 55555.00 2 2004/01/01 88888.00 3 2005/01/01 44444.00 3 2005/01/01 55555.00 3 2001/01/01 77777.00 Target sheet ___date_______amount1_____amount2_______amount3 1 2006/01/01 11111.00 2 2002/01/01 22222.00 3 2005/01/01 44444.00 4 2001/01/01 44444.00 5 2003/01/01 55555.00 6 2005/01/01 55555.00 7 2002/01/01 77777.00 8 2004/01/01 88888.00 9 2001/01/01 77777.00 Thanks in advance Bijan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Automating copy/paste/paste special when row references change | Excel Programming | |||
| help w/ generic copy & paste/paste special routine | Excel Programming | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
Threaded Mode
