things

  1. N

    Excel Book Enquiry

    First post here and purely asking as I haven't found the answer through informational search. I completely appreciate below might not be the best use of Excel and that there are other tools that would probably be more suitable. I am looking for a MS Excel book for non(strictly)-formula/pivot...
  2. Mackeral

    Macro execution via the RIBBON has stopped.

    Now I get a message that saysCannot run the macro "XXX". The macro may not be available in this workbook or all macros may be disabled." I know the macro works because I can run it out of VBA <macros> and it ran it all worked of the Ribbon a few hours ago. So that leaves "Macros Disabled" as...
  3. R

    Delete rows if cell value is not contained on a list

    This is like being a boat owner...there are always things that don't work right, but when most things work, it's really quite fun. I export a report out of a database. The 1st ROW is the header row. The 2nd row is where the data begins. The 6th column contains "Locations". The number of rows is...
  4. J

    flash fill vba for excel 2010

    I am currently using Microsoft Office Professional Plus 201. Flash fill came along in 2013. Is ther a vba to do the things that flash fill does (both adding pattin and splitting out without concatenate and text to columns)? Thanks.
  5. 2

    Home inventory cell pop-up

    Hi there, i made a small parts list. In column A 1-99 each cell will have an item. Ex. A1 saw, A2 hammer, A3 screwdriver. When i click on an item such as A1, I would like a form with labels and text boxes to pop-up. i know i can make a form that matches my headers but i would like certain things...
  6. W

    Useful Excel formulas which people have shared

    Hello, Does MrExcel have a place to view useful formulas that people have shared over the years? If not, does anyone know of a good source for those types of formulas (hopefully categorized for easier/quicker finding)? I'm not referring to a list of Excel functions (which are readily available...
  7. TheRogue

    Text Contains one of many Things

    I have a dynamic list of things. Depending upon what else happens in the worksheet, this list could contain 1-10 entries. I have given it the Named Range of "THINGS" (THINGS=Table1[THINGS]). I have a 2nd table. One column of this table has text strings (Table2[ITEM]). In this table, I need a...
  8. L

    How do I insert date calendars

    Hello, I am putting together an Invoice template for myself and I would like to add a drop down box with a calendar so that I can add dates easily. How do I do this? I have excel 2019. I tried looking it up but the things i found were for older versions of excel. Thank you very much for your help
  9. R

    Pointing to appropriate cells via formula with variables

    Full Disclosure: I posted a version of this on one of the other Excel Forums last night, but I haven't received an answer. I'm hoping you guys can help What I'm trying to do is create a product title for many different products based on type, color, and whether it has a charm or connector or...
  10. S

    listbox select Item via VBA

    I have a document with a listbox (Name = "ListBox1") I multiple choices for text in that box to choose from (ex: TextA, TextB....) I want to use a macro to select "TextA" only (assume nothing is selected before choosing TextA Once done with other things I am not asking about in this...
  11. Mandark39

    Looking for a tutorial to learn making this ?

    This is the only picture i have of this Excel sheet . It had daily expenses , Invoice details , Incomes , Total sales , Total expenses and a few more things . Does spreadsheets like this have a name ? How can i learn to make one like this ?? Thanks
  12. I

    Tables question if i may ask

    Hi, I am sorting out my tables but i notice i have 3 entries of which are related & need some advice. My worksheet has the following. Columns range AI2:AI236 AJ2:AJ236 AK2:AK236 The colums have headers AI = COUNTRY AJ = ITAS AK = ISF When i click any header then look top left of screen i see...
  13. L

    Delete Row if value found from list of things to be removed

    I’ve inherited a transactional database that’s causing meproblems as there’s no governance around changing things… Fix #1 I guess! In the meantime, I’m trying to get a solution. What I need to build is a macro that can pull downloadeddata into a new sheet (I’ve got this already) It then...
  14. T

    Sunif to return text?

    Been working this issue for a while and haven't been able to solve it myself. I can two workbooks, Rent Rolls and Rent Rec. I have several Named columns on rent Rec to keep things simple. Here is the formula I use in Rent Rolls...
  15. M

    I can't copy data from one workbook to another due to Application.CellDragAndDrop = False

    I have a workbook where I want to limit the user's ability to accidentally change the formatting on certain unprotected cells. (The cell can't be protected because I need to allow the user to input data into them, I just don't want things to get changed like number formatting, background color...
  16. L

    Referring to VBA code variables in Worksheet Cells

    Hi, long time listener, first time caller... I've searched both the internet at large and this forum, and all the responses that pop up go in reverse - how to use the variables in VBA to reference cells in various dynamic ways. I have a variable in my VBA code (based on an embedded checkbox...
  17. H

    Need help with macro

    Hello all, I have very little experience with macros/VBA, and I need some help with extracting specific text from a large .txt file into excel. (I know similar things have been asked before but I have not been able to find code that I could use for my purpose.) The "txt" file I have contains...
  18. D

    SUMIF gives wrong result (not in range)

    when using sumif in this example, I get the wrong result. It even adds values from out of the range (see picture) Cell B78 is never in the range, yet it adds it to the result of cell BL78 I have been trying to look for the error all day, and just found this, but can not explain this. (the...
  19. V

    VBA for Data Manipulation

    Hello all, I am new to VBA and Macros, but want to start learning to write macros for some of repetitive duties. I’ve used the recorder but want to do more. My question is that some of my data I have to do a series of things for it to become readable then this data is imported into our system...
  20. P

    limiting SUMPRODUCT to a certain value

    So, i have this formula =sumproduct((H2:H500,"Job 1")+(K2:K500,"200")) Problem is sometimes K says 200, others its 200/tire, etc. Is there a simple way that anytime it see "200" that it will count? Basically i have MX events to also track and trying to automate the tracking. I did try "*200*"...

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
Back
Top