bulk

I have played around with some VBA options but I’m not able to get what I’m looking for. I need to print individual certificates in PDF format, from the list within the same excel file. Each line in the list should be an individual certificate. The resulting PDF file naming should have the...

I have a spreadsheet as below. Is there a macro that will open my email client and send an individual email in bulk to all in the sheet? Thanks <colgroup><col><col span="2"><col></colgroup><tbody> Body 1 Body 2 Title Email JMatear sdgdfbxfb Login Details example@gmail.com JBrowning fsfbdfb...

Here is an example of what I have and what I would like to accomplish. <tbody> OPEN WORK REPORT Period NUMBER WORK ORDER DESCRIPTION TYPE 25524484 ACCIDENT accident rollover Period NUMBER WORK ORDER WORK ORDER DESCRIPTION TYPE 25858720 BULK ISSUE Bulk...

Hi all, hoping you can help as I'm a bit lost with this. My data has several columns of information regarding deliveries, the dates they were made and if all the items ordered by the customer were in the delivery. I need a formula to check the data and put a value of "bulk" if a delivery with...

I work for a company that packages numerous products with different brand names. Sometimes we package the same product under a different brand name but the Lot number, expiration date, and product code are still the same. Because of us packaging product this way, this is considered a split lot...

I am currently using a password protected spreadsheet that someone else created at my work. The problem that I am having is that I can't format a cell with the number format option on the Home tab. It is greyed out. I have a userform that the user will enter in a product code in text box. When...

I have below columns and want to organise image urls from column B in columns D,E,F,G etc as per their position. How can I do this in bulk. Please help

Hello All, So I create product upload CSV and each product has a different choice such as a Size, Unit, Color, Size and Units, options etc. These choices are all on different columns however I need to consolidate all into one column at the end. The reason because I need to upload the choices...

Hello All, I'm new to this forum so I hope I am posting this in the right local. I'm at my wits' end with a macro designed to pull from Access. I'm receiving Run-Time Error '1004': Application defined or object-defined error The debugger selects ".Refresh BackgroundQuery:=False" at the...

Hi, The spreadsheet I am using has 3 orders which make one bulk order. The 3 orders have 3 different finish dates. Is there a way of putting on a vlookup formula which then chooses the highest date (this is to create a pivot table). For example: Order Finish date Bulk order 1...

How can I pull certain text from a string using an fx? In my target column I only have two different sentences. OSV to Bulk Anodize OSV to Rack Anodize depending on which one it is, I only want to extract either the Bulk or the Rack text. How can I do that?

Hello, I'm looking for a way to create 80+ distribution lists in outlook and include contacts in those groups. My data looks like the below. I would need to create a new distribution list(contact group) in outlook based off of the name in the DistList column and add new contacts to it. For...

Hello, I'm looking for a way to create 80+ distribution lists in outlook and include contacts in those groups. My data looks like the below. I would need to create a new distribution list(contact group) in outlook based off of the name in the DistList column and add new contacts to it. For...

Hi, My first post in this forum, so please be gentle. I have a client that has a workbook of c700 spreadsheets for which I have found a code to seperate the workbook each month into individual spreadsheets and then save in a folder and distribute accordingly. I am now looking to encrypt a...

Hi I have Multiple Entries of Same Bulk Code in Excel Sheet I'm looking for VBA Code with the following Condition If one entry of bulk code contains Intermediate against it in Material Type, for all entries where that bulk code appears, display bulk received as YES(See Screenshot)...

<tbody> "OSV TO BULK ANODIZE RED" </tbody><colgroup><col></colgroup> What fx can I use to get rid of the "OSV TO " and only show the rest.

Hey everyone, I hope you are able to help! I am using Excel 2016 + Windows 10. I am trying to merge two web queries which have three common columns (Date, Campaign Name and Ad Group Name) please see below for the tables and desired outcome. I tried doing a full inner but I end duplicating the...

hi everybody! i am having some trouble in using pivot table after a few years break so so if anybody might guide me what am i forgetting i am working in garment cutting and for every new order i have to maintain a record of the measurements 1: cad pattern 2: first garment 3: first garment...

Hi! I’m hoping for a macro that can: Start in A36 of the active worksheet and continue downward, stopping when it reaches a blank cell (ideally, it could do this at once for all selected worksheets, if multiple are selected.) In each of those applicable cells, insert a hyperlink to the...

I have a ton of invoices I've extracted from a couple of email addresses that I then turned into Excel documents with the Able2Extract PDF to Excel convert. The problem however, is the data looks like this: Untitled-1.jpg And I'm wanting it to have one big excel sheet with multiple columns...