| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Creation
I am trying to create a macro that will do the following
Create a new colum Label the new column with today's day (Mon) in cell C1 Label the same column with today's date (05/17/04) in cell C2 Copy and paste what is in column A3:A50 & B3:B50 into C3:C50 & D3:D50 Copy and paste values what is cells A3:A50 & B3:B50 into those same cells The problem I am running into is Each time I run this macro I don't want it to overwrite the old data. For the next time I ran the macro I would want the new information posted to cells E3:E50 & F3:F50 I appreciate the help Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro creation | Excel Worksheet Functions | |||
| Macro creation | Excel Worksheet Functions | |||
| Creation of macro with an example | Excel Discussion (Misc queries) | |||
| Creation of a Generic Macro | Excel Worksheet Functions | |||
| Macro Creation | Excel Discussion (Misc queries) | |||
Threaded Mode
