macros

  1. A

    Macros for cleaning excel file

    Hi This is the original file for which I seek your kind consideration. This is the desired output file I need your kind gesture and help to get the output file with the following parameters Delete Column A ,C, D ,J,K,M,O,and P to AH completely. After the given columns are deleted I request...
  2. C

    Running Data Refresh Macro, then Table Update Macro, Back-to-Back?

    I have two separate macros in my book: one that refreshes 12 tabs containing CSV data that points to a source outside the book (and which itself receives updated numbers each day); and one that updates data tables in other tabs in my book that rely on these 12 CSV-data tabs to be refreshed. The...
  3. A

    Auto Update Sheets in Scheduler file

    Hi Enclosed is the Scheduler file. I request you to kindly help me with the following by way of a macros. 1)I have added a scheduler till 25-Jun-24--30-Jun-24. 2)However I request a macros where the same worksheet mentioned above is created but with the first working day(Monday) to the last...
  4. C

    Loop validation, copy output from same range and paste in different ranges

    I'm trying to loop through 10 scenarios via a validation list. On each scenario the calculation engine provides an output in a fixed range. The output needs to be copied / pasted onto a dashboard sheet going down the row with fixed distance (so the dashboard sheet will have 10 sets of output)...
  5. I

    Move multiple rows from one table to another using conditional trigger

    Hello, Here is the issue I am having, I built a workbook containing several tables, each table on their own sheet. The purpose of the workbook is too assist with tracking of patient lines. How the table functions is that when a new line is placed on a patient, a staff member will add that...
  6. S

    VBA: Am I double-calling a Sub given nested If statements? Or other inefficiencies?

    Hello, I'm new to VBA and trying to make a custom Dashboard for a manager. Below lies my attempt at creating a data refresh and save macro that will be tied to a button on the "Dashboard" sheet. My main question is: Am I actually calling the RefreshData() sub twice in WriteData(), thereby...
  7. A

    Subscript out of range vba error 9 excel, but it works on other laptops

    Hello Everyone, this is my first post in this community, I have this very weird problem regarding on the Macros files with excel, basically, there is a file using Macros working on my laptop, but I can't make it work on other laptops, those other laptops have the same office version, and even...
  8. D

    Create totals using drag down

    Good Afternoon Could a formula be created to count occurrences of values in ranges and list the occurrences at the conclusion of values in column a. example - looking for a total count of Crits would find 2 values that fall in the Ranges value of 900-1000 [the ones showing 1000] Next looking...
  9. K

    10 Buttons (Shapes) only first 9 work. #10 does not.

    I have a POS that is using 10 Shapes (Categories) as buttons. I have a Macro to call the Subcategories. It works for 9 of the buttons, but not 10. Sub POS_LoadSubCategory() With pos 'Remove any existing product shapes For Each ProdShp In pos.Shapes If InStr(ProdShp.Name...
  10. R

    Macros in unrelated files started crashing around three weeks ago and we cannot figure out why.

    Our company uses Office 365. We are using macros in around 15 unrelated areas of my workplace and suddenly, after years of working perfectly, they seem to be crashing randomly. This started a few weeks ago, and more and more files are having the issue. For example, there is a file used daily...
  11. D

    Macro to plug one set of information into multiple sheets

    Hello All , I have taken interest in excel VBA recently and am trying to learn and apply some optimizations to my daily excel workflow sheets. I have an excel table which has date that is replugged into multiple sheets in my workbook. Instead of pluging them in each table. I would like to find...
  12. W

    Macro to Copy Content

    Hello all, new to macros here, but this one has me extra stumped. I want to copy two cells (B21 and B23) in Sheet1 and paste the numbers into Sheet2. The catch is the figures being copied need to be pasted into the last empty column in Rows 2 and 3. The copying and pasting isn't so much an...
  13. C

    workday help

    I've been trying to update some old spreadsheets that add 30 days to a date to instead use workday to add 30 working days. I've managed to convert my old dates into the correct dates using workday however, when I do it in that order it completly messes up my pivot tables later. Is there a way of...
  14. A

    Need to create a merge document for each entry in word using excel

    Hi I have this document with all the students marks for a given term. The same can be accessed here https://docs.google.com/spreadsheets/d/18z-l-RLOcf069-3txj_4YwQ6OXALHL_4/edit?usp=sharing&ouid=105636336571610671345&rtpof=true&sd=true What I am trying to figure out that if there is a way in...
  15. A

    Create a merge document for each entry in word using excel

    Hi I have this document with all the students marks for a given term. The same can be accessed here https://docs.google.com/spreadsheets/d/18z-l-RLOcf069-3txj_4YwQ6OXALHL_4/edit?usp=sharing&ouid=105636336571610671345&rtpof=true&sd=true What I am trying to figure out that if there is a way in...
  16. P

    How can I copy comments to other sheets in a workbook using VBA

    Hi, I have a workbook. First sheet has dates September 1st 2023 to September 30th 2023 (a2 to a31). I have 6 comments in each cell of each row. (columns B,C,D,E,F and G). The next 30 sheets are for the thirty days of September, titled September 1st 2023, September 2nd 2023 etc. Using VBA I want...
  17. C

    MACRO: Hiding rows when blank and providing responses for other conditions

    Name Status Email Status2 Comments Carrier Chk1 James Smith Provisioned JamesSmith@gmail.com REGISTERED Luke VzW Christopher Anderson Disabled ChristopherAnderson@gmail.com PENDING VzW Ronald Clark Disabled RonaldClark@gmail.com REGISTERED VzW Mary Wright Provisioned...
  18. Q

    Macros help on multiple files to be created from a set of large data

    Hi, I have a large data set on one sheet. The raw data file is about 40MB in size. I would appreciate your help in completing this as I have run into issues in preparing this report. Honestly, I feel very overwhelmed and scared of using macros 🫣 My Apologies I am unable to add XL2BB to my...
  19. M

    Workbook Event Macros Triggering in Other Workbooks

    Hi I make fairly extensive use of workbook event macros such as Workbook_Open, _Activate, _SheetCalculate, _SheetChange, _SheetSelectionChange and Worksheet event macros such as Worksheet_Activate, _Change and _FollowHyperlink. These work great except occasionally and very intermittently and...
  20. brendalpzm

    Copy and paste formulas from a workbook to another without reference with VBA

    I have 3 workbooks, one of them (wb1) has a vba code that copies some formuled cells (a1:c23) in a worksheet from wb2 and copies them in a worksheet in wb3. The thing is that the formulas copied in wb3 are referencing the wb2 instead of wb3, how to copy without this reference?

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