1. distiDoestoe

    How do u get the value in a specific row, but in the current column?

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

    If statement if cell is between 2 rows? [Beginner]

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

    Calculating time elapsed in Hours/Min/Secs between two periods

    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?
  4. S

    Sending email based on cell value

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

    Remove all duplicate rows if column A as duplicates but refer to column B

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

    Can I add a new row to my table using a macro whilst my table is filtered?

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

    How can I post sources file name next to source data pasted into compiled workbook

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

    Expand existing Copy-Paste Loop: Loop through specific Columns based on Cell Value - Questionnaire

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

    Alternative to Select Case

    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"...
  10. C

    Hide rows in a sheet according to selections on another sheet

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

    Filter Excel Pivot Table based on Cell Value

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

    Using Macros to "Change picture"

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

    VBA code to scrape Product ASINs with page number from website. i tried a vba code to extract the ASINs from the above links for past two days however since im a beginner i...
  14. M

    Move Row after certain cell filled

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

    Looking to learn a formula to help me with...

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

    VBA Macro shortcut to "paste special formula"

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

    ComboBox Property will not change value

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

    Pop up window when click/double click a cell

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

    golf league schedule 20 teams of 40 players

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

    Relative cell reference selecting enitre row and entire column?

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

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