macro - formula

  1. B

    Copy formula from left to right and point to newly created tab

    =COUNTIF('05-23'!$B$1:$B$5566,"d*total") =COUNTIFS('05-23'!$B$1:$B$4935,"D*total",'05-23'!$P$1:$P$4935,0) =VLOOKUP("Grand Total",'05-23'!$B:$N,9,0) =VLOOKUP("Grand Total",'05-23'!$B:$N,13,0) These are the formulas I copy from left column. After i copy, I want to change the lookup tab to the new...
  2. B

    Need help to do Macro.

    Hi Everyone, Am wondering if someone could do a macro on this to help me to speed up the process. I do following steps when I receive new address sheet to match with old. Old-Data sheet1 Select Colum H [ Phone1 ] Ctrl+F [Find & Replace] [ - ],[ + ],[space],[ . ] (Removing symbols and spaces...
  3. C

    Vba to run macro for multiple excel files within a folder path

    Hello, I want to record a VBA that uses =index,(match),0)) formula into the same cell for multiple excel files. The files will be in .XLSX format and will =index,(match),0)) against a separate excel file. I want this function to work for a folder path containing multiple files Please let me...
  4. L

    VBA code to select & highlight x no. of rows randomly based on the categories in column

    Hi I need random record to be selected from a group of categories in column. Eg- from the table below- I need two names randomly highlighted, from each city type. i.e two randomly selected names from NYC, seattle, toronto and california each. <tbody> Name Class city ABC 1 NYC DEF 2...
  5. U

    Macro Create Sum and Separate Zeroes

    Hi Guys, Can you possibly help me clean up below codes? The range of cells with data is from A:AD 1. Basically starting in AG5, I will create a sum formula from E5:T5 which will be copied down to the last non blank cell (not just till range 681). 2. The macro will hardcode the sum column and...
  6. S

    move to a specific cell based on different value in column A

    i have three columns : department id, names , holiday hours > 10 different department id >n number for names and at the end has a 'total' > holiday hours need to be put in the same row as the total of the department what i need help for? i need a macro in which it looks for the department id...
  7. I

    VBA: Creating a new Workbook w/new sheets

    Hello Fellow Mr. Excel Users, Thank you in advance for any assistance or guidance you can offer. I am using Excel 2019 on the Office 365 platform. I have a master excel file that I would like broken out to separate workbooks, each containing specific worksheets, based on the data contained in...
  8. E

    Macro that creates a Pivot Table - Error

    Hello, I'm a strong excel user with no coding skills. I have recorded a Macro that takes raw data and creates a table then creates a Pivot Table. I am getting an error that I can't explain. Run-time error '1004': Application-defined or object-defined error When I select "Debug" it highlights...
  9. C

    Macro or Formula to Clear Content of Interdependent Dropdown (indirect data validation)

    Hello, I am trying to find a macro or a formula that will delete out interdependent dropdowns. I am a macro noob so thanks in advance for your patience. Right now, I have a sheet that is set up using the indirect formula via data validation to allow the user to select various dropdowns. For...
  10. D

    MACRO for pie chart

    Hey guys keep getting an error msg of object variable or with block variable not set..excel highlighted the string of code that may be giving me the issue I a completely stumped need help! the code is below..any help is appreciated Sub Macro5() ' ' Macro5 Macro ' ' Keyboard Shortcut: Ctrl+e '...
  11. S

    Excel macro to find all that match key not just the first when looking for differences

    I am trying to compare two file. I receive a file once a week. And I need to compare last week’s file to this week’s file. I have them both in the same file on two different tabs. One called Old and the other is called New. I need to look at these two file and see where the Location has...
  12. U

    VBA Lookup Values in Another Workbook

    Hi Guys, I have 2 workbooks on my deck namely Project (source file) and Reference (vlookup reference file). In Project workbook, I need to look for the Value of F in Reference Sheet column B and populate it in G column. Project Workbook: I was able to populate the data in column G using...
  13. S

    Macro to files two fields that match and then find the differences in other fields and move them to new table

    I need to write a macro. I have two tabs each tab has the same type of rows they are just from different dates. I need to look a Sheet A at column C and compare it to Sheet B column C and find the ones that match. If both column C match I need to look a column B for that row and see if they...
  14. C

    Compare and Populate two Sheets

    Hi Folks, I was given an excel sheet today that contained data that was missing a few fields. Sheet1 <tbody> Column1 Column2 Column3 Column4 Column5 Column6 Unique Key1 Data4 Address City State Zip Unique Key2 Data5 Data8 Data11 Data14 Data17 Unique Key2 Data6 Data9 Data12 Data15...
  15. K

    List of URL Images to export and rename

    Hi I have an excel sheet showing the SKU and image URL i need a way to export these to a folder on my desktop (New Folder) i understand there is a way of doing this with a macro and the ones i have found i can't seem to get to work. The excel sheet is Column A | Column B SKU | ImageURL...
  16. F

    Display Row based on Drop down selection

    Hello Folks, I'm new to this community and to Excel coding. Need some urgent help. I'm trying to show specific row based on a drop-down list. Below are the methods I've tried so far but no luck, really appreciate if someone can help! Code 1: Giving Error - Compile Error - Syntax Error...
  17. M

    VBA RGB Code LBound to UBound

    Hi All, this is a most excellent forum with a wealth of information and a wonderful user base! I have learned a lot from this forum, and see many thoughtful answers. I have a macro which I need help with, I'm attempting to display a list of RGB codes to the recent colors section within excel...
  18. U

    Sheet Vlookup with Multiple Tabs

    Hello I'm trying to create a vlook up macro so I won't look up for each diifferent tabs as you may see below. 1. Master Worksheet 2. Reference Worksheet 3 Tab sheets namely - Sheet 1, Sheet 2 & Sheet 3 Master Worksheet - Master Tab <tbody> ID Name Age Subject Score 001 002...
  19. C

    hide and unhide rows based the selections in my dropdown list. Please help

    I am hoping someone can help me. I am creating a form in excel using the active x combo drop down option. I am trying to hide rows based on the option they pick. I added the active combo box in cell B3 with options A, B, and C. Based on what they pick I need the following to happen... If...
  20. T

    Macro wont Run with shorts

    I have a userform open and my Application.visible = False on start up, i want to add a macro that will Application.visible = True with assigned shortcut Ctrl+Shift+Z it currently does not work and have ran out of ideas, any help is appreciated?

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top