beginner

Hi I'm a beginner with VBA, now I want to select a something on a row, in this case row 2. But the row where my ActiveCell is varies, so I can't do Offset(-10). Also the column is different every time so I can't just get one range. I'm a bit confused, maybe some of you can give me a hint what...

Hi, I'm very new to VBA and I want to make an if statement is the selected cell is between two rows (between 6, 10 as an example). Only I can't figure it out, I'm used to more different types of programming languages (Python, PHP, JavaScript) and with those I never really had issues but VBA I...

Hi, I need to calculate the rest time between the end of a shift and the begining of the next one. What formula would I need to use to calculate the elapsed amount of hours/mins between C2 and B3?

Hello, First of all, I am still new to VBA and more complex excel coding, so I'm learning by doing, searching forums and tutorials, stitching together bits and pieces of code I need. However, I ran into a dead end and would need help. Basically, what I'm trying to do: I have a project to sort...

Dear All, I am beginner of VBA, I wanna create a VBA that can remove deplicate rows if column A as duplicate and referring to Column B value. For instance, pic. 1 is raw data, pic. 2 is the results that I wanted. From pic.1 , there are 4 duplicate groups (ABC123, AD12, AA12, mm). 2 things I...

Hi All, I'm having an issue with one of my spreadsheets where if I apply a filter to my table and then attempt to add a new row using a macro, I get a run time error which I cant seem to get passed! Note: the spreadsheet must be able to add a new row whilst the table is filtered (the table...

Hi everyone! I am relatively new to using macros and have been having some trouble using macros to compile data into a new excel sheet. My goal is to have a sheet that looks as follows: Item Name Measured Value Source File Name A X Patient1.xls B X Patient1.xls C X Patient1.xls A X...

I currently have multiple excel spreadhsheets that look like this: The table is a questionnaire with answers from column C-F, C is the "worst" (letter N as in Not good), D the "second worst" (letter T), E the second best (letter W) and F the best (letter G as in Good). To the right of this...

Hello all! I hope to find you well. Once again, this newbie to VBA will ask for your help. I would like to hide certain rows, based on a form control checked or not checked. In sheet "Part1", one will select, in column A, which Products they own (can be more than one). On the sheet "Part2"...

Hello! First of all, wishes of a Happy New Year! I am new to VBA and I'd like to ask for some help. In sheet 1, there are several options that one can choose (A, B, C and D). More than option can be choosen. After that, I would like that in sheet2, only the choices made in sheet1 appear in...

Hi, I am creating a Glossary for a table with a lot of descriptions of certain activities. I want to be able to type in a cell a value and click the comand button to filter automatically instead of in the Pivot filter. I tried with this code but keep getting an error on the highlighted code...

Hi All, I need to make several hundred excel files which all have the same layout with different information (I.D. Cards). I have resolved all time consuming issues except manually changing the picture for each person. My idea is to write a macro and assign to a button that does the same thing...

https://www.amazon.com/s?k=disposable+mask&s=date-desc-rank&qid=1582037377&ref=sr_pg_1 https://www.amazon.com/s?k=disposable+mask&s=date-desc-rank&page=2&qid=1582037242&ref=sr_pg_2 i tried a vba code to extract the ASINs from the above links for past two days however since im a beginner i...

Hello and thanks to anyone who thinks they can help me. I'm brand spanking new at VBA and I'm try to create a Macro so that I can transfer data from one sheet to another. The information is the same on the next sheet except I add another column which you can see in picture labeled #2. I was...

I am extracting data from two different vendors, the data I'm extracting should be the same, however a quick glance indicates it isn't! For example, lets say one file contains a list of 1000 students' names. The other file contains 987 students' names. What's the best way to cross reference both...

Hi all! I have been trying to write VBA macro to simulate the keystroke (Ctrl + Alt + v + f) to copy and paste formula from an excel cell. I'm a beginner, and so far I've been able to develop the functionality of copying the formula and pasting it relationally. However, the code breaks if it is...

Hello, I'm creating a User Form and trying to get the starting position of a Combo Box to be the number of the month. For example since it is currently July I would like the Combo Box to start on position 6. When I try this varToday = Date varToday = varToday - 10 'this is purposeful...

Dear All I have two sheets with some information on skill level of a team and with year of experience. Machine_A sheet is summary of no. of skilled person. Machine_D is sheet of data base. Let us assume i have 10 expert engineer in machine installation category. Machine_A sheet shows no. 10...

new to mrexcel but would like some help putting together a golf league scheduler for a 40 player / 20 team league. 18 total weeks. am new to formulas in excel and a general beginner but use excel daily but not to its full potential. want to learn more. thanks.

Hi all, I literally started learning VBA 3 days ago, using excel-pratique's VBA course but as I'm trying to be thorough I started to make a "dictionary" and I'm writing up the different selections that are possible. Could someone send me a working code for: Select entire Row AND entire...