steps

  1. R

    SEQUENCES

    SEQUENCES is a powerful and versatile multi-SEQUENCE solution providing full control over "start" of each sequence as well as each of the "counts" and "steps" and having other useful features such as stacking and sorting The overall function parameters are similar to the native SEQUENCE...
  2. M

    Automating Scenarios and Storing outcomes

    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...
  3. T

    Is this process doable or am I in clock cuckoo land?

    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...
  4. JackDanIce

    Code to automate CMD steps in VBA

    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...
  5. D

    Populate lists based on selections (2010)

    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...
  6. H

    Steps not recording in a MACRO

    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...
  7. J

    How to turn Macro Recorder code to a dynamic range

    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...
  8. N

    gpa calculator

    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.
  9. M

    VBA for stepwise process involving dialog boxes with fillable fields

    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...
  10. B

    Date Changes After Midnight

    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...
  11. Jerry Sullivan

    Enabling Query Folding for Power Query of SSAS Source

    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...
  12. X

    Sorting multi-level data in a table

    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...
  13. M

    How to disable hyperlink warning messages in Excel 2016?

    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...
  14. I

    Total disaster

    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...
  15. R

    Help with Date Calculation

    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...
  16. B

    Creating a working hyperlink

    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?
  17. Z

    Power Query - changing data type for each column

    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?
  18. R

    calculating median of one range based on conditions in another range

    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...
  19. A

    How Two different workbooks can share same queries

    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...
  20. A

    VBA macro to search and edit data in one row

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top