dynamic name

I am currently creating a macro to improve a weekly file update process. I have to copy a specific range of data from one file (file name "Previous Weeks File") and paste it into my current week file - the new week's file name has date changes: "File Update - 03-17 (Weekly)". How can I copy the...

Hi, I have a workbook where the first sheet ("main") is a sheet with pivot tables based on the data in each other sheet in the workbook. These other sheets are data sheets (by date) extracted from an external database. I add them to this workbook every day as follows: [ main ] [ 20230110 ] [...

Hello, It has been a very long time since I have posted on here, so I apologize in advance if I am rusty on any preferred protocol and information/data to include on a post. I need to be able to able to obtain the average daily balance of each case, for each quarter. Since I have not found a...

Hi guys, I have this report that I update each day, and my process is: 1.) go to sharepoint 2.) look for file name 3.) download 4.) make my changes for step 4, I already have a macro created to help me out with that. however, for steps 1-3, i was wondering if I could use some automation for...

Hello, I need to find a way to make the subaddress of my hyperlinks change as rows in my sheet are deleted. Essentially, the code I have below creates a hyperlink on the same line that input from a userform is transferred to. When the user clicks the newly created hyperlink, they move the...

Hi I would like to ask if anyone have an idea of how to copy range of cell from one workbook to another using VBA with a special condition that the source file name is different everyday. example: Date of event: 03/04/2017 Folder 1 --> Daily Updates 20170403.xls Folder 2 -->...