Macro to copy, paste values, and remove blanks

[Guido]

I need a macro that will take the values that are in the far right cells and move them to an area on the left. the columns they will be pulling from are the IU & IV column starting with row 2 down to row 460. from there I need the values to be pasted into the D & E Columns starting at row 6. The two columns IU & IV are a date and a task for that date. When they are pasted into the columns D&E they will need to be sorted by dates (or just all of the blanks removed), with the soonest occurrence at the top. The reason for pasting values is because I have formulas pulling the tasks and dates off of another sheet. The last thing is that the macro needs to be triggered by the information in cell c2, when that cell is changed the formulas go to work and everything in cells IU & IV update. That is when I would like the macro to kick in and work the miracle.

I have been trying to build a colony of formulas that could do it, but I have given up, then I tried to make an array index it for me, but that wasn't working for me either. I am seriously lacking in my excel skills. Please HELP! Thank you.

 

[xenou]

See this thread on forcing calculation:
http://www.mrexcel.com/board2/viewtopic.php?t=284461&highlight=

Glad you got things working.

Edit: Note that this involves using a worksheet_calculate event rather than a worksheet_change event, and using Now() somewhere on the sheet to force recalculations when a new value is selected in the combo box.