problem

  1. K

    Problem with Advanced filter in excel 2007

    Hello, i cant find what Iam doing wrong, I have quiet complex table (9199 rows actually and colums from A to FE) I wish to use just 2 columns for filtering, but i need to get few combinations of data extracted. 1st column iam using for criteria should search for like values Data1 - Data6 and...
  2. T

    Double Negative and If statements

    I have the following formula in cell A13 IF(AND(H6>0,J8<-0.02,L6>-0.02),"MANAGEMENT SIGN-OFF IS NEEDED",""). If the value of J8 is -.01 the true statement appears but -.01 is not less than -.02. I know it has to do with comparing double negatives. The problem is sometime the result in J8...
  3. P

    After transfering data from a userform one sheet becomes hightlighted

    The problem is when i use a userform to transfer data to a worksheet that worksheet becomes highlighted. the problem is this started at row 54 and continues on the rest of worksheet as i add data from the userform this problem didnt happen in the previous 53 rows. What i have to do to get the...
  4. B

    using a cell reference in a range command in VBA

    Hi everyone, I am new on here and have a small problem. I want a command button to copy a range of cells and past somewhere else on the sheet. Simple enough I know, but if I have range("A1:A10") no problem, but I want range(A1:A&H1). I know this won't work, but I want the value to change to...
  5. masud8956

    Problem with NETWORKDAY.INTL Function

    I have used the formula below several times in my worksheet. I am using Excel 2016 so not facing any problem. But some other users are getting errors who are using Excel 2007/2010. =IF($K$7="","",IF(NETWORKDAYS.INTL($K$7,$E$8,7,$T$35:$V$67)<1,"-",NETWORKDAYS.INTL($K$7,$E$8,7,$T$35:$V$67))) When...
  6. F

    Today's date - 5 years

    Hi all - I NEED SOME HELP!! I have 3 drop down lists - DATE (D2); MONTH (E2); YEAR (G2) I have annual leave allowance based on time served - (Q2) 25.0 (<5 years service); (Q3) 30.0 (>5 years service but started after 30/4/2013); (Q4) 31.5 (>5 years service and started on or prior to 30/4/2013)...
  7. gheyman

    Updating Linked Tables to Back End Problem

    I have a Back End (BE) with all my Tables. When I am solely in the Front End (FE) Database everything runs fine. As soon as another user opens and uses the Front End database the database somehow is loosing the links. We get a message that it doesn't recognize the back end and we have to...
  8. D

    Dividing by a value in a cell that moves

    Hello all, So my question is how can I use a value that is calculated in a cell to be a denominator in a formula into other cells? The problem I am having is the cell that is the denominator could move to a different cell the next time this macro is ran. The value will always be in column D...
  9. H

    Problem scanning data from a barcode reader into excel

    Hi all, I have a vexing problem. I have a Toughbook CF-H2 Toughbook running Windows 7 pro with service pack 1. The unit has a built in barcode scanner. It scans a barcode perfectly and inputs the number into Word, Word Pad, or a text document but when I try to scan the barcode directly into...
  10. LocalNeko

    VBA - Consolidate Data and place the new data at the end of the main sheet

    Hello All, I'm new in the macro space and I'm pretty sure this question has been asked before. But I have multiple worksheets (12 in total). That need to all be gathered in a single sheet. Now, I'm able to consolidate the files it's just that my problem is that the placing of each sheet is...
  11. M

    VBA Error window has changed - no more Debug button

    I'm not sure how or when this happened, but the look of the VBA error windows I receive has changed. I've created an image to show you what they looked like before, and what they look like now. This is a big problem, because when my code has an error, I can no longer use the Debug button to...
  12. M

    VBA Copy from Closed Workbook

    Hello Everyone, I have a small problem with copying sheets from closed workbook "x" to my workbook "y". So the copying isn't the problem, just the formulas in workbook "x" because in this workbook I have formulash which referres to another sheet in this workbook. So when I am coping this sheet...
  13. L

    Match multiple values from one column with single value from other column

    Dear MrExcel community, greetings! After thorough searching through forum, I could not find an answer to my needs (maybe I didn't search properly?) I have a following issue: I have a LOC column that has unique values (locations) and GRADE column (which has only 4 possible values). My...
  14. I

    Formula Rounding

    Hello, I've got a problem with a couple formulas I've entered on a spreadsheet. The first formula is performing a calculation based on data from another tab. I want it to round the results to the nearest whole number. I can click "Decrease Decimal" and it shows 1.9 as 2 for example. The...
  15. N

    VBA - Change inputBox date from US to UK standard (mm-dd-yyyy -> dd-mm-yyyy)

    Hello I've been searching a bit and seems like there's no real answer to this. As it is I can add the date (dd-mm-yyyy), but it won't see it as a date before I manually press enter on the cell. Problem is when another macro afterward search for the latest date and won't detect that cell as a...
  16. K

    Excel lags when switching between automatic & Manual calculations

    wonder if anyone has a fix for this problem. it is not related to actual calculation time as the effect occurs even with a new blank sheet. I will do my best to explain and hope someone has come across the problem as well. With a new and blank sheet changing from Automatic to manual causes...
  17. RobbieC

    Workbook not updating

    Hi there, I have a massive workbook which is mainly inputted via user forms. I'm running excel 2010 and everything runs fine on my computer and 3 other machines I've built with similar spec. However, I've just installed the workbook onto 2 new laptops (with same spec) and I appear to have a...
  18. P

    Mixing text and times

    Hi All I'm have a problem combining two columns into one. The code below does what I want Sheets("Calculations").Range("K2") = Sheets("Calculations").Range("J2").Value & Sheets("Calculations").Range("I2").Text J2 contains a value and I2 contains the time and works as in it displays:-...
  19. D

    Finding approximate value based on interpolation of data

    Hello, I need help with this problem of finding the closest result based on 3 criteria. Using index and match I get the result but only if the result value and the variables are exact match. These are the measurements that I get from device: Variable_1 - B2=59.3 Variable_2 - B3=31.3 Variable_3...
  20. L

    Concantenate problem

    Hi All , and thankyou in advance for looking at this problem. I am adding 2 cells together for an email address , first name , last name with a . inbetween , then the email address ;EG STEVE SMITH , it should read as steve.smith@blah.com. However only on a few occasions there appears a space in...

Some videos you may like

This Week's Hot Topics

Top