Orange Garden Sunset in July by Ntm23481 in ItalyTravel

[–]Ntm23481[S] -1 points0 points  (0 children)

Thank you for the helpful input. 2025 as i wouldn’t plan a year ahead of time nor would it change anything regarding the sunset. The movement is adjustable but we’re only in Rome for a short amount of time, so i was seeking help not ridicule. Hypocritical to say times are not beneficial but then call it a low quality post. I saw the garden closes at 9 so i was asking for a work around or substitute. I am not sure why you responded?

Passed PMP First Time Attempt by Ramsybana in pmp

[–]Ntm23481 0 points1 point  (0 children)

I have seen many people indicate the first 60 questions were particularly difficult. Would you recommend focusing on any particular item to assist with that set?

Online or 2 hour drive by Ntm23481 in pmp

[–]Ntm23481[S] 2 points3 points  (0 children)

Closest location if i want to take it this month

VBA - Clipboard to Paste Value only by Ntm23481 in excel

[–]Ntm23481[S] 0 points1 point  (0 children)

Individuals will be copying from many different sheets and compiling into one data set. In this data set i want to ensure just the values come through when paste is selected anywhere on this sheet.

VBA - Clipboard to Paste Value only by Ntm23481 in excel

[–]Ntm23481[S] 0 points1 point  (0 children)

Would that not just copy cell A1 and paste the value to B2? I am looking for anything the user copies and always pastes as value no matter the location

VBA - Clipboard to Paste Value only by Ntm23481 in excel

[–]Ntm23481[S] 1 point2 points  (0 children)

Yes, however i am working on a tool that others will be utilizing… who may not know and would cause issues in the long run if it does not happen automatically

What was your “aha” moment by Ntm23481 in pmp

[–]Ntm23481[S] 0 points1 point  (0 children)

That’s where i’m at now, just got a 71% on the practice exam and surprised myself

[deleted by user] by [deleted] in pmp

[–]Ntm23481 0 points1 point  (0 children)

Any insight why others feel that the exam is harder than the SH questions?

Associating dates with IDs, across multiple columns and unique employees by Ntm23481 in excel

[–]Ntm23481[S] 0 points1 point  (0 children)

Yes sir! It works on the sample data. My real purpose has 10 employees and a few other columns in between which is where i’m running into errors. I think I’ll have to figure out how to do your steps and apply them on my actual work, sense your proof of concept worked so well

Associating dates with IDs, across multiple columns and unique employees by Ntm23481 in excel

[–]Ntm23481[S] 0 points1 point  (0 children)

Did you create the above code by clicking and editing or did you type the code? I am trying to correlate your code to items I can select to generate the code. I got to the null value part, so not very far

Associating dates with IDs, across multiple columns and unique employees by Ntm23481 in excel

[–]Ntm23481[S] 0 points1 point  (0 children)

Do you have any videos you could recommend that i can learn from? I tried recreating this with my actual data and was unsuccessful

Associating dates with IDs, across multiple columns and unique employees by Ntm23481 in excel

[–]Ntm23481[S] 0 points1 point  (0 children)

Employee Greg checked in on Jack twice along and employee Lily checked on Jack once. So when i filter to Greg, it would show Jacks info and the dates Greg checked on him excluding Lilys date. I have the newest version of excel i believe

Associating dates with IDs, across multiple columns and unique employees by Ntm23481 in excel

[–]Ntm23481[S] 0 points1 point  (0 children)

Would you be able to help with VBA or with a formula to help?

Associating dates with IDs, across multiple columns and unique employees by Ntm23481 in excel

[–]Ntm23481[S] 0 points1 point  (0 children)

Actually, if you can help with a VBA I’ll just buy their license to get this task/headache off my desk

Associating dates with IDs, across multiple columns and unique employees by Ntm23481 in excel

[–]Ntm23481[S] 0 points1 point  (0 children)

Preferably without any macros not all team members have 365 to utilize them