macro - help

I need help correcting a Macro. I have a sample spreadsheet that I can attach, but do not see how to do that. I want the user to be able to press the "Clear Form" button on any recipe in a recipe pricing spreadsheet and clear the individual recipe. I recorded the following macro with relative...

What I need is a little more than what I could fit in the title the 3 steps are illustrated below and there is a gdrive link for the example file. (I could not work out how to create editable cells in a post; (tried it in a test thread). Put simply I have titles associated with codes. I need to...

Alpha Frogs's macro here helped me greatly; (in this scenario I have a list of invalid codes) it find and replaces cells that do match a list of cells (list of invalid codes). If I replace with nothing I'm essentially clearing the cells which is what I needed. sub Substitutions() Dim...

First time poster here:biggrin: I'm trying to count the frequency of occurrences based on specific date ranges. Here is my current formula =COUNTIFS(MRN,$B2,VisitDates,"<=&6/14/2018",VisitDates,">=&6/14/2018-30") It works just fine with the TODAY function but I don't want it to change every...

Hello Guys, I have long list of data and I want to insert a blank row after every nth row for example after. Below is the sample initial illustration. I need to add starting <tbody> A1 A2 ID Name Score A3 A4 001 BEN 5 </tbody> The data starts in A4 onwards and what I need is...

Hi all I have an existing database in a worksheet, with customers arranged down the rows, and variables for the customers arranged along the columns. I then have a separate worksheet which acts as an 'At-a-glance' page whereby you choose the customer from a drop down list and a series of cells...

Can I record one macro for all processes I need -- (1) Select entire column [Column V], cut it and insert it somewhere else [Column N]; (2) Sort entire sheet according to header "Transaction Type' [Column N now]; (3) Perform Subtotal at each change in "Transaction Type [Column N now] and...

Hello all! I'm new here. So I have a tracking worksheet. I have a date that a client called in column B (Their name is in column A) The calls get assigned and the person to call back, and they will let me know when they reach out. They have two business days to do so. The date returned is...

Hello Everyone, I am looking for advanced VBA Macro for converting multiple excel .xlsm file into pdf files. Below is the scenario : 1. I have a folder called " January" which has 78 excel .xlsm file. Every excel file name is different in that folder. In every excel file, only 1 sheet name...

I have to insert an introduction in my file excel in order to explain how it is working. The file is a business plan so it is not a user friendly. I want a macro that show a text in order to make like a guide. I want like a key that show an introduction text when you click in it. A text that...

HI All I am trying to setup a FIFO (first in first out) sheet for stock. Ideally I would like to have 'CTRL+G' as the short cut to run the macro (currently set to a button). the issue I have is keeping the dropdown list within the ranged cells. my current macro deletes everything, so formulae...

Hello guys, I’m new in VBA and can’t figure out how should I move forward. I’m using the below mentioned macro to calculate different requirements. It works fine if the frequency values in column B are divisible with lowest frequency, for example 100, 200, 400 & 500. However if there is an...

I am using vba code to review and Approve certain row of data using two set of sheets: 1st is "View_Form" where we review the entered data in specific form view. 2nd is "Tracker" where all the data is stored from external download. In "View_Form" sheet we select File ID and all the data relevant...

Hi there, I have a sheet with a text field and a command button to do a search according to the text in the text field. Also I have a reset button. The issue is that when entering numbers or dates in the text field and execute a search, the macro goes to the end of the table without showing any...

Hi Guys, Can you possibly help me out on the codes that I need to use? Newbie here.. I'm aiming to work on the following: 1. Sort by descending order and separate the Zero scores. 2. Next, sort it by Confirmation and separate the N (Confirmation) and add headers as well like those with "Y"...

Hello I work on a reception desk and need to revamp the processes we use I'm hoping that the use of Macros may make this easier, So far I have used a Macro I found on a previous thread to move data from one sheet to another I was now hoping to use a macro to move all data if red to either...

Hi. Scenario - I have a workbook called Master - with a worksheet called Data and another worksheet called Template. In worksheet called Data - I have data such as 1January, Event 1, Event 2, Event 3, 1February, Event 4, Event 5, 1March, Event 6, Event 7 etc., in Column A Template is the...

I am working on a spreadsheet that will send emails and their attachments to any vendor that has a "yes" in row H. The file path/name of the attachment is stored in row G. I can get it to work if I just do one at a time, but once I try to use a loop to generate all emails and attachments at...

I'm just learning macros in excel and I can't seem to get a certain macro to work. I have one sheet named "Master" that has all the data for the macro on it (donor and proposal information). Column A contains several campaigns in which this donor information is linked to. I would like the...

Hi, I have a code that excel has generated from the "record macros" function. It doesn't always execute correctly. 1. Please review the macro and correct any issues that you may find. 2. Is there a way that a macro can include a specific printer and printer settings? 3. is there a way that a...