basic

  1. R

    vba code no longer working after 8 years: did Excel or vba change?: lngRowsVisible

    Hi all! In 2011, the kind & infamous Moderator Jerry Sullivan gave me vba to achieve adding or deleting rows to have a proportionate sized sheet to print after filtering rows (in this post...
  2. J

    Pricing tool

    Hi i have basic excel knowledge. I am trying to create a prcing tool for selling laptops (for context) so i want a tool where i cant input all my component prices (differnet ram, hdd etc) then i want to enter my basic unit price, then have drop downs, for each component, it will take the cost...
  3. S

    Multiple Column Combibox

    Good Morning, I have a combibox in a userform that I'd like to tweak. I used to pull data from just one column to display in the box, but now I was hoping to have two columns of data (separated by a space) displaying. I've written a basic piece of code below but it didn't work. Hoping someone...
  4. W

    Basic Formula to Button

    Hi All, I have a formula that returns the last text cell which is =INDEX($F$6:$F$13,MATCH(REPT("z",255),$F$6:$F$13)) and it works well. How do I go about adding that same formula to a form control button? do I use ActiveCell.Formula?? along with my...
  5. D

    Enabling macros

    Why do some worksheets request permission to enable macros whereas others don't? I can't seem to find any consistency, so must be missing a basic setting. Thanks!
  6. D

    Power Query behind a Password protected website

    I'm trying to get tables from a website which is password protected by username and password. It uses the classical web form with a "post" command to access to all the information so I cannot use Basic authentication. I've look in internet for a solution without success. Can anyone help me?
  7. srizki

    A Basic Right(Find formula,

    Hi all, I need to extract number from the string as follows, A B <tbody> [Sold 411045353] 45353] [Sold 411045353] 45353] [Sold 411045353] 45353] 411044924 411044924 411044978 411044978 411044920 411044920 411045039...
  8. B

    Manual enter formula 'conflicts' with VBA created formula

    I have a rather complicated table of formulae which could be easily corrupted by manual manipulation (I'm aware of password protect but that is not my concern). I have set about rewriting all of the formulae in that table in Visual Basic. Now in one particular column the formulae are of the...
  9. B

    Basic Array/Sorting Question

    I try to keep my formulas as simple as possible. Here is my current formula for finding a match in two columns: {=SUM(IF(F$24:F$43=F44,$D$24:$D$43))} The issue with this is that it sums instead of just reporting the value. Which is a problem if the results are not numerical. I tried this...
  10. I

    Basic duplicate needed please

    Hi, I am looking for a basic duplicate code so when i leave a specific cell the code would run. So my new code should work like this. Worksheet is called DATABASE Cell where i would type the customers name is always A6 Once i leave cell A6 the code should check for a duplicate in only the...
  11. B

    Checkbox Macro - Multiple Checkbox

    Hello, I have a workbook with 2 sheets. Sheet 1 contains 3 rate plans all with their own checkbox (form) 1. Basic 2. Advantage 3. Gold I have a second sheet that all the inclusions of the rate plans. I have added on the top of the sheet the rate plans and a check box next to the inclusion...
  12. B

    VBA Run-Time Error 438

    Hi Everyone, I am trying to learn the basics of VBA to automate basic repetitive work tasks. When attempting to declare variables and use them I keep getting a runtime error 438. I am sure this is a vary basic format error, but I have not found any support on how to resolve the issue. Any...
  13. E

    Lost Macros

    Hi There, I'm a bit confused. I appear to have lost my macros. I have written multiple codes and have created icons at the top of my excel window. These all appear to work fine but when I open up visual basic I cant see them anymore. What have I done? and how do I correct it? Any help is much...
  14. M

    Looking for basic formula advice

    I have to take report exports from Salesforce and calculate things like total sales, number of orders, etc... and I have basic sumifs & countifs formulas for most of the statistics (for date ranges, or product type etc..). My problem is that the raw data reports are structured differently...
  15. P

    Calculating IF formula for Tax & NI Deductions..

    Hi All, Any help is appreciated, I've been playing about with this trying to get the formulas right, assuming an IF formula, but not sure how to separate if it requires an answer between a certain range. For example, I'm trying to write cell formulas so whatever Gross income is entered it...
  16. M

    How to do a little more than the basic =IF logical true/false statement....???

    Hello, I am trying to find a way to build on the basic IF function. IF(logical_test, [value_if_true], [value_if_false]) I want to have a few options rather than just one, such as: if A1 = 1, B2 would autofill with Good if A1 = 2, B2 would autofill with Maybe if A1 = 3, B2 would autofill with Bad...
  17. G

    Find the column by name and copy those values (divided/12)

    Hi everyone, Below i have attached table , from which i need to search for a column through column name and when it finds that column it should perform some tasks like 1.It should divide by 12 from all the values which are found 2.Only that column should be copied and pasted in another new...
  18. J

    Urgent Please Help - Basic VB Looping

    Please excuse my newness to VB. I have a urgent task for work that I need to complete today, however I am stuck. I didn't think initially that I would need to use VBA to complete the task, but ultimately I do, and I am too new at it to complete it on my own. Below is the code with...
  19. L

    What language is Excel written in?

    Hi I asked this question before and I got an answer. The answer was Visual Basic. Now I came to this link which says it is written in C++ https://www.quora.com/What-language-is-Excel-written-in Which one is the the right one. Thank you so much.
  20. B

    Extract records based on two criteria

    Hello! im just newbie in excel my question is what formula do I need to get just subjects of all Basic and Common type. My sample dataset; <tbody> Type Subject Basic Subject 1 Basic Subject 3 Common Subject 2 Core Subject 1 Common Subject 3 Core Subject 1 </tbody>...

Some videos you may like

This Week's Hot Topics

Top