| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Values Between Worksheets in same Workbook
Please help me create a macro that will have the source Worksheet as Sheet1 and the destination worksheet as discount that corresponds to the data listed below. Each row from Sheet1 corresponds to two rows in Discount worksheet. Every row that corresponds to Cost column (E) has a Cost Code = 0007346 and Discount column (K) has a Discount Code = 0007346 and this value place in the Column G of the Discount worksheet. The Sheet1 usually has 60 days of data. Thanks, Category Cost Code = 0007234 Discount Code = 0007346 Worksheet(Sheet1) Date(B06) Cost(E06) Discount(K06) 01/01/2003 5.67 1.32 01/02/2003 15.24 3.34 01/03/2003 12.13 2.09 .... 03/01/2003 8.48 1.68 Worksheet(Discount) Col(C) Date Col(F) Cost Col(G) Category 01/01/2003 5.67 0007234 01/01/2003 1.32 0007346 01/02/2003 15.24 0007234 01/02/2003 3.34 0007346 01/03/2003 12.13 0007234 01/03/2003 2.09 0007346 .... 03/01/2003 8.48 0007234 03/01/2003 1.68 0007346 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy worksheets within a workbook | Excel Discussion (Misc queries) | |||
| how to copy only values and formats of worksheets to new workbook | Excel Worksheet Functions | |||
| copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
| Copy four worksheets from one workbook into a new workbook.e-mail | Excel Programming | |||
| How do I sum values from different worksheets within one workbook. | Excel Worksheet Functions | |||
Threaded Mode
