create

  1. S

    Create 3D Cell References with Macro

    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...
  2. M

    VBA create rows based on date range value

    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...
  3. B

    Formula to calculate a formula if another formula produces a certain value?

    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
  4. R

    Auto workbook create

    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...
  5. M

    Creating a Powerpoint Based on Excel Data

    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...
  6. E

    Stock market 15 minute calendar

    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 =...
  7. T

    Create and fill worksheet of unique combination of 2 cells

    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.
  8. D

    Using Timeline Slicer

    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...
  9. S

    Create PO number List skip blank cells

    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...
  10. G

    Privacy sheet tabs

    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...
  11. S

    Create automated paragraph based on criteria.

    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"...
  12. S

    Create Loop for each row in a column

    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()...
  13. J

    Create poup on item in home inventory

    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...
  14. P

    Auto Fill a Form from a Database

    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...
  15. M

    URL in email created by VBA Excel code is not recognised as an active link in O365 Web Outlook

    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...
  16. S

    copy a slide of a powerpoint presentation in Excel/VBA

    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")...
  17. C

    VBA to create new worksheets based on filtered pivot table

    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...
  18. A

    If list A has an item from list B create list C

    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...
  19. kweaver

    VBA to create multiple workbooks based on sheet cell

    I have tried various approaches I've seen on the internet to no avail. I have a workbook with a worksheet named "Reformatted". In P1 I have the text: SUPER In the rest of column P I have 2-character codes. I'd like to loop through this sheet and create a number of additional workbooks, each...
  20. J

    Table with multiple date columns

    Hey, together I have the following table in Excel, which I add in PowerPivot to the data model: <tbody> ID Created Started Finished 1 01.01.2019 01.01.2019 05.01.2019 2 02.01.2019 03.01.2019 08.01.2019 3 03.01.2019 03.01.2019 04.01.2019 4 03.01.2019 04.01.2019 08.01.2019 5...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top