things

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...

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...

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...

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.

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...

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...

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...

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

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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*"...