create

I have several lists named as ranges and want to create a single list of all the unique combinations of items on those lists with a formula ideally: For example, if I had three lists with the following values: List 1: A, B List 2: 1, 2 List 3: X, Y The formula would create this list: A1X B1X...

Hi, I'm new to vba. for my work requirements I need to create a vba to create a MapInfo Table and Points. so far I know is only "CreateObject (Mapinfo.Application)" :( please guide me for this.

Hi all... me again *sigh* I am trying to create a macro that will create a 3d-reference to another sheet - all references need to be added to the sheet 'Reminders' and will be based on the values in the active row on the active sheet. I kinda had two macros that did bits of what I wanted and...

Hi, I need to transform a raw extract into a new sheet for a pivot source. The raw extract has transactional information + check-in and check-out as shown below: <colgroup><col><col span="2"><col><col><col><col></colgroup><tbody> LISTING'S NICKNAME CHECK OUT CHECK IN SOURCE ΣTOTAL PAYOUT...

Hello all, I am trying to create a formula in which for example, if C5<=0, show the value "N/A". Ff C5>0, then calculate the formula of C5/B5. Can anyone help? THanks! Greg

Hi Everyone, i have a code which create workbook into the specific folder. however i want to create multiple folder by the date name: for example code is ActiveWorkbook.SaveCopyAs "D:\TEMP\XXXX.XLS" so i want, this XXXX file name should depend on A1. where we would have date. so i can...

Hi All, I'm after a macro that will loop through all the rows in column A on an excel spreadsheet and create a powerpoint slide for each one and put the value from the cell on the slide and insert an image according to a specified filepath in column B. E.g. Create a slide tittle "Apple" from...

Hi, So, I'm having a rough go at it trying to create a calendar without manually entering every 26th row. I am attempting to create a 15 minute calendar for Stocks. For example: COL A 9/3/19 9:30 AM 9/3/19 9:45 AM = WORKDAY(A1,1,[holidays])+15/1440 9/3/19 10:00 AM =...

Hi, I'm having an issue with making a macro that creates a new worksheet for every unique combination of 2 columns (Category and procedure). All the worksheet will then have a "form" with all the columns related to that combination. Is there anybody that can help me? Thank you.

I have a table that has multiple columns formatted as dates. When I try to create a Pivot Table and insert a Timeline Slicer, it is only giving me the option to use one of the columns (Reworked Date) and it's not the one I need (Date Initiated). The purpose of the Pivot Table is create a report...

Existing data is Sheet4!E2:Sheet4!E700 and appears as below: <colgroup><col></colgroup><tbody> Retailers PO 9608561996 blank blank blank blank 5008561749 blank blank blank 4908561680 </tbody> I need to pull it to another sheet (column A) but skip the blank rows. I have...

I have a questions I hope you can help with. I have an attendance time card in excel for a group of employees. I want to create on workbook where each employee can enter their attendance and a summary sheet to gather all their time so I can submit to payroll. I know how to create and map all of...

I do a lot of financial writing with different numbers every quarter and change language based on the date. Is there an easy way to create a form that automatically writes the paragraph summary? For example: Forthe three months ended March 31, 2019, "Company name" generated revenue of "$XXX"...

I have the current macro (Code below) that adds one record to an access database which works great. How do I create a loop that would insert all 500 rows and stops at the next blank cell? Or is there another option I should be looking at to insert multiple rows into access? Sub Add_Record()...

Hi there, I created an home inventory in excel. I would like a popup to display information about the item when i click on it. I know Microsoft access has a home inventory and when an item is clicked on an asset detail popup is created. Just wondering if i'm able to copy this form to excel or...

I have created a database for job lines in a plumbers that I work, for tracking new jobs. The database is completed using a data entry form to provide a new job number to a job. I have also set up a blank job line that gets printed out to give to the engineer that is going to this job. I have...

Hi, New to this forum as I cannot work out how to solve an issue that I have come across since we migrated our corporate email system from Lotus Notes to Office 365. Mr Excel has helped me a lot, by reviewing other peoples problems and proposed solutions, but I cannot find anthing on my...

Hi, Im trying to copy a slide in a ppt using the following code: Sub openppt() Dim PowerPointApp As PowerPoint.Application Set PowerPointApp = CreateObject("PowerPoint.Application") PowerPointApp.Presentations.Open ("C:\test\template.pptx")...

Hi I have a filtered pivot in Sheet1 that has a list of names. I have Sheet2 that is the "template" to be copied. I would like to use a macro to create a new worksheet of Sheet2 for each name in the pivot table. In addition the sheet should be named that name, and also place that name in cell...

Hi Guys, I receive a list of items pertaining a customer. I want to do is check if list A has an item from list B then create list C. The problem I’m having is that list A is all in one cell separated by a carriage return. So for example cell A3 has xxx xxy xxz, and can be up to 40 items. I...