complete

I need a macro that will consider the value of cells in a specific column, cut them, and insert into a different tab (cutting from tab "Active" and inserting on tab "Complete". The macro will cut the data for all cells in columns A through Y for which the value of column U of the corresponding...

Hello all, I would like to create a code in VBA to complete some fields in a webform. Due to privacy-matters I can't copy the whole code of the form. However I can sent the part, where I'm stuck. To complete the webform it appaers I should note something like this in VBA. <code...

Good Evening, Could I please ask for some help. I have used ZVI's code from the following thread https://www.mrexcel.com/forum/excel-questions/710212-vba-code-convert-excel-pdf-email-attachment-14.html Which works perfectly, but I would like it to email a range B2:B200 instead of the complete...

Hello everyone, I am trying to format dates and am having trouble. I have a series of birthdates, most of them are complete and are in mm/dd/yyyy, but some are missing the day. Complete date - 01/30/2018 Incomplete date - 01/00/2018 I am having trouble getting excel to display the dates...

Hey, complete novice here so don´t know how to begin looking for an answer. Basically I have a workbook with a number of sheets and in the first sheet I have the complete dataset. I have a list of names in the A column of each sheet and I want to use some function to go through the list of...

I have some code which prompts users to fill in all the required fields in an excel worksheet before a copy of the sheet is created. I want to add something into the code to also prompt users to select a reason if they have entered a value of 'No' in a previous cell. I have done some googling...

Hi there, I am currently working on a form on excel wherein, once you fill it in, you can save partial data onto a summary sheet (in that same workbook) and have a complete copy of the form saved elsewhere as a PDF. However, is there a macro to allow me to save the complete form (as it is) onto...

Hello all, here is my dilemma: I have a spreadsheet that lists a number of items that need to be completed by the end of a given week, and the list can range from 100-140 from week to week. I already have working formulas that track the total tasks for the week, how many completed, how many...

Hi all, I have a simple action item list for a project. Column E has the Due Data and Column E has the Status (Complete, In Process, Not Started, etc.). I would like the date in Column E to highlight red if the date has already past AND the Status in Column E is anything other than "Complete"...

Hi all, i would like to support me so that to create a vba code, which should run through col. "C" and complete the missing dates by inserting a new row. Please note that the code should complete based on month's days. e.g. 30 or 31 or 28 The employees are 200+ and for each one i would like to...

I have 3 columns of data: animal (deer, fish, bear) /completeness(incomplete,complete, fragment) /level(1,2,3,4,5) I wonder if there is a way to have a pivot table with animal down the side, level along the top and in the middle just the percent of "complete" for instance there in level 1...

GOOD AFTERNOON, I HAVE STRUGGLED ENOUGH TRYING THIS NOW ITS TIME TO ASK THE GURUS. WORKING WITH 2 COLUMNS: F WILL ONLY CONTAIN 0 OR 1 H WILL ONLY CONTAIN YES OR NO SHOULD IT BE IF AND OR? PLEASE HELP...

I learned a bit of VBA modifying recorded macroes but I now want to become a real VBA expert (with Excel 2010). What are the best compact / regular / complete guides for learning VBA on the net? I mean something like these: http://www.excel-spreadsheet.com/vba/vba.htm...

If anyone could help with this it would be greatly appreciated. I have entered the information in the "Complete @" column. I am trying to figure out a way that I can have it done automatically. Basically what I do is take the piece count, divide it by half hours so then I can figure out that...

I have a macro which runs about 6 functions. Besides the last function, each function takes less then 1 second to complete. The last function however is taking over 30 seconds to complete (I timed them all). When I put a 'Stop' at the 6 function and then hit play again, the 6 function will then...

I have an excel file consisting of two tabs, "Active" and "Historical". Both sheets are formatted with same header information that runs from cells A11 to O11. The "Active" sheet is updated continuously throughout the day, running as far down as row 300 in sheet. At end of shift, I want my...

Can anybody share Excel Work Sheet for Grocery Shop Complete Inventory Control

Can anybody share me a Excel Work Sheet for Grocery Shop Complete Inventory Control

Hi guys, to stop me banging my head against the wall any more, could you please help me out on a formula? I have 2 columns (O & P) that have either blanks or dates. In Column "S" I want a formula in there that will bring back one of 3 possible outcomes. If O is blank and P has a date, return...

Is it possible to create a formula to calculate how many cells contain specific text that has been selected from a list? eg Cell A2 can be user selected to be either 'Not Actioned', 'In Progress' and 'Complete'. I want to be able to display the number of all the complete selections