1. L

    Copy data from a changing cell

    Hi, I would like to know how I can copy the value of a cell when its change and generate a list of values. I have this code but only function when I click the cell (B2). Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$B$2" Then Worksheet_Calculate End Sub...
  2. M

    Save Macros for adding data to new sheet and new line

    Hi, I need help with this macro for google sheets. I am creating a form with a save and clear button macro. I want to create a save button macro that allows me to save my data in a specific spreadsheet and every entry goes to a different row in that spreadsheet every time I press the save...
  3. H

    Macros in a protected sheet

    I have a worksheet with a mixture of data entry cells and cells derived from formulas. I want to protect the formula derived cells so I have locked them and protected the worksheet (no password). I have various buttons running macros to perform bespoke filters. These are inoperative because...
  4. G

    excel vba find option

    hi i have a written a macro to search and find set of variables from one sheet( here give as reportsheet) with another (datasheet) and copy value next to it. search works fine if all the search items are in datasheet but if something is not available i want reportsheet cell(k,5)to have value...
  5. D

    Adding a Minus Sign with a macros

    I need to add a minus sign in front of a number in cell G8 and one in H8. Thank you for your time
  6. R

    Excel 2019 macros error: "Excel cannot load two files with the same name"

    Since I upgraded to Excel 2019, my existing macros will not run - they have worked for years on older Excel versions and they DO run normally on my Excel 2019 installation at the office. I use icons on the ribbon but when I click one, I get the message "Excel cannot load tow files with the same...
  7. Dan Wilson

    Controlling print-outs

    Good day. I am running Excel out of Office 365 on Windows 10 Home. I have a workbook that contains seven worksheets. Each of the worksheets has a group of Macros that allow the user to sort the data of each worksheet by different columns. The worksheets contain up to 200 rows with 125...
  8. M

    Formatting Dates from outside software system

    To anyone who can help, Our software system exported data to excel. However, the date formats cannot be sorted properly. I noticed that if I double click on a cell, so my cursor is showing and then press escape, the format automatically changes to a date format that works for sorting. I have...
  9. B

    Show in a cell that the current workbook has macros or macro enabled

    Not sure if this could be formula or vba. Is it possible to show in cell A20 if the workbook is a xls or xlsm?
  10. R

    Macros disappeared!

    Hi I have a reoccurring issue with a daily EXCEL file I prepare. Quite often I will open the file after it has been prepared earlier, and all the macros that were stored in the workbook will have disappeared. Any suggestions for how I can rectify this situation? Kind Regards RUMPOLE
  11. M

    How to create a macro add-in with customized ribbon?

    Please Help! Hello, I have a VBA module with 50 + macros located inside of personal.xlsb. I have customized an elaborate ribbon that links to all of these macros. I am trying to port this setup into a new workstation. I just made a copy of the personal.xlsb and put it in the xlstart folder...
  12. A

    PERSONAL(AutoRecovered).xlsb Problem

    Hello, I discovered something today which scared me. Yesterday I had a PersonalXLSB workbook with a number of macros stored. Today, I saw a Personal(AutoRecovered)XLSB workbook with the same macros but named with the Personal(AutoRecovered).xlsb!macro name. I do not know how this happened...
  13. A

    32 bit to 64 bit Macros

    Let me start off by saying that I am very much a novice to VBA, Macros, Excel and Access. But here it goes. At work we have an Access database and an Excelmacro sheet. They work together and they were both built in a 32 bitsystem. They are upgrading us to Win 10 64bit and Office 2016...
  14. M

    How to transport Customized Ribbon Linked to Macros to another system

    Hello, I have a VBA module with 50 + macros located inside of personal.xlsb. I have customized an elaborate ribbon that links to all of these macros. I am trying to port this setup into a new workstation. I just made a copy of the personal.xlsb and put it in the xlstart folder of the new...
  15. A

    Copy from one Merge Cell into a Column

    Hello, I need a formula or macro to look for a value in one column and copies x times into a different column based on the amount of rows under that value. I have tried Vlook up and some codes but nothing has work. I have the following table <tbody> Grade Name Position...
  16. M

    Help setting fixed values in an amazing macro that splits columns using dialog box feedback!

    I have an amazing macro that uses dialog boxes and allows you to select a column of data, and break it up into multiple columns based on a number of rows you select. Then output those columns starting in a cell of your choosing. Starts as: (I choose 2 rows per column) 1 2 3 4 5 Becomes: 1...
  17. Z

    macros and slicers

    hello, i would like to know if i can assign a macro to excel slicer or not and if yes how. the reason is i need to change value based on selection of slicer like from quantity to amount or percentage.
  18. M

    Macro execution via the RIBBON has stopped.

    Now I get a message that saysCannot run the macro "XXX". The macro may not be available in this workbook or all macros may be disabled." I know the macro works because I can run it out of VBA <macros> and it ran it all worked of the Ribbon a few hours ago. So that leaves "Macros Disabled" as...
  19. S

    Macro to help me transpose this information?

    I searched for a similar situation to mine and didn't see one (apologies if one exists and I missed it!) I have to format a long list of managers and their employees for mass emails, and the lists I get from our database are: <tbody> Manager 1 Employee A Manager 2 Employee B Manager 2...
  20. E

    Sheet Compatibility

    I have a .xls spreadsheet with macros. The macros run perfectly in Windows 10 Office Excel 16 but not in Office Excel 2019 for MAC. Do I have to convert this sheet to run the macros properly in Office Excel 2019 for MAC?

Some videos you may like

This Week's Hot Topics