marco

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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?

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...

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...

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...

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...

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...