User Profile
Chan_Tze_Leong
Brass Contributor
Joined Jan 14, 2021
User Widgets
Recent Discussions
View selected columns in Excel using VBA
I am considering of viewing the Q1 (Jan to Mar), Q2 (Jan to June), Q3 (Jan to Sep) and Q4 (Jan tro Dec) ufor Target and Actual months using VBA. The below does not work. Please advise Cells.Select Selection.EntireColumn.Hidden = False Selection.EntireColumn.Hidden = False Columns("I:Q").Select Selection.EntireColumn.Hidden = True Columns("V:AD").Select Selection.EntireColumn.Hidden = True End Sub Sub view2() ' ' view2 Macro ' ' Cells.Select Selection.EntireColumn.Hidden = False Columns("L:Q").Select Selection.EntireColumn.Hidden = True Columns("Y:AD").Select Selection.EntireColumn.Hidden = True End SubRestrict users to copy past content to Excel file in Sharepoint but restrict overwriting the file
In certain folders in Sharepoint, I want to enable users to copy and paste contents to an existing Excel file stored in Sharepoint but I don't want users to upload their file to overwrite my file. Which option below should I use or can it be customised? Full control Design - Can view, add, update, delete, approve, and customize. Edit - Can add, edit and delete lists; can view, add, update and delete list items and documents. Contribute - Can view, add, update, and delete list items and documents. Read - Can view pages and list items and download documents. Restricted View - Can view pages, list items, and documents. Documents can be viewed in the browser but not downloaded.Getting started on Azure
I work with large dataset and I am just getting started on learning Azure. I am famaliar with Python and Powerbi. I am planning to integrate Synapse and Databricks for anaalytics and visualisation using Powerbi. What books do you recommend for me to understand these modules?Re: Excel formulas with round function
HansVogelaar In the attached file, rating is based on achievement from 90% to above 120% (from rating 1 to 5). For example rating 1 is from <90% and rating 2 is from 90% to 95%. If the achievement is 95.6%, it should be rounded to 96%. If the achievement is 91.3%, it should be rounded to 91%. . How should I do? In addition, I have inserted the FileName =GET.DOCUMENT(88) and the MTD Apr 2021 and YTD Apr 2021 is based on the FileName. However, when I change Excel name to KPI CY2021 CSRM_Apr to KPI CY2021 CSRM_May, the MTD and YTD name still refers to Apr instead of May. How do I fix this problem?Excel formulas with round function
I would like to insert round() to a range of highlighted cells that includes existing formulas. Any help? A reference : I found a macro that round Here is a macro that will wrap a ROUND() function around all of your formulas within the active data area that have not already been ROUND()'ed. Sub mcrRound_5_Formulas() For Each Cell In Range(Range("A1"), ActiveCell.SpecialCells(xlLastCell)) If Cell.HasFormula Then If Left(Cell.Formula, 7) <> "=ROUND(" Then Cell.Formula = "=ROUND(" & Mid(Cell.Formula, 2, 1024) & ",5)" Cell.NumberFormat = "0.00000" End If End If Next Cell End SubUploading files into MS Teams/Sharepoint
I would like to create a dashboard to automate submission/uploading files with a Division Name and Month as its name so that I can know which division has submitted/uploaded files and those who have not. Any ideas? For those who have yet to upload, how could I automate reminders either through email/MS chat to them?
