1. 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...
  2. 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...
  3. 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...
  4. 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"...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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.
  15. 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...
  16. chris-in-cal

    Improving my skill

    Hello, I joined this forum in 2007. Back around then I took an intermediate excel class and I enjoyed it. My work at that time had me maintaining a couple of spreadsheets. this place was great. I haven't opened a spreadsheet in a decade until earlier this year. Now I'm managing some data on...
  17. M

    Access query - multiple tables but same column

    Hey everyone, I am a complete access beginner so I apologize if this is a no-brainer / a dumb question. I have two tables. One called MasterRepList and MastetTechList. In both of these tables, I have a FirstName, LastName and UserID field. (The MasterTechList calls this field TechID) --...
  18. J

    Excel Beginner Question

    All, I will use column A and B as the columns I want to change: I want to make column A Red if column A is not filled out but column B is filled out. But I want to leave column A White if Column B is not filled out. I have not been able to figure that out.
  19. N

    Good idea? Maybe?

    Hello All, So I joined this forum back in 2016 and since then have learned SO MUCH INFORMATION that has helped me and now I am able to help others that were lie me before i joined here. It has been an awesome ride and I really enjoy it. With that being said I have been thinking about making a...
  20. A

    Run-time error 424: Object Required

    Hello, I am an excel beginner trying to make a UserForm for data entry. I made the UserForm and had it working, then accidentally saved the file as the wrong format and had to make a brand new one. I was able to copy the code and add it into my new VBA with all the same box names, but now when...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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