complete

I am pasting a large amount of formulas. Is there any way to check that I have not stalled excel. I do not yet see a progress bar. The little circle keeps turning, is there any way to see if this has not stalled for good. Usually I will just wait for a period of time and then reboot. Is there a...

Need help completing my project. https://www.flickr.com/photos/upload/

I have a sheet that will have different amounts of data in it. Data is from column A to K. What I need to do is find where column A has the first blank cell of data, and then delete complete rows from the first blank cell in row A. Example row A1-500 may have data row a501 may not have data...

I have created a workbook to track open and completed work orders. The code below allows for me to move the completed work order from a row on the open sheet to the next available row on the completed sheet by entering "completed". Upon doing this it leaves and open row with one column that says...

<colgroup><col span="2"><col><col span="2"><col><col><col span="11"></colgroup><tbody> Reported Date Day of the Week SDT Number Machine Type Serial Number Reported Fault Status Action Taken Call Out Response Date Call Out Response Time Job Completion Date/Time Machine Down Time Engineer Area...

Hi – I only created my first access database yesterday,so I’m a complete novice. I have created an Access 2007 database with 2tables: ‘Independent Assurance’ and ‘Independent Assurance - Complete’. Both tables have identical structures interms of columns/fields. ‘Independent Assurance -...

Hi All, I'm using Excel 2016 and need some help highlighting. I've added a link to a picture of the worksheet I'm working on. https://drive.google.com/open?id=121zcWYWY9W_6wqLiTiJaQCNdnAT2Jl2s I want to highlight all rows that have the word "Complete" in column J I've tried using conditional...

Could someone please let me know if my query is correct...I keep getting a syntax error? iif(Sum([Assignment_test]![CountOfPlanNumber]+[Assignment_test]![InvComplete])=0, "Complete", "Incomplete"))) AS Expr2 FROM Assignment_test;

Good morning Ladies and Gents, I would like to ask you, if anyone has an a vba code for me regarding below. MsgBox "Milesstone completed?" vbyesNo ifyes enter date and the whole row should be highlighted until this entered date (all dates are in my sheet from F4-GG4) then the text "complete"...

Hi all, I'm having trouble figuring out a formula in excel, and was hoping someone may be able to assist. I have data for a number of people and the status of their work in another column. Essentially want to calculate an overall status. If they have atleast one work complete in 2018, then...

I have a database (table) named "Money" that is 10 columns wide (headings in Row 1, Columns A:J. The columns are headed "Date", "Inv#", "Customer", "Sales","Period","Sales", "Rec'd Pmt", "Rep'd Pmt #2 ", "Commission", "Adjust." and "Balance". In the "Period Column" there is either a 1 or a 2...

I have a list of 10 tasks in column A. Each of these 10 tasks is allocated varying percentages adding upto 100% of a project (column B). Ie. Task 1 represents 3% of the total project, task 2 represents 50% of the total project, etc. In column C is the % complete or each task - for example...

https://drive.google.com/open?id=1xR7n4f-Dt8CTH4zNGRoGl2SqtqHYD2nX Hi, Could anyone please help me do the excel and the complete set of instructions which are already mentioned in it,

Hi all. I'm using the Gantt Project Planner template. I know how to edit the defined custom formatting. My question is whether I can go a level further. For example, rather than just the one color showing the percent complete, if I add another column that shows the status, can I have the...

Hi there, I have my IT guru trying to create a report that will tell me if previous operations within a work structure have not been completed (Either Inventory or Pending status). I was wondering if any of you great people can help. For example from the data in the table below I would B/75 and...

Hello there! I don't know how to even start thinking about this, so I'm coming directly to the experts. I have a coworker wanting a macro done for them, but first we have to figure out how to get the data organized correctly. He doesn't do any of the "hands on" work with the workbook; he uses...

This may not be a thing but I sure hope it is! I would to utilize a formula SIMILAR to below, I clearly haven't written is as excel would like as it is not returning results. J4=IF(OR(d4:k4="x",d4:k4="Y"),"Complete","Active") So, if ALL of those cells contains one of those two status',the...

Hi I have no idea where to start on this. I have a file with a command button that when used saves the file as per the details in cell D2 and fires off an email for the spreadsheet to be complete. This then stores the file in C:\Checklists I want to create another command button that when the...

Hello everyone, I am trying to subtract from two cells that ends in MB, but cant find a way to do this. Example: Cell 1 value is 2000 MB, Cell 2 value is 1500 MB. All i want to do is subtract from Cell 1 using Cell 2 value and return a result also using MB. No matter what i have tried, i...

Morning folks...well its morning here :) I have this code that was kindly produced for me on here. It does the following: Replaces all the formulas in a row with the value when the text and also replaces any blank cells with a dash (-) It does this whenever you manually enter the text...