beginner

Hi guys, my first time on this site, hope everyone is well. I started paying around with the match and index function on excel, and i almost got it to do what i want. I have a small issue, hoping you could help me out with it. This is what i have so far... <tbody> set 1 #1 set 2 #2 where...

Hi friends, I am a beginner to VBA. I wrote a code to basically compare two sheets of data by their brand name in column A. When they match, I want to subtract the corresponding values of sheet 1 and sheet 2 for same brand. I am using this code. Please help , it is giving a Next without For...

Hello, I am an avid excel user. I love taking a business problem and creating a custom solution. I am fairly skilled in excel, anything from creating macros, to using functions, pivots, etc... I wish I had an understanding of VBA. As it stands today, if I want to use a macro, I record...

First I am wondering if it is possible to insert text into a new cell if conditional formatting conditions are met, and second if it is possible to require two conditions be met in order to insert the text in a new cell. I am trying to have say column C rows display an "X" if the column A = 10...

Good evening all, any help appreciated. I am rookie status with Excel programming and it has been a couple years since I have done anything, so forgive me... I am trying to find the simplest way to add data obtained in a form (via user entry and button click) to the next row in a worksheet...

Hi, I'm not great with Excel so any help is appreciated. Right now I have a fairly large table with each row being a separate inventory item and each column being a quality of that item. For instance (this is not the data): Seats Tires Floats...

Hi Everyone, I have researched the site, and I am still trying to figure out how to use VBA to accomplish the 'vision' that I have. The knowledge that I've gained from the board has enabled me to code some of my program, but there are certainly a couple of major holes. Nevertheless, thanks to...

Hey. So I am using this code as a macro in excel to colour the mentioned cell when the value of b9 is in the appropriate level range. However it is not colouring the proper cells, it seems to be colouring only B11 So the levels are 0-18.49 color cell B11 18.5 - 24.9 color cell B12 25 - 29.9...

Hey all, I am progressively working on an Excel Tutorial that could be very useful for beginning users of Excel and possibly for some early-intermediate users. The original reason for me creating this file was so I could hold a few meetings with my department to teach them some of the basics of...