marco

  1. B

    I have this marco that i need some help with.

    how do I get this marco to stop if there is no value in cell E3. Then let the user know that they must first enter a value in cell E3 before the marco will continue. answer = MsgBox(prompt:="Does CASH IN or CHIPS equalCHIPS OUT", Buttons:=vbYesNo + vbCritical, Title:="Update DaysValues") If...
  2. B

    Help with a marco

    I have a marco that copy's the numbers from A1 and B1. then pastes them on another sheet. I want to write into the marco that if "A1 does not equal B1" the marco stops working until the 2 cells equal each other. thanks in advance for all the help.
  3. U

    Marco to Paste data next to a to blank row

    Hello Mr. Excel members! I am stumped with a Marco need. Here is (what I think) is a similar macro I already have: Sub AddRow5() ' ' Cut_PasteSpecial Macro ' ' Range("C5:S5").Select Selection.Copy Sheets("Presentation for Approval").Select Range("A1:S1").Select lMaxRows...
  4. D

    VBA, search in range of data and then copy and paste

    Hi Guys, I'm working on a extremely tedious project and my hands are about to fall off :help:. So to give you an idea of what I'm doing, check out this GIF: (Note: In the GIF: there are more columns to fill out) So I'm not sure if there is a VBA possible for filling out all of the...
  5. D

    copy tables, then transpose and paste into other sheet.

    hi everyone, I'm not the best in marcos and I've been searching for a solution to this for a while. So what I'm doing is copying a table in a worksheet into another worksheet and transposing it. Some worksheets that contain the original tables can have a lot of tables which is way a marco...
  6. T

    Dynamic map of the netherlands based on colors macro

    Hi, Can somebody help me with this macro? I made the Netherlands with shapes of the provinces. I want each province to get the color based on the range in the second sheet. I already made the file, you can download it with the link in this post I copied the macro of this video...
  7. D

    Excel 2016 - Auto Insert Row with Formula Based on Cell

    Currently have a material tracking workbook which uses a table for organizing. I am hoping someone can help me with producing a code in marco which will insert a new row to "cancel" a specific item by showing the negative value underneath...
  8. M

    How to run loop for only one task

    I have this code, which inserts "Department 75" in a cell if criteria is met but the problem is that the macro is applied to all lines that meet the criteria which is if rows contain "Source Total" insert row another row and insert value "Department 75". Is there a way that this macro only...
  9. X

    Macro For Excel Text Limit & Conditional Formatting Formula

    As excel has a 32,767 characters limit for per cell when applying wrap text. I am facing issue identifying the ones (out of tons of data) of which has exceeded the character limit. Is there a Marco script that will allow the following to be done? 1) When cell text exceeded 32,767 characters...
  10. V

    Find and Replace Macro for Textbox from External Source

    Hello, I have a large chunk of text that I need to find and replace a bunch of different values within. I have one file with columns for the find and replace values. I'm setting up a text box in a separate file that I will paste the large chunk of text to search through. I need the macro to open...
  11. M

    better control of a change event

    Hello, I am working on a macro and I have it doing everything I want it to do except one thing. When a change event happens, it continues the loop to the last cell on the worksheet. I am trying to make a calculation happen and the field change color when a a cell is changed, which it does...
  12. B

    MS Excel 2013 Macro Runtime Error 1004 on Formula FillDown

    I am failing to find how to make this new macro run smoothly in other worksheets. The code fails when I copy down the clean formula to the bottom of the column (underlined and in Italic below). I have gone through the forum and sorry, but I am not seeing a solution to work. Thanks for any clues...
  13. S

    Making a Marco run continuously and on different files over time

    Hello, for this project I'm working on in VBA it requires me to use a marco to interpret data from an excel sheet. However, this sheet is to be updated over time and I need a way for the marco to run when the file is saved, or at least at a consistent time with it. Is there any practical way to...
  14. L

    using macro to check data in table

    hi everyone ! i need help on the codes that can be used for the project im doing now :( im new to excel and im tasked for this challenging project. i sucks at it so please help :( for example : i have 2 tables. table A and table B table A stores the years, category ( apple or orange) , the...
  15. S

    CTRL + Shift + Down in a Macro?!!?

    This is the one that it seems how many forums or formulas I try I can't figure out! I always have various ranges that, it could be 1 row down or it can be 100, how do I make the macro figure out far to go?
  16. A

    Relative location to open word document

    I have an excel document that opens and pastes stuff into a word document This code works like a dream Set wdDoc = .Documents.Open("C:\Users\Adam\Desktop\Sample_template.docx") But i would like to be able to move the excel file and word to a dropbox folder and use on any PC so I tried Set...
  17. R

    Editing Trusted Centre File Blocked Settings

    Hi, I am attempting to change trusted centre setting with VBA, to allow read/write to Excel 2 format files. Basically, it needs to do the same thing as this: https://support.microsoft.com/en-gb/kb/922850 I read some article about accessing Registry but my company PC's registry is locked for...
  18. E

    Macro to create duplicate rows based on the value of particular fields

    I need to create a macro that allows me to: 1) create duplicate rows based on the value "x" being present in a set of columns 2) once created, remove those referenced columns and replace with a specific word Country | Hot | Cold | Windy | Icey England today is | | x | x | | Should yield 2...
  19. C

    Macro to hide cells based on contents in previous tab

    Hi there I have a spreadsheet where users can enter details of multiple clients and it will pre-populate forms based on the number of clients entered. I only want 3 forms to be pre-popped if 3 clients are entered, 30 if 30 are and so on. I want a macro that says if a cell in column A of tab 1...
  20. P

    Excel Macro print button

    Hi guys, pretty new to excel and really appreciate any help/advise offered. I have a workbook with 30 worksheets referencing off a master(worksheet) for some of there data. I would like to tick a checkbox on the master(worksheet) push my print button and have all of the selected checkboxes...

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