excel macro

I have 2 workbooks. One is a Bill of materials (Bom) and the other is a master list (Ml). My bom takes the Ml as a connection, manipulates the data through power query and spits in on a new worksheet in the Bom workbook. I then open a new sheet (within the bom workbook) perform a vlookup and...

Hello, I have the following sheet that when the user saves it then copies to an email but it is cutting off the last few columns. The VB code I am using is as follows: Sub CreatePNG(Namesheet As String, nameRange As String, nameFile As String) 'ThisWorkbook.Activate...

I am a beginner trying to maintain my business data using Excel. I created a macro that copies the information from a sales info table and pastes it into an adjacent table that records the customer's name, items bought, total sales, etc. But when I rerun it the next row is not being used and it...

Excel File Download Link I'm looking to generate a 2D line graph across multiple worksheets with varying amounts of row data. I need help creating the same type of graph depicted in an image for each worksheet. Could someone assist me in developing a macro code to achieve this task across all...

Hello, I have created an excel sheet which have two textboxes "username" and "password" as a login system. I did not use the visual basic form to design. I have only insert 2 textboxes on the sheet and a picture as a login. if i click the picture it should login. its checking the password and...

Hi, I've been at this for hours, and for some reason even though my .oft does not have a signature, when I generate an outlook email from my .oft using vba, it adds my default signature to the bottom. Any ideas on how to remove this? I've tried every variation of code found online. thanks! Sub...

Hello, The below macro is assigned to a button on the ribbon and works on the "current 6 months" sheet. It looks down column B for "terminated" and deletes the row. It's currently restricted to only work on "current 6 months" sheet. Is there any way to add another sheet "Previous 6 months" to...

Need help with macro to perform following task. 1. I have a file (Original file) with 5 sheets (Index, Report1, Report2, Report3, and Report4) 3. Colum C in Index sheet contains list of sheets which are to be sent for printing to the default printer (e.g. it contains Report1 and Report2 in...

Need help with macro to perform following task. 1. I have a file (Original file) with 5 sheets (Index, Report1, Report2, Report3, and Report4) 2. Colum B in Index sheet contains list of sheets for which pdf file is to be created (e.g. it contains Report1 and Report2 in cells B1 and B2...

Need help with macro to perform following task. 1. I have a file (Original file) with 6 sheets (Index, Report1, Report2, Report3, Report4 and Data) 2. Report1, 2, 3 and 4 sheets are linked through formulas to 'Data' sheet 3. Colum A in Index sheet contain list of sheets to be copied to a new...

I have tried my hand at macos, and what's left of my hair is starting to fall out... could anyone help me with a macro to unconsolidate an excel file? If it was only a few I would just do it by hand, but I'm filling in for a co-worker who quit and this is nothing that I've done before, I'm in...

Hi, I have been using a macro I found in the forums (written by pbornemeier) to generate all possible combinations from multiple columns and remove duplicates having the same value in the same row. Is it possible to add functionality that would also remove row duplicates where the values are...

Hi, I came across a similar thread VBA to copy range data with all visible and invisible cells to another sheet on MrExcel.com and was hoping to get some assistance on my scenario which is as follows: What I have on a tab (name: origin) Station People Cars A 12 29 B 6 10 C 4 2 TBC...

Hello, Fabrics are to be cut to certain sizes. Example; 24 pieces of 225 cm 32 pieces of 175 cm 88 pieces of 150 cm 24 pieces of 75 cm 32 pieces from 50 cm 80 pieces from 35 cm These require 304 meters of fabric. One ball of fabric is 6 meters. 51 balls of fabric is enough without any loss...

This is my Input File......... and this is the template file all the data will get fill into this template file.... But main scenario is ... For first Employee there is no data in HRA column so then it will remove HRA from Salary slip template file For second employee there is no data in...

This is my scenario I want to pass the values from sheet2 to sheet1 according to ID...in here from sheet2 id= 1 data=a will go into the sheet1 id=1 data column.... This is my expected output Is there any possible way to do this in excel using macros? Can anyone help me with this?

I am trying to print the dates from 1 march to 16 march it's giving me properly dates till 12 march in "MM-dd-yyyy" format but after 12th of march its giving me wrong format.... I tried to remove the time manually but its giving me in the format of "dd-MM-yyyy" actually i want all the dates...

Sub test1() Sheets("FinalData").Select lastCol = Split(Cells(2, Columns.Count).End(xlToLeft).Address, "$")(1) Range("A2").Select Selection.End(xlToRight).Select ActiveCell.Offset(0, 1).Select ActiveCell.FormulaR1C1 = "Running" ActiveCell.Offset(0, 1).Select ActiveCell.FormulaR1C1 = "Cycling"...

Hi everyone I'm just having a sorting error in my excel database. When I click the sort data button - this error appears: ActiveWorkbook.SaveAs Filename:= _ "https://glennonbrothersgroup.sharepoint.com/sites/DTE/Projects/Programme/DTE_Programme.xlsm" _ ...

Hi, Thank you for reading this post. I need your help. I have some data an excel.. let's say column A has clients name and column B has clients email address. Column C sales figures. What I want is that I want to use excel macro so that 1) I can send email to each clients individually. 2)...