completed

  1. 6

    Plotting Pixels

    Hi, I am trying to plot a Mandelbrot using "gdi32" library function SetPixel after setting 1DC = GetWindowDC(0) Seems to work initially but the Excel window seems to reset/refresh halfway through the plot and either stops plotting or the completed portion of the plot disappears completely. I...
  2. K

    Replace number with Text with the help of conditional formatting

    Hi, I want replace the numbers which are greater than 79 with the text "Completed". How to do that? can anyone please help?
  3. D

    Multiple IF Formulas

    Hello guys, need your help i have the below table <tbody> 1 A B C D 2 Qty Received Missing Completed 3 50 10 =A3-B3 </tbody> i need to create a formula in D3 that will do the following: IF C3 is empty D3 is empty IF C3 is lower then A2 = Pending IF C3 is equil to B3 = Completed...
  4. K

    Count the period once cycle is completed

    Hi, This query is bit complicated I will try my best to explain it Data are located in cells C6:I82 what I need to check cycle for 1, X & 2 among the 7 columns C through I one by one and count the max numbers where the cycle is completed within the 7 column and the count result show in...
  5. H

    Inserting rows below and copying down the formula

    Hi Folks, I'm quite a novice at VBA and would like a macro to insert a Row(s) at the bottom of a table and copy the formula so that it pulls throw the information form another sheet within the workbook e.g. Rows 2 to 5 have completed data Rows 6 to 10 are blank of data but have the equation...
  6. H

    Inserting rows below and copying down the formula

    Hi Folks, I'm quite a novice at VBA and would like a macro to insert a Row(s) at the bottom of a table and copy the formula so that it pulls throw the information form another sheet within the workbook e.g. Rows 2 to 5 have completed data Rows 6 to 10 are blank of data but have the equation...
  7. N

    Complex IF INDEX MATCH ISNUMBER Formula

    Hi, after posting a few weeks back now, I have come back to a conundrum of a formula. I basically have a list of projects, all of whom report back to me on a 6-monthly cycle, from anything between 1 and 5 years (so 6 month report,12 month report,18,24,30,36,42,48,54 and 60 etc.). However...
  8. B

    Populating a cell based on conditions of other cells

    I have a small test spreadsheet similar to one I use at work where I'm testing out some things and trying in a number of columns to populate cells based on conditions of other cells to cut down on the amount of inputting needed. I have the basic formulas figured out, and it's all working...
  9. B

    Popup reminder if data is missing in table

    Hey I have a excelsheet that several ppl use. In it i have built a userform that ppl use to input data, read and edit data. One action the users do is to mark data s "completed". In my table the row gets an TEXT in one column, stating that that row is "done". I would like to build some kind...
  10. T

    VBA to bring up message box and add data if the answer is yes

    Hi Everyone, I have a tab call "Sales" In Column A in have statuses, In column J I have if the job is current or completed. I'd like a macro that could do this, If a cell in column A is changed to Active then that same row Column J = "Current" if a cell in column A is Changed to Inactive...
  11. M

    Percentage of completed tasks based from cell colour

    Hi there, I'm new here so hello everyone! :) I've been tasked with organising some files, i've been asked to look at an excel sheet that has lots of different jobs on it. Once a job is completed, the background colour is manually changed to a green. Now i want to make a front sheet with a...
  12. D

    Linked Access Table and Vlookup dont work

    Hi All Was wondering if any one can tell me what I am doing wrong . I have linked and access Table to a excel Sheet,but i cant get Vlookup or index and Match to return any values i know i have done both of them the right way. I created a scaled down table on another sheet and used the same...
  13. E

    Interactive Assignment List

    I have created a assignment list for a large gathering. Sheet 1 contains a list in column 1 of all adults attending, 40 names. Sheet 2 contains a list in column 1 of tasks needed for the gathering. For example bringing items, cooking, cleaning. In column 2 contains a validation list...
  14. Gopalakrishnan

    Doubt selecting completed cells as RANGE

    From my worksheet, I just wanted to copy completed cells from used range (** used columns) which would have more than 100 rows but minimum 5 or 10 cells only would contain values. Here I wanted to copy those completed values from activesheet and need to paste another book. Already I have...
  15. P

    MDX query detecting when finished

    Hi All :confused: I have a workbook with numerouse MDX queries. To refresh everything I can just hit the refreshall button and wait ... to code this I can code the refreshall. What I want to do is automate this and then close the workbook. The problem is detecting when the sheet(s) have finished...
  16. D

    Why does Excel run slowly / unresponsively AFTER this macro has completed successfully?

    I have a fairly large macro shown below which basically open a Word template, copies some named ranges in then completes a mail merge merging data from the workbook into the Word template. Finally it calls a simple Word macro to insert a table of contents into the document. It does a few other...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top