macros in excel

Dear Community, I am an MBA Student and I am pretty new to the world of MS Excel Macros. Would greatly appreciate if somebody could help me interpret this code for me. What is it exactly doing ? Sub D10_Common_Unique_NEW() ActiveSheet.Shapes(Application.Caller).Name = "TheOneButt"...

Hello Ladies & Gentlemen, MrExcel Users, I need to help for create a Report Form with macro (Buttons). I am really new about macros. (I don't know anything about it) This form is important for me. It will be amazing helpful to my progress at the work. I am sharing link blow my text for see my...

¡Hola! :) Me puedes ayudar, estoy Haciendo un Formulario Que llena otra hoja, ya tengo las Bases de Datos, ya tengo las fórmulas. Mi Formulario Se Trata de Rutas de viajes y dependiendo la Ciudad hijo Las Rutas y pueden Ser 3 Rutas párrafo Un Destino O HASTA 20, then lo que quiero Es Que Al...

hi..i am very new to excel and with macros as well..but i want to know if I am having a spreadsheet with around more than 1000 products in a single column and a corresponding column with another value and i want to create a list of 10 products from the base sheet into a new worksheet by only...

Hi, I'm a beginner in macros and I'm trying to: 1. Get the latest workbook from the DailyRecord folder. 2. Copy the latest workbook data to another workbook (Record.xlsx) 3. Set it on timer (daily auto update) for now, i only manage to open latest workbook in DailyRecord folder. But i do wish...

Hello! I have this code below applying to one column right now so that I can select multiple keywords from a data validation drop down. I need this to apply to multiple columns. I found a similar query on here but I couldn't get the code to work for me. Please help, see below. I want it to...

I use two different PC computers at work and need to save my Excel macros on my H: drive, and point both computers to the H: drive location. Currently, only one computer can access them. I think the macros store as PERSONAL.XLSB I'm using Excel 2016 on both computers. Any help is much...

I've never used macros before but I've tried a few macros I found online to solve and no success so far. Here's what I'm trying to do: My workbook contains around 20 sheets (tabs). I will choose one to use for this example: For the sheet (tab) named "Mirador" I would like the tab color to...

Hello, I was wondering how to create a macro to subtract 1 from the current cell selected in a spreadsheet? I have a daily summary report that I adjust everyday by subtracting 1 from different cells throughout the summary report. I've tried to record a macro but it puts the location of the...

I have to create a program using VBA. This program needs to create 10 bins from the number 0 to 1 after it creates the bin I need it to count the occurrence (or frequencies) of the bin. including numbers in that range that occur more than once. From the occurrences of the bin number, I need to...

Hi, Was trying to get this working. Cell(17,2) has a date and is being compared to the present date. If Present date is greater than the date in Cell(17,2) it will shoot a mail. Sometimes this code is working good but sometimes its not.. When runs it gives this error after completion...

Welcome, At the beginning I would like to point out that I'm new to macros. It's basically my first day of using this mechanism. I have encountered the following problem: I have this kind of data in one worksheet: <tbody> BACHORZ TOMASZ 1983-10 BARTKOWIAK PATRYK 1983-09 BARTKOWIAK MICHAŁ...

Hello, I'm looking to edit a macros code and I'm having some issues. Right now our workbook includes a growing amount of days on a project (day 1, day 2, day 3, etc.). We have the same employees working each day on the same project. I'm looking to add code to our current macros which would...

Hello there, im experiencing problems in using Macros in Mac OS Excel platform. I actually created a userform on Excel enabling data entry in terms of name, department and costing to be inserted directly on an Excel sheet database as backup but when i try to use the same on a Mac OS Excel...

Hello all, I found a macro to move a row to another tab in same workbook based upon whether there was a particular value. I edited the sheet names and then cell reference range to a column in my workbook. The macro did move the correct rows to the second tab, however, it left behind blank rows...

HELLO I want to transpose selected rows into coloumns and their values under them in different sheet.I want a vbscript or macro to perform the task as data is big. eg; <colgroup><col><col span="3"><col><col></colgroup><tbody> TARIH KOD DOSYA GELIŞ TOPIC RESULTS 26.06.2014 08:07 901020...

Hi All, I am a novice when it comes to excel coding. I work in a advertising/sales company as a graphic designer and the previous owner of the company created multiple excel documents so we could send out artwork proof forms to clients. One of the forms he created so we could print to pdf and...

Hi, I created a macro that copy and paste information into another workbook based on a dropdown selection made by a user. Once the selection has been chosen the user can run the macro and it will copy the information selected into a separate book and formatted. However, if the user then wants...

I am trying to write up a macro that will allow the user to select how many rows they want to add and determine where they want to add these rows. I have been able to add rows after line 40 but can't figure out how to modify it so that they can enter a specific location. Sub AddRow() Dim j...

Hi guys, I wasn't able to find this question in any of my searches so it would be great if you could help me out. I want to create a macro that will copy a set of data (identified by common field, ie. Coffee Type in this example) and replace existing data in a separate worksheet. I.e...