workflow

  1. J

    How to calculate number of due on weekend exclude N/A and blank in that range

    i would like to calculate how many item outstanding will be due on weekend in N/A and blank in the range. <tbody> Item Mail No. Date Received Type Forwarded Date Response Response Date Due Date Day Process Status Days Overdue Remarks 9 SSP-PDP2-WTRAN-856277 01/01/2019 Workflow Transmittal...
  2. S

    Populate table based on data in another sheet

    I have a sheet called "Workflow, and another sheet called "Overview" "Overview" is my dashboard "Workflow" is my data" In "Overview" (dashboard) I have a table From C13:I28 In "Workflow" I have the data I want to populate in that table. My "Workflow" sheet has data from cells A4:J723 What I...
  3. E

    Work flow for Newbie

    I am trying to learn powerpivot and wanted to know the best way to set up my data. I get an extract of student test data in a spreadsheet. It has the student name, id, grade, and the test scores for a given test. Each time they take another test, it adds a row of data. At the end of the...
  4. J

    Using Excel as Work-History / Tracking tool

    Good afternoon, I'm working on a project now that involves setting up a service desk that will be responsible for tracking and guiding individuals through a certain process. It is going to be a specialized desk that only deals with a few dozen items a year, so it doesn't make sense to use a...
  5. A

    NEED: excel workflow macro

    I am after some sort of macro that will help me track work flow between users with some specific caveats. I'm not sure that what I want to do can be done with normal track changes so I may be in need of a macro and since my macro skills are quite basic I'm after some help. Thanks in advance...
  6. S

    Workflow Roster

    Hi all, This is my first post to this forum. Hope i get some valuable replies here. :) I am trying to create a simple BiWeekly roster (extendable to Monthly) for my workflow support team using either VBA or worksheet functions though i am not able to proceed further than the design...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top