Date depended update of data

J

Jubelnar

Hi ALL
I really really hope you can help me out on this one.... :confused:

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
 
J

Jubelnar

It will just be any given cell (ex. A2)

Only the copy TO cell will be depended on current date...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Filter 4
conditional if statement and macro 6
Cell Address References won't update when Sorting 2
Moving a bunch of data 1
Date as filename 4
macro to date stamp to the right of the macro command button 4
5 months prior to date macro help please 13
Excel Data pastes into 2 cells not 1 1

Top