Hello !
Been kind of stuck on this project and I would just like to see more recommendations / ways of thought. If someone can maybe help with the needed functions (explaining what functions to use or macros to build) that would be awesome
So these are the steps I need to get done...
1) Make Excel open a new sheet each month (done)
Now these I need help with....and im stuck af.
2) This worksheet now needs to automatically import data from a specific new LOCAL file each month(the file name template stays the same, only month and year change. For example abcd_3_2022, next month would be abcd_4_2022) (generated on the first day of the month, before the new worksheet) - This data is specific - each column has a bit of words and the amount of rows changes - For example:
Screenshot 2022-03-23 213939.jpg
Screenshot 2022-03-23 214016.jpg
im completely lost on the actions i need to do. help please
Bookmarks