process

Hi, In a pivot table I want to find the number of selected values (i.e. not the actual values themselves) in the Page, Row labels and Column labels filters, respectively. I started out with the row and column filters and those elements of the code still work as expected. Unaware of the lurking...

I am trying to achieve the following through formula for a largish worksheet (100,000 rows) (Excel 2010), to identify 'Special' process against all rows which have both duplicate Job ID's and one 'Special' process included: <tbody> Job ID Process Associated Special Process? 45001 Process 9...

<colgroup><col><col><col></colgroup><tbody> Shift Start Time (24 hour format Shift End Time (24 hour format) Process SLA (hours) 13:30 22:30 9 22:30 7:30 -15 </tbody> Formula Used in "Process SLA (hours)" =HOUR(B3)-HOUR(A3) -15 is the wrong answer. How will I get correct Hours (positive...

I have a large workbook with many worksheets within it. The end users fill in the user-forms and email the workbook back to me. There is a "SUBMIT" button in the workbook that uses VBA code to transfers the data submitted to another workbook that is used as a repository. I do not have any...

Hey all, could use a little help on these functions. Currently, I'm trying to determine the max and min based on specific criteria. So my formula is (for example) =DMIN('Sheet1'!$A$1:$AB$543,"Resolution Time",S57:T58) I have two criteria Type and User and I want to know the min for TYPE R&R...

For the past decade plus, the way Excel worked for me anyway, every time you double clicked to open an Excel doc in windows explorer, if you already had another Excel doc open, it would load the new one you clicked on in the same process. Now there seems to be little rhyme or reason. Sometimes...

Hi All, I have a excel sheet with two tabs and want to be able to copy and paste data between the two tabs in the following scenario. Tab 1 - User has entered numbers on following cells A1 C1 E1 H1 A2 C2 E2 H2 A3 C3 E3 H3 User presses a but which contains macro which copies the data...

the way i have it displayed is like below: <tbody> Customer code1 code2 code3 code4 code5 code6 A 3 508 120 325 633 573 M 416 146 631 184 643 771 W 511 45 730 307 79 715 S 636 303 647 75 558 330 R 61 150 98 459 433 799 O 557 445 156 383 131 323 D 402 472 61 58 162 739 X 743 70...

Hi there, I have workbook which each hour triggers a series of macros to run for a particular project (there are several), which creates metrics and reports and stuff. This process takes around 15-20 minutes depending on which project it is running on and at the end of the process, the workbook...

Hey guys. So I have an automation that processes a lot of manual files. It's admittedly a bad process. On one file the user keeps submitting the data with one of the worksheet names with a space at the end. They either submit it as "Shipment" or "Shipment " My code as seen below does not...

Hi, I need to copy a range downwards every 0.5 seconds. The range I need to copy is A2:T2 Is there a code where I can get a button to start this process and then a button to stop this process? Cheers, Will

I want to make a hyperlink for these cells going to folders of the same name. I would like to automate this process as I have over 250 individual cells to link to folders accordingly. Is this a possibility? 201712001 <= i.e. to folder D:/2017/12/201712001 201712002 <= i.e. to folder...

Hello, I'm just getting started with understanding the process of importing external information from an XML file into Excel. I'm working with some older files that were created several years ago. I was wondering what the best approach is to determine what source XML file the import process is...

I have tried to post this question earlier, but it didnot show up. My problem is to find a relative straight forward way to determine what methods are valid for a given set of process required. For example, <tbody> Process 1 Process 2 Process 3 Process 4 Process 5 Process 6 Method A 0 0 0 1...

Hello everyone, I have the following issue: I am doing a long and complex filtering within a table where each filtering process starts at the beginning of a certain Column where it then reads its cells content. In the middle of that filtering process, changes are done to other columns based on...

Hi everyone. I have three different data sets/tables that contains some common columns. The first five columns of each table have the same data type: case, period, place, process, unit. The rest of the columns have different, but correlated, data. The first table contains the feed streams of...

Hi, Could you help with the formula for below Sheet 1 has suppose process Name A Test B Test1 C. Test2 Sheet 2 has Row1 process. Test. Test1 Test 2 A. 10. 20. 30 B...

Hi am trying to find the best way to write this formula. on the administration tab I have Values in A1-A2189 each cell has a value similar to these AT.55 AT.56. I have 281 tabs named Process1, Process2 and so on 281 times. On the Process tabs there is a Row Named Traceability Matrix. and This...

First off... For those of you who have helped me build this macro I've been working on for the better part of a month, thank you! Excel MVPs and experts, this has been a learning process for me, and I cannot tell you how grateful I am for your help and patience. Currently, I am coming towards...