User Profile
Youngmrr
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Folder/sub-folders creation
Hello everyone, I have been trying to create a folder and sub-folders with flows, please refer to the below screenshot or attachment. With the above work flow, from my understanding, a sub-folder 'Document' should be created within a folder (Could be any title) which users created library. However, the 'Document' folder is also created after second run. For instance, Test_1 (Parent Folder) - Document (Sub-folder) Test_2 - Document Document (This is also created after Test_2 folder created) Can you guys help/advise me to sort this issue? Thanks!Re: Macro to copy columns if values begins specific text.
Hi,Bennadeau Thank you for your help. One more question for this to extend moving forward. The macro copies only two columns. So, can you please advise how to do if I have 10 of 'ABCD' columns (somewhere within the same row) to be looked and copied? Many thanks for your help!2KViews0likes2CommentsMacro to copy columns if values begins specific text.
Hi everyone! I am new to Macro. I am trying to build a macro that can copy columns which text begins with specific values (e.g. ABCD) from the active worksheet, and paste into another worksheet ('Work'). It should keep their current row orders. I have attached a screenshot as an example. There will be more than 2000+ rows.. I have tried myself many times but i didn't make it. Can you guys help this? Thanks, YoungSolved2.1KViews0likes4CommentsNeed help building macro to find and replace multiple values in selected cells.
Hello everyone! I have been trying to build some macro to find and replace multiple values in selected cells as below, Sub FR() Dim rngCell As Range Dim fndList As Variant Dim rplcList As Variant Dim F As Long fndList = Array("United Kingdoms", "United States", "Australia") rplcList = Array("UK", "US", "AUS") For F = LBound(fndList) To UBound(fndList) For Each rngCell In Selection sht.Cells.Replace What:=fndList(x), Replacement:=rplcList(x), _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _ SearchFormat:=False, ReplaceFormat:=False Next Rng Next F End Sub But I am having errors. Can you guys help this? Many thanks, YoungSolved6.4KViews0likes2CommentsRe: Button to update today's date in SharePoint list
RobElliottHi Rob, thank you so much for your help. I have managed to execute a flow with a button. Just quick question from this. How did you manage the pop-up screen after clicking a button, which is asking to run flow as attached? Thanks, Young5.8KViews0likes1CommentButton to update today's date in SharePoint list
Hi all, I am trying to make a button to update today's date column in SharePoint list. So, if an user clicks a button then date column updates it today's date. Please refer to the below screenshot. I have been able to make a button. Can you guys help/advise please? Thanks, YoungSolved5.9KViews0likes3Comments
Recent Blog Articles
No content to show