complete

This may be a basic question for many here so apologies. I'm working with a Project Tracker within Excel for the first time. I have the following catagories Status Assigned to Categories Percent complete I need to add more titles within the Category bucket I've looked and researched but...

Hello, I want to move the entire row when I have 100% complete in "F" cell to new sheet deleting the old. Sheet name "ActionItem" move to sheet "Completed" I would also like to keep original formatting but it isn't necessary. <tbody> a b c d e f g h request from priority assigned due status...

Hello! Disclaimer: Extremely new to VBA. Not computer-illiterate, but not familiar with VBA. I have a table with action items containing a column which marks each item as Open or Complete. My end-state is to move rows in the "Open" sheet into the "Complete" sheet as soon as the action item is...

I know how to open a document. I want the VBA to allow the refresh upon opening to complete before saving and closing the workbook. Workbooks.Open Filename:="Folder Location"

This one is baking my noodle. I need the digit in () extracted into a separate column. These are all values in Column A, though some columns are indented. Ideas, please?? 01. First Week (1) None (1) 10/09/2018 (1) Initial Onboarding Complete 01. First Week (1) None (1) 07/30/2018 (1) Initial...

So I have two text strings, in seperate lengths, I want my formula to be able to pick up the CH12 or GB01 and copy it to a different cell. I am tring to get it to go through a Vlookup as there are a lot of company codes. Ideally what I would like it to do is to look at the text string finds the...

I have a sheet with a date range to put the current progress under it everyday. What I am trying to do is run a macro to take my current percent complete in A2 and look for date in range K2:BS2 that matches the date in cell A4 and place the percent complete as a value in the cell.

The data I have looks like ID. Date. Status 1. 1/1/18. Complete 1. 6/30/18. Complete 1. 12/31/18. Refused 2. 1/15/18. Refused 3. 4/30/18. Complete 4. 2/1/18. Refused 4. 4/1/18. Complete I...

Dear All, Greeting for the Day! I have a query in VBA, I have written the code successfully and macro running properly from backend i.e VBA Editor. But when I'm running the code from excel the automation is not giving me the complete output. Need your expertise in this to understand why it...

Hello all! I have been struggling with this ridiculous formula for longer than I even want to admit, so now I'm here begging for help. I'll try to explain this as clearly as I can: What I have to work with: Sheet 1 is called "Totals" Sheet 2 is called "COMPLETE" Totals has a table on it...

Can anyone help me? This code works but it takes toooo long to run. Is there a way I can rework the de to speed it up?Thank you,Nate Sub MoveLS() Dim i As Variant Dim endrow As Integer Dim ASR As Worksheet, LS As Worksheet Set ASR = ActiveWorkbook.Sheets("Detailed Activity") Set...

Hello,<o:p></o:p> I am an Excel novice, but I need to complete this little tool ASAP, I’ve donesome research but realized very quickly I was either getting wrong or halfanswers. I’m hoping that the folks here can read the description of whatI want and lay out what I will need to...

Hello, I have the following data set: <tbody> A B C D E F 1 LOW POINT TEMP QTY ORDER QTY STATUS CURRENT QTY LOW? 2 2000 0 1000 NOT COMPLETE 500 FORMULA??? 3 500 700 1000 NOT COMPLETE 200 FORMULA??? 4 400 0 300 COMPLETE 200 FORMULAS??? </tbody> 1. If D2 = COMPLETE, Then I would...

Hi All, I am trying to complete a parts ordering system for work with my limited excel knowledge. I currently have 15 worksheets with various names & each sheet has 5 x columns: A=Item B=Description C=Cost D=Order E=Total. What I need to happen is when a quantity is entered into Column D, that...

Hello, I am building a worksheet that I will need to get data from. The question is how can I write a code so that it can pull data by date. For Example on the main Sheet A--------B-----------C 1/1/19 - Job1234 - COMPLETE 1/1/19 - Job5678 - Not Complete 2/1/19 - Job9012 - COMPLETE 2/1/19 -...

I am not sure if this would be a place to seek assistance but I thought I would try. I am assisting a team to calculate their productivity percentage (score tied to bonus). Its a little complicated then just regular productivity. The team has 10 days to complete a task. I would like to...

Hello! Here attached is my table. This is a table that get updated every day. Every time the pilot or copilot make a landing, it is recorded. For accuracy, pilots need to complete 3 landings every 90 days. I am trying to find a formula that will give me the date of the last 3rd landing...

Can someone please help. I'm almost certain this code has worked fine in the past. I am a teacher and developed this tool to move students and their data from one class to another...... 'Moves a student from one set to another Sub MoveSet() DisableCalculation Application.ScreenUpdating =...

Hi all, I’m looking for a VBA code that will delete a row 34 days after the date in the row. I’m a complete novice with VBA and couldn’t find what I was looking for by searching. Thanks

hi, I would rather have VB to sort my issue rather than use conditional formatting, but I lack the VB knowledge & hope 'Mr Excel can sort? so when any cell(s) within col c, contains 'Code2663' it will turn all the text in the applicable row red. The complete range is from A2:J200 many...