excel & macro

  1. H

    Comparing Data from multiple spread-sheets and fish out wanted data into a separate spread-sheet organized per tab

    I have multiple tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my "critical numbers spread-sheet" with wanted numbers per application identified in each tab but columns and rows are inconsistent. I have...
  2. L

    Adding multiple buttons with a macro

    Hi! I'm rather new to excel and I'm trying to make a new workbook that automatically timestamps when a button is pressed. I've learned out to insert a button as well as the basic macro for what I'd like but I'm looking for a way to insert multiple buttons with a macro that works almost like when...
  3. M

    Search for a value in a column, then finding specific values under the first value and coping the data to another workbook of similar headings

    Hi guys, I am very new to this and I would much appreciate any assistance. I have two workbooks from two different software. Both Workbooks have similar headings but we want to replace one line in Workbook2 with more than one line in Workbook1. There are multiple headings, and I am wondering...
  4. S

    Updating Macro to Be More Dynamic

    Hi everyone. Hope you all are doing well. I've been struggling with a macro update for a while now. I'm trying to count cell values ONLY when the column name is like Math, Science, or History. The issue is that the code is somewhat static. If a Math, History, or Science column is deleted, it...
  5. S

    Excel VBA - Loop Through Worksheet, Copy Cells, Paste into New Worksheet

    Hello, I am new to VBA and my knowledge is limited. I will try my best to provide an accurate description, but if additional clarification is needed please reach out. I am trying to create a VBA to accomplish the following: I need to replicate a Master worksheet based on the number of rows from...
  6. jaeremata

    Date format macro code

    Hi Everyone, I need some help in my macro. Currently I have a code that will change the date format to yyyy-mm-dd, but what I want to also happen is to change it on Short date. Here's my attempt: If you can see on the SS, the highlighted yellow is what is showing on the filter but what I want is...
  7. B

    Comparing 2 datasets for reconciliation using VBA

    Hello all, I am looking for a VBA code to reconcile two data sets in Sheet1 and Sheet2 (See attached report). Looking for qty differences between both sheets and identifying if a column A, B or C and have any discrepancies. Can anyone help? Thank you in advance!
  8. C

    Run-Time Error '380' When testing the macro in VBA Excel (Rowsource Property issue)

    I keep getting an error message every time I try to test the macro, after assigning it to a cell in my excel file. This is what the error says: Run-Time Error '380' "Could not set the RowSource property. Invalid Property Value." I've included a screenshot of this message and a copy of my...
  9. W

    Saving excel workbook automatically from vbs

    Hi all, i am currently trying to save my workbook at the end of my script into a one drive location. i have created a file so when it saves it also replaces. Currently it doesn't attempt to save. Please see my below code. (p.s i am very new to all of this)
  10. S

    MS Excel - Macro to Delete particular values in Separate Tabs

    Hello. I am trying to write a macro to do the following. I have a list of values that I would like to find on each tab and remove the entire row of data. Please reference the attachment. Hopefully that will help. Unfortunately my real example ...the tabs will be randomly named with over 100+...
  11. G

    Keep a record of changing cell values in a column in Excel

    I have a column that uses VLOOKUP to bring in values from another sheet. I would like to save the precious value of any cell in this column to the corresponding cell in the next column whenever the cell value has changed. Example: Current values: Cell A1=1, A2=2 If VLOOKUP brings a different...
  12. F

    VBA Code to AutoFill a column based on date

    Hi, I have looked around the net, but I can't find a clear answer for the following. also a linked to excel is attached at the bottom I would like a VBA code that can fill up the cells, and continues filling not start from the begging so it is based on the current date for example if the...
  13. C

    VBA - to change all the source links of linked objects at once

    Hi everyone, I have copied and pasted as link (worksheet object) from excel to powerpoint, but now that i shifted the excel to another location (e.g. from Documents to Desktop), the file source path has changed. Is there any way to change all the links at once rather than clicking each link >...
  14. C

    Userform Scrollbar VBA Excel

    Hello, Every time I data is entered I would have to scroll all the way down to see the results in a userform. Is there a way that every time the value is saved to have the scrollbars go all the way down automatically? Like to show the last row.
  15. B

    Change values in column C based on comparison of previous cells in column A

    I have a spread sheet with "Property IDs" that each have multiple "rooms" assigned to them. I need to change the "Room Name" in a seperate column based on how many times the Property ID has been Listed. Example: I need this: To be this: The reason I am looking for a macro or formula is...
  16. csababenyi

    Insert data with VBA command button into password protected sheet

    Hi Guys, I have an excel speradsheet with 22 coulunms and about 1000 rows and growing with lots of macros in it. There is an ADD command button on the main sheet that opens up a VBA scripted table that have drop downs to select data to add to the next row with another ADD DATA button in it. This...
  17. D

    Excel Macro to print pdf file to location based on cell value and file name based on cell value

    Excel Macro to print pdf file to location based on cell value and file name based on cell value This is the VBA that works, saves the file names based on cell ("Q24") value, but will not place the file to the correct folder, Cell "Q25" has a formula...
  18. M

    VBA copy row in tables down/specific order of adjustment

    I have a excel 2016 file with 13 tables on a sheet. The formulas in the 12 last tables are depended to the first table. Now I'm trying to create a macro to add a number of rows to all tables at once. I got this to work, but it is not starting with the first table. this creates a "gap" in the...
  19. S

    Excel2010 VBA for reminder Outlook2016 emails, three months before review date

    Hallo, I'm an admin and VBA newbie, trying to send automated reminder emails from Excel 2010 via Outlook, three months before the review date (in Column C). I've managed to send an email from Excel :) But can't get any further, have tried the YouTube videos but am baffled and was advised to try...
  20. A

    PLEASE HELP!!! Can Not Get Formulas To Work??

    I need to know what the VLOOKUP FORMULA is for moving numbers between these 2 sheets because I can not figure out the formula myself. I have tried all day, and I can not get it. JUST LIKE IT SHOWS IN THE SCREENSHOT ABOVE. I have 2 sheets named "Testing Day 1" and "Month 1 Week 1". I want to...

This Week's Hot Topics

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