User Profile
PierrickE
Copper Contributor
Joined Sep 15, 2022
User Widgets
Recent Discussions
Re: How could I automate a tracking list of "how many projects users were on at given dates"
OliverScheurich Thanks for your reply. I could use Power Query to automate my actions and repeat them to update. But we'll have to use it on a few PC from the office and can't install anything on most. That's why I would like to find a way to create a macro/script for it. The List I made with a manual output could be use as it is. Maybe a simple macro to add an update button. But my major issue is that dates are going to move. I'm looking for a way to make that button "grab" every single date, from a range (7 columns and 500 rows), and take those individual dates as colum headers (creating new ones if needed and deleting old ones, or plainly overwriting all the old ones) for the Listing.1KViews0likes0CommentsHow could I automate a tracking list of "how many projects users were on at given dates"
Hi, I managed to get where I needed to, certainly not in the most efficient way, but it's working. Now, I would like to automate the process if the data sheet is updated. So, from a data sheet like this example : https://drive.google.com/file/d/1lbdFRTdScwsFPn8V5k-5yAfDwJeXoCfi/view?usp=sharing , I would like to get a list like this : https://drive.google.com/file/d/1ZeAZY-u9ooQo583P7PVqyDdnRQ43pkAy/view?usp=sharing Got it this time, with manual editing and some https://drive.google.com/file/d/1burFsbWjcLloMTprdlBSTAEzLzIRagvZ/view?usp=sharing : =(NB.SI.ENS(Sheet1!$C$2:$C$13;Sheet2!B$1;Sheet1!$B$2:$B$13;Sheet2!$A2))+(NB.SI.ENS(Sheet1!$D$2:$D$13;Sheet2!B$1;Sheet1!$B$2:$B$13;Sheet2!$A2))+(NB.SI.ENS(Sheet1!$E$2:$E$13;Sheet2!B$1;Sheet1!$B$2:$B$13;Sheet2!$A2))+(NB.SI.ENS(Sheet1!$F$2:$F$13;Sheet2!B$1;Sheet1!$B$2:$B$13;Sheet2!$A2))+(NB.SI.ENS(Sheet1!$G$2:$G$13;Sheet2!B$1;Sheet1!$B$2:$B$13;Sheet2!$A2)) (in french, "NB.SI.ENS" = "COUNTIFS") Now, I would like this list to update if the data sheet is updated. That means adding/removing columns for each individual date found (in the data sheet's specific columns). And then counting everytime a date fits an user. And, if possible, don't auto-update but make a button to press for that. I guess I'll have to use macros/scripts, but I'm really new to this. I anyone could help or direct me toward some guide, I would be gratefull.1.2KViews0likes3Comments
Recent Blog Articles
No content to show