priority

I am struggling with my code- and will admit that I am a newbie to VBA. Yes- I have reviewed a ton of posts and dont seem to be able to fix my code. It seems that no one else has an answer to the multiple sheets question. :confused: I am trying to extract rows that meet a specific value...

Hi there! What a great community this is! I already found many answers to my excel questions, but here is one I can’t seem to find: I want to build a table which picks musicians according to their instrument from an Excel list. I have built something you can look at here...

Hi I have a range in which the same code is repeated, but this code has another code called Priority. I need to go through the codes and build a string with the Priorities. Exampe: Code Priority String 10.......1........12 10 ......2........12 I try with this For Each: For Each celP...

Hello, I would like to be able to sort a priority list using VBA. I would like to sort first by priority override, simple number sort that trumps anything else. Next I would like to do a "combination" sort. First sort on absolute need date, then on priority: high, medium, low. Then I would...

Hello, I have a workbook where each sheet is a task. In cell B3 of each sheet I have set a priority for the task. For example B3=1 is my top priority. I would like to sort the sheets by priority. Also if two sheets have the same priority then sort those two alphabetically. I also must have a...

Hi everyone.... So I've searched Google as well as I possibly could without knowing all of the search criteria which may be helpful, but since I made a post about this on Reddit that details the goal that I'm after, I'll simply paste it over to here and go from there. It's uncommon to encounter...

hi all, I'm using a conditional format to colour a column depending on what is selected from data validation in the first row. The code for the conditional format is as follows: =OR(T$1='KS3 HOD'!$S$4,T$1='KS3 HOD'!$U$4,T$1='KS3 HOD'!$W$4) The format is to colour the row where the condition is...

Hi there, I am trying to get excel to extract a unique list based on criteria and priority level. I managed to get the list extracted based on criteria but I don't know how to sort them so they are pulled in order based on their priority level. I'd appreciate any help! Excel sheet is attached...

Hi, i have the following data <tbody> ITEM NO TYPE LOCATION QTY MAX QTY 11224 PRIORITY AL4401 4 14 11224 RESERVE GL1202 12 14 55322 PRIORITY AL5503 8 23 55322 RESERVE GL1104 10 23 55322 RESERVE GL1105 2 23 43112 PRIORITY AL5512 6 100 43112 RESERVE GL4401 55 100 67442 PRIORITY...

Hi Guys and Gals, I have a project I have been working on for quite some time, but unable to find a workable solution. Up until now, I have been trying to find a solution without the use of VBA, as I am a relative newbie to VBA, but doing lots of reading and "trial and error" coding to fix...

I have a long list (over 400 rows) of duplicated project names which have different actions and priorities. On another tab I want to extract all the project names + action combination that have top priority assigned. How do I do that? Example Raw data tab <tbody> Project name Action Priority...

Hi All, So I have been pulling my hair out for a few days now trying to figure out how to do this, but no matter what I have tried, it never worked. So I thought my only remaining option is to put it to the experts here on the forum for some help. I am attempting to improve our small company...

Hi Team, I have been brainstorming this from past couple of months. I work in reporting team and during month end I pull all incident report which has changed priority from P1-P2-P3-P4, P2-P3-P4 or P3 to P4. Currently, I am performing it manually (4000+ count). Below is the sample excel where I...

Hi I am having a log sheet where i need to have the cell color changed based on the priority and time duration Column A will have the date of entry . . . Column F shall have priority 1, priority2, priority3 as selection. Default Color for priority 1 is red, priority 2 is yellow and priority 3...

Hi all so i need help with something tried for about 3 days now and cannot figure it out, ive tried looking at google but to no avail basically i have a huge spreadsheet with differnet headings i need to compare 2 values of each row. Heading "priority" and heading "pass/fail" so if the row...

Hello, I am trying to sort through an ever updating spreadsheet and give items a priority. Once the priority is given, I hit my Update command button to populate 5 priority tables (high, med. high, med, med. low, and low). I feel like the below code should be correct for a single priority...

Hi I need to set several function in a single formula but no matter what I do, excel will prompt errors... Could someone please help me with the following: Admin date Deadline Amount A Amount B Status The Admin date will source for data from another table via VLookup. The Deadline...

Hi I am working on a priority list and encountered some problems with it. I would really appreciate all the help, thanks. What I am trying to do is to have excel automatically assign a specific number to the Urgency Column based on how many days the item is from the Due Date. <tbody> Priority...

Hi all, New to the forum, so please forgive any newbie mistakes. I have a list of 40,000 unique part numbers, and a seperate database of 500,000 part numbers. The database has many duplicate part numbers, split by Plant (Ownership). The Part/Plant combination on each row is unique, and other...

Hi! I'm trying to delete rows but there is a priority... The file size is 33,000 lines+ The columns look like this. <tbody> DUNS Maintenance Status 1012319 Active 1012319 1012319 1012319 1012319 1012319 Active </tbody> What I need to end up with is only one line per...