Okay - Get this I'm the smart one at work! and this forum makes me feel like one of them! i'm really not good at explaining things!
please keep in mind that this example pending form is out dated and old! it does not reflect anything current! but i would of done this action (described below) going into the month of July!
Here is a link of what i have!
http://s376.photobucket.com/albums/o...ng-example.jpg
every month i have to advance to a new month!
so every month i have to go to each sellers computer and do this manually!
Here is what i do!
step 1. cut columns BCD
step 2. paste the BCD columns them between J and K...
step 3. change the dates in row 3 on the newly pasted columns
step 4. delete all info under newly pasted columns from 4-99
so we end up with something looking like.
http://s376.photobucket.com/albums/o...rent=thing.jpg
With me doing this monthly on over 11 different pc's It's more simple to teach Control M then it is to copy and paste and change some text...
my biggest issues is the date! I can get the macro to copy the columns but when it puts in the month it puts in WHAT I TYPED instead of 2 months out from the starting month!
Goodness i'm confusing myself!
it's really not rocket science! i always want this form to be looking out 3 months ahead! what ever month it is current should be the month to the left then the last one should be 2 months from that month!
Help??? worksheet attached
Bookmarks