| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date depended update of data
Hi ALL I really really hope you can help me out on this one....  What I would like to do, is to copy a cell into another cell, which i listed in a column by date. Workflow would be: 1. Copy cell (X) 2. Find current date in coloumn, where all dates are listed 3. Go one cell to the right - Cell (Y) 4. Incert copied cell (X) 5. Copy cell (Y) 6. Insert VALUE in CELL (Y) Anyone with a datastructure or macro code, that could solve this? Your help is VERY appreciated.... :rolleyes -- Jubelna ----------------------------------------------------------------------- Jubelnar's Profile: http://www.excelforum.com/member.php...fo&userid=1051 View this thread: http://www.excelforum.com/showthread.php?threadid=39211 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date depended update of data
hi,
How will the macro know where cell(x) is? FSt1 "Jubelnar" wrote: Hi ALL I really really hope you can help me out on this one.... What I would like to do, is to copy a cell into another cell, which is listed in a column by date. Workflow would be: 1. Copy cell (X) 2. Find current date in coloumn, where all dates are listed 3. Go one cell to the right - Cell (Y) 4. Incert copied cell (X) 5. Copy cell (Y) 6. Insert VALUE in CELL (Y) Anyone with a datastructure or macro code, that could solve this? Your help is VERY appreciated....  -- Jubelnar ------------------------------------------------------------------------ Jubelnar's Profile: http://www.excelforum.com/member.php...o&userid=10517 View this thread: http://www.excelforum.com/showthread...hreadid=392119 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date depended update of data
It will just be any given cell (ex. A2) Only the copy TO cell will be depended on current date... -- Jubelna ----------------------------------------------------------------------- Jubelnar's Profile: http://www.excelforum.com/member.php...fo&userid=1051 View this thread: http://www.excelforum.com/showthread.php?threadid=39211 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic Data Update by Date Range | Excel Worksheet Functions | |||
| Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
| Update data by chaning date | Excel Worksheet Functions | |||
| how to update data on sheet1 and have it auto update on sheet2 | Excel Programming | |||
| Date update on data update | Excel Programming | |||
![Jubelnar[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
