Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Have Column "J" in this way when days are pass due and fix load time when using Number Arrange Button.

Posted on 2016-10-07
11
Medium Priority
?
48 Views
Last Modified: 2016-10-07
Good morning Experts Exchange Community, trying to have this two function fixed.

***Considering today date if the following date are shown on the "B" column i would like it to appear on the "J" column the following.
(PASS DUE -3) if on column "B" date is 10/2/16.
(PASS DUE -2) if on column "B" date is 10/3/16.
(PASS DUE -1) If on column "B" date is 10/4/16.

so if it is                                  (TODAY)         Column "B" 10/5/16
tomorrow would be        (PASS DUE -1)    Column "B" 10/5/16
Day after that would be (PASS DUE -2)    Column "B" 10/5/16
Day after that would be (PASS DUE -3)    Column "B" 10/5/16"

***Fix load time when i am trying to use the (ARRANGE NUMBER) Button it takes 30 sec to 1 min to load. Wan't it to be fix. Thanks again guys for your time and your help.
28974603b.xlsm
0
Comment
Question by:Omar Hernandez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41833946
Give this a try. Note that I used PAST DUE rather than PASS DUE, but that's easy to change if you want to.
28975047.xlsm
0
 
LVL 49

Accepted Solution

by:
Martin Liss earned 2000 total points
ID: 41833957
Please use this version instead.
28975047a.xlsm
0
 

Author Comment

by:Omar Hernandez
ID: 41833963
Thanks a ton, the past due part is working great and thanks and appreciate your input about pass due to past due. Have you checked out the (ARRANGE NUMBER) Button load time.

***Click on a cell that has a task then click on (ARRANGE NUMBER) Button and then just click the close button located on the pop up box, right bottom button.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 49

Expert Comment

by:Martin Liss
ID: 41833975
Yes, I just did it now and it brings up a question I asked before that you didn't answer, and that is when rows are hidden by clicking a button like Arrange Number, it there a button I can click to unhide them?

Also I noticed that when you change or add a date in column B that that date can be before the date in column A and I assume that that shouldn't be allowed. Given the complex code for the calendar I think it would be difficult to add code to prevent that but I could at least show a message when it happens. If you'd like me to do that then please ask a new question.
0
 

Author Comment

by:Omar Hernandez
ID: 41834170
***When click on (NUMBER ARRANGE) button, what ever updates being made will only be implemented to those task that has the same word on the "E" column. There will be no need to un-hide others because the anytime when it is being update by using (NUMBER ARRANGE) button it will only and should only be looking for those that have the same words on the "E" column

***Column A is always ignore that is there only for me to see when i have created that task.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41834267
Here is a "before" picture.
BeforeAnd here's what I see after I select cell E12, press the NUMBER ARRANGE button and click "Close".
After
That doesn't seem to agree with what you said.
0
 

Author Comment

by:Omar Hernandez
ID: 41834313
It seems like both of us are getting two different result... Let me show you what i am getting Please refer to the following link.

https://www.youtube.com/watch?v=sXNkQPr12t8&feature=youtu.be

Or

Copy and paste these words on the search bar that is on the Youtube Page.
When clicking on the Number Arrange loads for a min or so
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41834358
Before we go on, please close this question if my change that shows PAST DUE is working.

I don't get the results that you do in your recent video and I believe the culprit is the FindAndPlaceValuesInColumnC sub that is called at the end of the code for the "Close" button on the NumberArrange form. First of all (and I may be wrong) the code doesn't have anything to do with column C. Secondly it doesn't seem to look at column E at all, but rather column 7 (G) and J. It replaces what's in J and that's why you get errors in that column. So I don't know why we get different results unless our workbooks are different.

If you want me to work on this problem please ask a new question.
0
 

Author Closing Comment

by:Omar Hernandez
ID: 41834366
Thanks for solving this problems once again appreciate your help and time.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41834370
You're welcome. I found what I believe is a solution for the end date before start date problem so we could work on that next if you like.
0
 

Author Comment

by:Omar Hernandez
ID: 41834373
sure, i have updated the new question copy and paste the following on this page search bar and thanks again.

Trying to fix NUMBER ARRANGE Button to load faster and more efficiently
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question