I need an input box that can extend a monthly timeline into X amount of months that I wish to have extended from any date, (past, present, or future)
Can someone please help guide me in the right...
I need an input box that can extend a monthly timeline into X amount of months that I wish to have extended from any date, (past, present, or future)
Can someone please help guide me in the right...
Last edited by bburrus; 05-14-2013 at 09:08 AM.
For the month indicator
A1 = start monthPlease Login or Register to view this content.
B1 = end month
Using A3 =A1 and D1 as formula above
Please Login or Register to view this content.
Last edited by humdingaling; 04-30-2013 at 08:33 PM. Reason: corrected cell reference
apologies
had wrong cell reference
I've put what the code into the attached file
seems like you have changed your initial request though...so do not know if it is longer valid
you really shouldn't change initial post and requestPlease Login or Register to view this content.
this thread would not make any sense if they were to follow it
Amended Macro to your new request
Hi bburrus
unless its highly private, please request help in the forums instead of PM
How am I able to apply that to different tab within the worksheet. I get what it does but I can't put Start Date and End date in every tab. I have multiple timelines on each tab and they all end end at different dates so I'll have to extend them out on various dates from where they end.
with the above method written macro (not the sample) you do not need to put in start or end date
it works off basis whatever cell (4,1) aka A4 is and your inputbox is how many months it extends
if your multiple sheets all have date on a4 then you can just loop the whole For....Next section and you can cycle through worksheets with
Please Login or Register to view this content.
So from this VBA you gave me:
This has the macro running for A4. I need the macro to run the timeline on any selected cell because my timelines are placed at different dates (rows) and extend to different columns. I want to be able to click on the last date of the timeline and click run macro and put in how many months I want to run the timeline to from the end of the last date.Please Login or Register to view this content.
Last edited by Leith Ross; 05-03-2013 at 03:55 PM. Reason: Added Code Tags
Hi bburrus
so you only want a macro to add "x" amount months to cell you have selected on the current sheet only or on subsequent sheets?
please be very specific
On subsequent sheets. There are timelines on most tabs in my workbook and they are all formatted differently. The timelines start and end on different cells depending on the tab they are located on. I just want to be able to choose any sheet. Go to the last date on that timeline. Enter the amount of months I wish to extend the timeline from the selected cell. and have it extend.
Hello bburrus,
To better understand your problem, it would help if you attach your workbook for review. Please include some before and after examples of what you the macro to do.
To Post Your Workbook
- At the bottom right of the Reply window, Click the button Go Advanced
- At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
- Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
- Click the Select Files button at the bottom middle of the dialog.
- In the new window Find the file you want to upload, select it, and Click Open.
- You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
- Wait until the file has completely uploaded before you exit the File Manager dialog.
File Manger Picture
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
For those following and trying to solve, I posted an example template below. The first tab is just a general layout BUT DOES NOT APPLY TO THE WHOLE WORKBOOK. The second tab is explaining what I am trying to do.
Thanks for your help!
Last edited by bburrus; 05-14-2013 at 09:08 AM.
Based on your example
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks