steps

I have a fairly simple model that has 10 steps and the time & cost of each step. <colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="3" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody> ID Activity ActivityTime Activity Cost...

I run a team that inherited hugely manual processes from my predecessor. I want to automate these as much as possible. I want to start by removing the manual steps in our Intrastat process. For those outside the EU, this is a statistical reporting requirement in the EU of goods moved between...

Hi, Manually, I can do: Windows, launch CMD.exe (Start->Run cmd Enter) [In DOS prompt] "cd /d D:\Serious\Work\Other People\Al\DataRead" [DOS] "type *.csv > x.txt" This creates concatenated text file of all csv files in folder. If I run below VBA, I receive error: "The system cannot find the...

Hello. I'm not 100% sure if what I'm trying to achieve is possible in the way that I'm trying to do it, but any guidance on how to start would be much appreciated. Basically my goal is to create a workflow chart to standardize the tasks for specific processes. I have the column "Tasks" B:B...

I have a report I run daily and wanted a macro to use on the formatting of that report. There are numbers that show up as text and if I click convert to numbers it does not record in the macro. So I tried the keyboard shortcut ALT+Menu+C and that did not work either. Any ideas on how to get...

Hi all, Whenever I record a macro to code a series (i.e. 10-30 steps) of simple steps (e.g. add/delete columns, new column headers, insert formulas and copy down to bottom), it often includes many instances of the formulas going to the very bottom of the data set. Super basic. But each time I...

hi, i was wondering if someone could help me with calculating my gpa for 5 subjects. I am searching for a online gpa calculator and also a gpa to percentage converter. Please help me with the steps to use the calculator, if any.

Hi, I will preface this by saying that I'm new to VBA. I'd like to write some code for a command button that will complete a series of actions and then create a series of dialog boxes with fields that the user can then type in, and then when you close the final dialog box, all of those things...

We have certain processes at work that have several steps and also span several days. We often take too much time for one step which in turn eats into the time that we have for other steps. I am developing a spread sheet that allows us to ensure that we only spend a certain time on each step. I...

I'm using Power Query to access data from an OLAP source. Some queries work, but are extremely slow. Other queries timeout after 60 minutes before completing. I've found several articles that discuss query folding, which allows processing of the query to occur on the server instead of the local...

Hey guys, hoping I can figure out if this is possible to do. So basically I'm constructing a sort of project manager buy breaking down the steps. The below table is an example of what I am trying to achieve. <tbody> Priority Project Step #1 Step #2 Step #3 2 Education >> Reading >> Think...

Hi! I tried to modify the HKEY , but it didn't work. I don't have the "common" map, so i think that the file I generated doesnt work from this reason. Thank you for your help, have a nice day! ____________ Path: "As the registry path you access seems to be different from the post mentioned...

Hello, I'm doing a step challenge at work and we've been put into random teams. My team wanted to have their own league so we've set one up but its based on total steps. I've been trying to make a sheet which I can add the total steps at a specific point each week and automatically calculate...

Hello, I am trying to calculate completion dates for process steps. The steps have standard times in days associated with them, however, many of the steps take less than a full day to complete i.e. 0.25, 0.75 days. I tried using the WORKDAY function to calculate the completion date(s), however...

I have a hyperlink that I've typed into a cell, but it doesn't work like other hyperlinks I've typed in cells. What steps do I need to complete to get it to work as a hyperlink?

Hi, How can I change data type to text for all columns no matter what steps has been done before and what columns I have currently?? Is it possible?

Hi, I have two columns with numbers, let's call them A & B, and need to calculate the median of numbers in B that are associated with A's greater than 1. Doing this in one step with "median if" array (=MEDIAN(IF($B$4:$B$3288>"1",$C$4:$C$3288, )) resulted in 0, but doing it in two steps, with a...

Hi All, I have a main workbook on network, for which I have created some queries. I want to use the same queries but on a different workbook. Should I do all the steps that I have done for the current workbook to create those queries?? Or there is a way to copy those queries to a different...

Hi there, Can somone help me in defining the logic for a task i would like to do in excel on a regular basis? here is how my excel data looks like: <tbody> Task # Level 1 Level 2 Level 3 Level 4 123456789 3 1 2 987654321 1 3 </tbody> Macro should be doing the following steps: go to...

Hi, I just discover Power Pivot and I'm happier than ever :-) My problem now is that I'm not able to add new data to the model. I've followed steps in this tutorial: https://www.youtube.com/watch?v=yel9PMxvOfc But I lose all the calculated fields I have in my data set: How can I fix this...