Forum Widgets
Latest Discussions
Pull data from other tab
Hopefully I can explain correctly. I have a calendar tab and on this tab, I have a box that is to give me my PTO available hours. The PTO available hours are located on a separate tab. My goal is to pull my available PTO hours over to the calendar tab BUT I'm trying to figure out if I can pull it based on today's date. Currently on my PTO tab I have the whole years worth of PTO so the calendar tab is pulling that last PTO available (December's). Any help would be greatly appreciated. Thanks
How can I overcome the HYPERLINK Functions 255 character limit?
Hi! I am trying to workout how to overcome the 255 character limit for the hyperlink function in excel. Currently I have formulated a HYPERLINK link which pre-populates information for a 3rd party form (JotForm) with values from my spreadsheet. It displays #VALUE! in the cell. Does anybody have any suggestions or solutions for overcoming this issue? Thanks!
Select from multiple conditional format rules, based on value of another cell.
I have a spreadsheet tracking due dates for deliverables, depending on what department a deliverable is for, the acceptable time taken from order to delivery varies. On Column H, I have a formula that calculates how many days OVER the acceptable time a delivery is, I want a conditional format that colours that cell on a gradient from 1 to 150, going yellow to deep red. So a quick visual inspect will show which ones are going to be a major problem. The difficulty being the gradienjt scale will have to change depending on the department that deliverable is for. So in Column C I have the department name, this gives Column D data to look up in a config tab, that lets it check how many days is considered late using a basic Vlookup ona small table that is just two columns Dept Name, and acceptable days late number. =IF(C2="","",VLOOKUP(C2,Configuration!D$4:E$6,2,FALSE)) Then Column H looks at the order date(Col F) and delivery due date (Col G), and checks if the time between is over or under the acceptable range with a simple comparison and show how many days (If any) late the delivery will be. =IF(G2-F2>D2,(G2-F2)-D2,"") I want Column H to be conditionally formatted with the mentioned gradient, however the conditions for that gradient will change depending on whats in the Department Column C, some departments consider 14 days over to be acceptable (coloured yellow), some departments see 8 days as a critical issue (Coloured deep red). So my question is how I apply a different Conditional Formatting Rule to the cell in Col H, depending on the value of Col C. If thats even possible. I know I can do it with a macro, but I want to try keep this worksheet formula's only if possible as the person using it does not use VBA and wouldn't know how to troubleshoot if something went wrong, whereas I could explain a formula to them.
Excel saving to PDF - Margins
Hi, I am having issues when trying to save my excel to pdf (the excelcontains a lot of text). When I open the pdf and review it compared to the excel sheet, it seems the margins have changed, forcing some text to go on to another row and therefore being cut off in the pdf. Can someone list all of the places I will need to go please
Spellcheck Not Working for Some Words?
I have a workbook with misspelled names like Tangirs, Manilla, Aisa, Santigo. These are places. Spellcheck caught Tangiers but missed Manila, Asia, and Santiago. Any idea on what's going on and how I can prevent this? These words seem obvious. Full Name Region and Sub-Region Bonita Sykes North America - New York Cairo Pemberton Aisa - Manilla Chante Devlin Africa - Tangier Erica Prince Europe - Santigo Florrie Greenaway North America - Chicago Frederic Holman Europe - LondonAdd secure additional workbook and worksheet protection Use MS account
Instead make the workbook protection including locking cells and editing printing all the features associated with locking a workbook and worksheet away from a password. Instead have it linked to the Microsoft User Account and therefore the workbook or worksheet can only be edited by the creator when they are logged into their account and open the workbook. The current password way is not secure as we all know. If the formulas are encrypted (tied to our Microsoft account), then they never get decrypted on the end user’s machine, so there’s nothing for a hacker to inspect and steal. We would also need to lock or disable macros for untrusted users, VBa would also be hidden from those who are not logged into the creators MS account. This would greatly enhance the security of how office files are shared. The option to use the existing password system could still be selected as an option for those users who prefer it. But add this method of protection in there for those who really need it secure. No additional software would need to be installed or anything. No Azure rights management or anything. No Purview. These features simply dont let a user open the document unless they have rights. We want to share excel files with other users but restrict what they can do with them. Why using Microsoft Account would be more secure Password hashes wouldn’t live inside the file anymore (as they do with current sheet/workbook protection, which is why VBA can brute-force them quickly). Encryption keys could be tied to the user’s identity (e.g., your Microsoft account generates or retrieves a decryption key from Microsoft’s key service). Without that authenticated session, the file cannot be decrypted. Cloud-backed key management would allow revocation — if your account is disabled or you revoke access, the workbook becomes unreadable. Conditional access could apply (require MFA, only allow corporate devices, block risky sign-ins). All creator data is tied to MS account and therefore undetectable and locked to any who are not the creator of the locked document.
