process

Hi All We hold our data in Salesforce Professional. Every day I have to go through the process (in Salesforce) of exporting .csv reports to Excel 2013 to then manipulate the data. I am presently in the process of automating the Excel part with macros. Can anybody advise whether there is a...

Hello, I have a form, five rows with seven columns and want to repeat the form eight times per page. One form per line in database. There could be as many as 44 lines to print which requires 44 forms. Any suggestions to automate this process would be appreciated. Please consider my age...

I want to create this macro to automate the process of separating the data. The manual process is filter the data by column A (company code), and paste the filtered data into a new tab. Tab name is the company code.

Hi all, I’m looking for some help on automating a process in Excel. I can do simple vba but I’m out of my depth on this one. Here is the process I’m trying to automate: Sheet “Dates” has a list of unique dates starting in cell A2 down to A250 (although the number of dates can change)...

I have an excel workbook and I would like to automate it to make my team mates in other office locations to use excel to update stock reports. I have 6 sheets in the workbook named: Process: Sheet where automation takes place Database: Contains all the stock list Stock Update: Contains the...

greetings I need to know the Process ID of specific notepad already open PID= ??????????? thanks

Hello, I am trying to calculate completion dates for process steps using the WORKDAY function, however, the WORKDAY function alone does not recognize partial days i.e. 0.25, 0.75, etc. Is anyone able to recommend a function that calculates completion dates for each step in a process? I will...

I'm attempting to create a tracker to move candidates through a recruitment process. Part of this includes totalling how many people are in each stage of the process (Screening, Recruiting, Exams & Applications, Onboarding, and Contracting). I've been using a COUNTIF statement to total as...

I am working on automating a process. Part of the process is to detect when new people appear on the raw data. I am trying to come up with a formula that will look for the persons ID3 on 2 sheets and tell me if they do not exist. I came up with...

Hi, I need some idea to process a set of data, which only first 2 numbers in a cell are needed. Example as table below, <tbody> Data Expected Output <tbody> YL28T709 </tbody> 28 <tbody> 32SH </tbody> 32 <tbody> LED2410 </tbody> 24 <tbody> L32FNT </tbody> 32...

Hi Guys, as indicated, the numbers marked in red are the expect results, process and registration fee will be extracted from table 3 and cost will be extracted from table 2; couldn't really pinpoint what formula to use, a few look ups ? could you help me with any formulas with regard to this...

Hi Guys, I would like to have the values from the Revenue and cost sheet tranferred to the work sheet respectively: <tbody> Work sheet Jan Serial number Process fee Registration fee Process cost Registration cost 123525 5245+5647-5475 5648 5245+5647+5475...

Hi Guys, I Need some help with regard to when certain cells have value and return to colour-shaped Status: I have 2 different workbooks: one indicating: <tbody> Jan </tbody> <tbody> <tbody> Serial number </tbody> Process fee Registration fee process cost Registration cost...

Hello VBA Superiors! I am working with a workbook that uses a index/match formula with a few named ranges. my current code works just fine, but I would love to simplify it. I am aware I could put in a single code to drag the formula across the entire used range of the worksheet, but what I'm...

I'm running 2016 and need to configure a spreadsheet so users can click a button to copy a sheet named "Template" and have it placed as the leftmost sheet. I'm not a coder, and have tried to go through the process via recording a script but it's not working as expected. A little help, please...

Hello! I am working on a similar project in this thread: https://www.mrexcel.com/forum/excel-questions/607461-concatenate-cells-column-until-blank-cell-2.html However, I need to loop it once so that the process only completes on the second blank. For example my current data looks like this: IMG

my table is like below I need to count how many r there are for all process only for Quality (5) I need to count how many r there are for all process only for SHE (2) etc Many thanks for any help <tbody> Process Day 01 02 03 04 05 06 07 08 09 Process 1 Quality n r g a r g g a g Process...

I have a name variation I'm working with that is like the following example: "Project Type - (Main Component) Additional Information" I want process the above quoted text string into 3 cells. I was all the text before the dash in 1 cell, all the text in the () is a 2nd cell, and everything...

Hello Everyone, I have been working on a formula for the past hour or two and am running into a brick wall and am hoping that you will be able to help by saying "Yes that is simple, this is what you do" or "Stop being stupid Excel can't do that!!!" lol Anyway the problem I am having is...

HELLO GUYS , please i am trying to automate this process using a drop down list with formulars. i want to be able to get the total time spent in the office with a name. there are various people, various TIME IN and TIME OUT. i dont have VBA enabled, is there any way i could get this done. ALSO...