| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Idea
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 | |||
| Help!! No idea where to go next... | Excel Discussion (Misc queries) | |||
| I've no idea how to do this. :( | Excel Worksheet Functions | |||
| any idea? | Links and Linking in Excel | |||
| any idea?? | Excel Worksheet Functions | |||
| Help Please. No Idea what to look for or how to do this | Excel Discussion (Misc queries) | |||
Threaded Mode
