complete

  1. K

    Macro to cut and insert specific cells based on cell value from one tab to another in the same workbook

    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...
  2. T

    Help needed with VBA code to filling a webform

    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...
  3. E

    Change code from Sheet to Range

    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...
  4. K

    display complete dates as numbers and incomplete as text in same column

    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...
  5. S

    Newbie needs help.

    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...
  6. S

    Message Box Code

    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...
  7. C

    Macro to save form as new worksheet in the same workbook

    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...
  8. E

    Track input on daily basis

    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...
  9. J

    How to highlight cell that is past due AND not complete?

    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"...
  10. P

    Complete missing dates

    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...
  11. A

    get percentages in pivot table?

    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...
  12. D

    2 if(and statements

    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...
  13. 6

    best reference/guide for learning VBA

    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...
  14. M

    Divide the sum of one cell over multiple cells until the value of the original cell is 0

    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...
  15. J

    Macro Slows Down for no Reason

    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...
  16. R

    Macro to transfer Row Data from one existing sheet to another existing sheet based on specific cell text in column P

    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...
  17. M

    Excel Work Sheet for Grocery Shop Complete Inventory Control

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

    Excel Work Sheet for Grocery Shop Complete Inventory Control

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

    Using "IF" and "AND"

    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...
  20. L

    COUNTIF for specific text from drop down list

    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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top