basic

  1. J

    How can I run this macro in multiple sheets simultaneously?

    I have a macro that I'm using to alphabetize an attendance list and then delete the 'Blank' rows (the cells actually return "" so, when sorted in descending order, they appear above the sorted list of names) Below is the code, that seems to work perfectly - but it currently only runs in the...
  2. Jyggalag

    Excel vlookup problems 2

    Dear all, Please note that I made an earlier thread and am now continuing with the same sheets as before, but also including a new file (file 3). The old thread is here: Excel vlookup problems I currently have three files, file (1): File 2: And file 3: Currently, file 3 has the...
  3. Jyggalag

    Excel vlookup problems

    Dear all, I am relatively new to Excel and have little experience with functions, especially across different excel files. I currently have two excel-files, where one looks like this (file 1): And the other one looks like this (file 2): Currently, what I would like is for file 1 to...
  4. D

    Next Row VBA issue - Beginner

    Hello, I am really hoping someone came help me. I have been trying to teach my self VBA using YouTube etc as my teacher. I have working on this Data Form, I am getting there but I having one issue. I have tried heaps of things and this is the closest I have come to it working. I have set up a...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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!
  10. 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?
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top