noob

Hello :) How can I get a cell to say, "Over Budget" in the BAD STYLE (red background, dark red text) if SUM of two cells is over value of another... and also to say, "Ok" in GOOD style (green background, dark green text) if SUM of two cells is equal to or under value of another??? Picture...

I am trying to copy from Excel and paste elsewhere, and I am getting quotation marks (") before and after the selected text. Any way to fix this and not get them?

Noob here. I see 2 possible solutions for the same problem. So first i will try to describe it simply with the possibility to get a simple answer. I have 4 drop down list. first list is ALL, feed, treats, equipment. second is ALL, chickens, dogs, cats. Third is jan, feb, mar, ....... 4th is...

Fairly new to VBA and have an idea that I think is possible but need a ton of help. Any assistance would be appreciated. I am looking to create a Random Dungeon Map Generator in Excel with the intention to make printouts. I think I have the steps down but I have no clue on how to do this and am...

Hello, Total beginner in VBA. I`ve been searching the forums without any luck. First of all, let me explain what i did and what i`m trying to achieve. I`m trying to do some sort of attendance worksheet in Excel 2019.. So far i`ve been successful following this video : On the COPY SHEET button...

Every couple of days I add data to column A. After I do, I insert another column A. I would like to see, if at any time, i have duplicate data in 3 consecutive columns.

Good day to all, This is my first post in this forum...:) I am a novice Excel user and I am trying to learn the ropes in becoming a good Excel VB programmer someday. My question is, it seems that my Visual Basic for Applications has changed. I am trying to record a macro and the the interface...

I am setting up a Form in VBA. I have all of my variables and types set properly. The purpose is for units with unique numbers and varying counts. So item number 100 may be made up of 30 pieces. I can have multiple unique items per order. My form gets a total number of items, then asks for each...

Hello everyone, I am pretty new to working with VBA with Excel. I've worked with a bunch of different coding languages but all pretty entry level. Anyways, I have been trying to make an inventory sheet for my place of employment (public library) that can do what we need. I have worked my way...

I have a database I've built. In it, I have a report that displays all of the issued equipment for an individual, based on Inputting their last name. Is there a way to build a macro that would cycle through all of the names in my database and print this report for each?

Good Morning all I'm not usually one for posting on forums bit I'm at my Wits end. I'm a relative noob, well not noob ive got the basics of Vlookup and formatting etc and up to now I have got by. My live file is huge and I cannot seem to delete empty cells which I belive is the reason why...

Alpha Frogs's macro here helped me greatly; (in this scenario I have a list of invalid codes) it find and replaces cells that do match a list of cells (list of invalid codes). If I replace with nothing I'm essentially clearing the cells which is what I needed. sub Substitutions() Dim...

Hi all - I have a sheet (titled 'QRR Template') with multiple columns that users will be populating. On a second tab ('Extract for email'), there is a Command Button where if clicked, it copies the user data from the 'QRR Template' tab and transposes the data from row format to column format...

Hi Folks, Complete VBA Noob here. Been reading these forums for a long time. Finally found a topic I can't find anywhere. I've got a number of frozen panes at the top of a spreadsheet referencing the active row of the same sheet. I've used this code to transpose my active cells to the...

Hi everyone. I'm a complete noob so appreciate any help you all can provide. I'm trying to edit the below code so that when a CommandButton is clicked, it allows me to copy row data from a different tab "QRR Template" and paste/transpose the data on the tab where the button is located. I'd...

Hi! I have a macro (in a module) that saves the workbook. In the startup script i have another macro that loads this macro every 5 mins (This is a macro that "activates" every time i open that workbook) If I close this workbook, and continue to work in other workbooks, it will "open" it again...

Hello! For a school project, we are going to make a machine that will register bottles recycled, and give a prize to random recyclers. We have got a solution that can scan barcodes and paste them into excel in a vertical row. Every student also has a id-card with a barcode on. What we need...

New to working in excel, I need some help! I'm trying to create a macro to match partial string (i've highlighted in red) in column F to partial string in column A. Once a partial string is matched, move column C content to matched row. Please let me know if I need to explain with any further...

Hi everyone, I need to make my checkbox bigger in my spreadsheet. Ive been looking everywhere and I cant seem to find a way to enlarge the checkbox... Can anyone help ? Im using excel 2013 if that's usefull. thanks !

<tbody> 1 a b c d e 2 1 2 3 3 aa ad ag 4 ab ae ah 5 ac af ai 6 7 8 OPTIONS aa af ah 9 10 11 1 2 3 12 RESULT </tbody> I'm trying to make a formula that will help me copy data based on a set of variables. Three options are listed in cells B3, B4...