Shifting Cells then Optimizing

**rybuns** · 07-27-2010, 02:50 PM

Two part question here. First one should be easy but the second could give trouble. I've scoured Google, and found similar solutions but I'm missing some key element. Here's what I'm looking to do:

I’m trying to have a portion of a row of cells (between 2 and 4 cells long) shift left or right according to the date that is entered to the far left. For example, if 01/01/10 is entered, the macro would shift the cells of that row so they begin at January while keeping them adjacent to one another.

Nextly, below that I would like to excel to chose the date automatically based on an optimization that would minimize monthly sums. In the attached file, I'd only need the optimization on the top section (Remaining Capital), since the bottom section does not have the same practical flexibility.

In conclusion, the first question should be a breeze, I just wish I knew or had the time to better learn vba programming. The second question might be out of the scope of this forum. I appreciate any help that can be lent.

Ryan

**Leith Ross** · 07-27-2010, 03:54 PM

Hello rybuns,

Please only ask one question per post. Your data is incomplete as there is no January on the worksheet. We can not help you when you do not supply the needed information. Review your question and be sure the workbook follows with what you are posting.

**rybuns** · 07-27-2010, 05:09 PM

Please excuse me for squeezing in a two-part question. They are very much the same issue, but I will make sure to post the second half in a new thread. You will, however, find that January is indeed in the worksheet posted. The months start at July and go until May, excluding June which is extraneous to my needs.