please help

  1. HeRoseInThree

    Data refresh question

    I have a spreadsheet that has my driver's names (and other data) and another spreadsheet that I use that data for. When a driver is removed from the driver data spreadsheet, I receive an error on the other sheet... The formula works well until I remove a driver. The formula I use: ='[N&I...
  2. F

    How we can remove zeros before numbers?

    Hi, I need help to solve this issue, Like i have to many customer codes and they all have zeros before numbers like, <colgroup><col><col></colgroup><tbody> Current Shape Required 000003 3 PAK LAND CHEMIST 000005 5 KHALID MEDICAL STORE 000006 6 CHISHTI MEDICAL STORE 000025...
  3. R

    VBA to ms access query date not working

    Hi im hoping someone can help me with this because i am really struggling.. I am having issue with ".CommandText = Array( _ "SELECT * FROM Consolidated WHERE [Start Date]> '2019-01-01 00:00:00'")" it seems to be working fine if i do the criteria on brand or anything else.. however it...
  4. M

    VBA Copy/Paste Worksheet

    Hi All - Having an issue with copying a worksheet and saving into destination on local drive with the data inside moved with all the equations and data validation - need to copy it only as a read only [No equations, No list] - values only - On Error Resume Next strDirname1 = "XYX"...
  5. T

    How to filter out #N/A Column BC in VBA

    The columns relevant here are BA,BB&BC although I may put this data on a separate sheet just in A, B & C The number of cells occupied and contents in BC changes. Which is why I can't press record and be happy. On Columns BA,BB&BC data filter is applied. I click the header drop down in BC and...
  6. L

    Transpose data - offset data one column

    Hi all - I have the below code to copy a set of row data from one tab and paste/transpose when a Command Button is clicked on a second tab. How do I edit this so that every time the Command Button is clicked, the data is pasted to the right on the first blank row? Currently, when it's clicked...
  7. L

    Transpose data - keep original formatting

    Hi all - I've got the below code to copy column data when a Command Button is pressed and paste/transpose on a different tab. Each time the button is pressed, the data is pasted on the next subsequent row. Is there a way to paste/transpose the data but keep the original cell formatting where...
  8. D

    macro code for search one functional code in entire column and copy paste all other data into another sheet

    hello i have tried macro for,the following thing. "list of codes" is a one excel book contains 16subject codes. "data file" is another excel file..it has 25 columns of data students data.like name ,id number,colege name,doj ,dob,area ,subject code,,etc.,; "imp details" is a new book Here ...
  9. G

    [VBA EXPERTS NEEDED] Mirroring columns to two different sheets

    I just created a thread but seems its gone.. so re-writing. What I am trying to do is make a range which will be mirrored in two different sheets. That is, they accept input which will be reflected in either of the range I specify. For example, if I put 123123 on Range1, it will be shown the...
  10. G

    Mirroring columns to two different sheets

    Hi guys.. my very first post to this site What I am trying to do here is making a two way input range in two different sheets That is, if I put anything in "A:A" Column(or specific range) in sheet1, it will appear on sheet2 "C:C" column(or specific range). Also, if I revise it on Sheet2 range...
  11. S

    Hide rows automatically when another cell contains specific texts

    Excel version 2013 on windows. I have a spread sheet that I need to hide entire rows based on another cells contents. I need two rules, based on different conditions. Rule 1 When cell C14 contains "Select" I need Rows 20:34 to be hidden. When Cell C14 contains Anything other than "select"...
  12. T

    Combining Formulas

    <tbody> A B C D E F G H I 1 Contract# Contract amount Already encumbered Invoices Paid Already Encumbered Balance Current Contract Amount Encumbered Unencumbered Balance 2 1234 100 50 40 40 10 </tbody> I made a small copy of my spreadsheet. I will try to explain what I want to do to...
  13. J

    Macro to send worksheet to Outlook email

    Hi, I am not too familiar with macros. Is it possible to create a macro that will send a worksheet as an attachment to an Outlook email? I would like to create a "Submit" button at the bottom of my worksheet that will send the email if possible. Also, is it possible to have a dialogue box open...
  14. N

    Array and Variable Help

    Hello, Goal = To have a combo box add an item for each cell in a range. I have a userform where a user can select a material, and based upon the material selected another combo box is loaded with color choices that they can select from. But I want this to happen automatically when I add or...
  15. G

    How do create Students Rank List Based on Pass candidate only

    How do create Students Rank List in excel,Based on "Pass" candidate only To assume Rank,If "fail"candidates not assume that marks. I tried this formula =RANK(c6,$c$6:$c$41) It's assumed all marks to getting Rank for pass & fail students. This is wrong, i want only Rank for pass students only not...
  16. D

    countif Query for champs

    <colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col span="2" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody> Posting Date Order No Customer No Combo Code Item Desire Out Put 4/19/2016...
  17. K

    *** Urgent help. *** Take Data from text file and output in text file

    Take 102201631000-102201633999-234245 from text file and take right formula from first two numbers =right(text1,6) & right(text2,6). i.e. 631000 & 633999 then i need to place them in text like. 102201631000 234245 102201631001 234245 102201631002 234245 102201631003 234245 till 102201633999...
  18. G

    Checking the if the values in the row are the same, provided they are not empty

    Hi, Thanks in advance for your help. I have: <colgroup><col style="width:48pt" span="5" width="64"> </colgroup><tbody> Alan Maria Lisa Tony Fred GB65 GB65 GB65 GB65 GB65 GB65 GB65 GB61 GBA4 GB61 GB65 GBA4...
  19. dmqueen

    Syntax error If Or stmt

    Hello, For the life of me I cannot find the syntax error in my If Or stmt. I'm hoping fresh eyes an spot it. I tried to clearly mark the problem line with comments, its the line looking for the Notes field. I'd love any help, Thanks! <code> Sub fInput_Complete() 'Validate Entries 'copy listbox...
  20. H

    Copy rows from multiple different ranges within one sheet to another sheet with and/or without VBA

    Hello, The last few days I have been trying to figure this out with no luck whatsoever. I am using Excel 2010 32-bit with power query on a Windows 7 64-bit computer. I was going the use the html creator, but the dl link was down and I had to use screenshots. I have a sheet titled "LeadSheet"...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top