tasks

Morning Excellers, I have a sheets used for tracking tests done regularly at 12 centres (monthly, quarterly and yearly tests). I want to make a audit page that will check tasks have been done within allowed timeframes. Ideally this would be come automated but for now a manual approach would...

I have a feeling that this isn't complicated, but I'm just not thinking about it correctly. I have a sheet of my tasks, with lots of autofiltering going on via VBA that is working fine. Now, I want to look at two different date columns (LastModified and StartDate) and filter my tasks where...

I'd like to create a workload tracking tool for a job that has predictable tasks, but is unpredictable regarding the timing of task entry into the workload queue. Tasks arrive at unpredictable times/dates, and have a set number of days between arrival and due date for completion. I would like...

Good afternoon, I am working in Power BI Desktop and I am mostly comfortable in Power Query but I am not opposed to solving this through DAX either. I am importing data from my companies financial software and it is causing a bit of an issue when I want to calculate the total fee of all...

Hi Guys, I have a bit of a tricky one here. I have a few issues that I'm not quite sure how to fix: Let me explain the set up and then tell you the problems. Each Day I get an Excel workbook (I'll call this W1-7) given to me with tasks for the day (not my tasks just stuff I need to track and...

Hi all, I'm creating a 'rewards' spreadsheet and have nailed all of the formulas I need, apart from one :( I'm getting confused with the multiple conditions I need, and how to put it into a formula. <tbody> A B C D 1 Rubies Earned 1250 2 Minimum Tasks Required Number of Tasks...

I amhoping to get some suggestions for what I am trying to accomplish. I amcreating a worksheet for all users in my department. I am looking to create ato-do list section in my worksheet that will include a list of tasks that willbe copied from a website. The user will copy data from this...

Hey folks a lot smarter than I am, I would appreciate some help. I have a large table of employee trained tasks: about 100 employees as rows and 50ish tasks as colums that each employee can be trained in. I would like to set up two different lists: one by task (so everyone trained in task A) and...

I posted the other day for some help with a fitness group spreadsheet and the forum was very helpful. I come again asking for advice / help. The fitness group has daily tasks to complete for points (good tasks) and ways to gain negative points (bad tasks). There are 5 good tasks and 2 bad...

Hello friends, I'm trying to create a sheet used for project estimation and i want it to be simple to use. I want to be able to use buttons to create/delete tasks (cost item) as well as buttons to indent/outdent a task. The later should function like MSProject works. An indented task is now...

Hello wonderfully smart people! Can someone help or point me in the right direction... I would like to have a list of tasks, say A2:D15 would be a list of things to do. Then F:J would be days of the week. So, for example, A2 is "Inventory Parts" and H7 is "Inventory Parts". As H7 is filled...

Hi All, I have a workbook that we use to track completion of audit tasks The workbook is separated into 4 separate sheets. The 'Main Sheet' lists all of the tasks (there's about 200) Then there are 4 other sheets Sarah, John, Josh & Melissa - these sheets are copied from the main sheet based...

Hello, I have a table with months I and various figures for each month. I am wanting to display in columns O the last 3 months that have data in column D (completed). For Example below August, September and October should have a 1,2,3 in column O This is what I have but it won't work...

Hi there, For the problem i have, i thought a pivot table would work, but it doesnt. I will try explain as best as i can. Column A - Task List (about 100 of them) Column B - Monday Column C - Hours Column D - Tuesday Column E - Hours ... and so on. Under the "day" columns, we enter an...

Hi Can I say VBA is not meant to do anything new that a user can not do in excel? I know VBA is used to automate tasks, repeat tasks, create forms, create functions etc. All these things I can do it in excel without needing to use VBA. Can I say that, or VBA meant to do more or new things that...

Hi in the article below it is mention that VBA is used to automate tasks and repetitive instructions. I do not see any different between these 2. Can you give me an example of these 2 things. Thank you so much. Why learning Excel VBA is so important?As you become familiar with Excel, you will...

Dear readers, I know this is a common question as I have read other threads related to this issue. But it seems I can't apply the solutions from the other treads - probably due to my lack of experience with VBA. So I hope someone is able te guide me in the right direction I use to keep track...

I have a schedule of Project level activities that encompasses tasks spanning multiple separate projects. Each Project is individually implemented at a different business location around the globe. However, any individual location may be impacted by the schedule of more than one project in the...

I need a WB to auto_close after Scheduled Tasks opens it but stay open when a user opens it manually. Is there a way to determine via VBA when a WB was opened by tasks (or, looking at the problem from another angle, not opened by a user)?

I have a complex WB with a lot of Subs and Functions. It runs perfectly well time after time when run manually whether called manually or using Workbook_Open. However, when called from Windows tasks, it hangs. When it does this, Task Manager does not list Excel but trying to open the WB results...