# completed

1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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...

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