1. B

    Advice on updating templates

    Hi, I have developed a range of Excel tools which are combined together into a core sheet periodically. Multiple users input into the child templates and there can be 50+ of these live at any one time. The child templates must all be exactly the same so that when the combination takes place...
  2. S

    Copy worksheet from template

    Hello, I have played with this and still can't figure it out. I have connected this macro to a check box: Sub copy_Sheet() Dim wb As Workbook Dim activeWB As Workbook Dim FilePath As String Application.ScreenUpdating = False Application.DisplayAlerts = False...
  3. G

    How do I submit my Excel template to Microsoft?

    I have created an Excel template to determine recommended portfolio allocation based on age and values of investment accounts. I would like to submit it to Microsoft for other users to be able to download and use. How do I do that? Thanks.
  4. G

    On Error GOTO Quit

    On Error GoTo Quit: Quit: MsgBox ("Please Add Data to Template Sheet" _ & vbNewLine & "Then Run Program") Hello All, I have the above code. The On Error GoTo Quit is at the top of the code, with the Quit: at the bottom. The problem is my message box keeps popping up, even when no errors...
  5. A

    Fill down an array formula across multiple worksheets

    In short, what I need to be able to do is fill an array formula down in multiple worksheets. Within each sheet the formula needs to fill down a different number of times. I will give some background info so that this can be understood in context and then paste the code I currently have below...
  6. S

    create files with contact information list

    Hello, I have a list of contact information and a template to transfer it to. Information that has become a row will go to a fixed place in the template. how can we create a copy code for this? creating a copy of the existing template file in accordance with the number in column B would be...
  7. F

    VBA code to automatically save pdf file and also without displaying it

    I have a code that populate word documents then prints to pdf. The problem is I have to click SAVE for each one then the display of the PDF opens. Is there a way to automatically SAVE and also prevent the preview from coming up? Any help would be greatly appreciated. Below is the code: Sub...
  8. S

    Excel Template sending e-mails

    Morning I have been tasked with "fixing" and excel template created by someone else who no longer works for the company. We fill in the template, press a "clicky" then it saves and send the completed template to the client. The issue is that the company images that appeared in the E-mail are...
  9. F

    VBA Fill in Word Template and save as PDF

    I'm looking for some help tweaking this code. I have data in an excel sheet and a Word template. It will fill in the template but when it goes to save it pops up and I have to manually save it. I want it to save and move on to the next line. Any help would be appreciated. The code I have so...
  10. C

    Macro to copy template fixes from master file to multiple files

    I have template fixes that are on a master file but I need those copied to multiple other files. I'm running into issues becuase the new files are all different names. I would like to have the master file open and the new file and run the macro and the template fixes to copy from one to the...
  11. M

    Template to be save in simple worksheet.

    Ok I have make template in excel. i want that when somebody use the template and save it. it should be save in simple excel sheet and only sheet 1 will be save without the formulas. or is it possible to save it in jpg only ?
  12. B

    VBA - Merge multiple files to one sheet

    Hi everyone, thanks for the help on previous questions and the continued support. I have written some VBA to export some invoice to load in to sage but now need to combine the days exports in to one sheet to upload. Each export contains a sheet with a header row (A1:AI1) then a list of lines...
  13. S

    Renaming an Active Workbook

    I've seen a lot of forums about this but wanted to inquire if there was a favorite way to rename an active workbook. The previous name (name being replaced) has to be dynamic, it could be any number of things while the new name is fixed. This is going into the middle of a macro that already...
  14. J

    Looking for information on Automating a Reconciliation Report

    Hi all, New to this board, and hoping to get some good advice. My team conducts a lot of data pulls to create reports, and they are all very time consuming. I'm trying to better educate myself in becoming more efficient in excel. One of the reports we do, is a Reconciliation between two...
  15. W

    Workbook Sheet Referncing Problem

    Good evening all, I'm trying to make a program that will allow the user to click on a cell or select multiple cells and the contents of that cell, or a selection of cells, will then be pasted into another workbook. I'm using a selection change event to accomplish this. It works fine until I...
  16. D

    Population of Multiple Templates from Workbook?

    Hi all, I'm hoping someone may be able to assist me with the following: 1. I have a table of data with filters applied from which I would like to fill (and print) templates in another worksheet as quickly as possible. In other words, each week I input some more rows into this table and then...
  17. D

    change default font color

    ok, so i redesigned a template, but what i shoul;d have done is use a new workbook because every time i type something in the template, the font color is red. is there a way to change it so that it's black?? using excel 2010.
  18. V

    In need a VBA script to create sheets from 3 different template sheets and more...

    Hello all, first time here! I'm not proeficient much with VBA, hopefully someone can help me. I need a VBA script to create a dynamic amount of sheets at once based on 12 different cells value, from 3 different template sheets (I need to keep those 3 templates formula intact) and based on some...
  19. T

    VBA - create new sheet from a template

    Hi I am asking for your help for a VBA code which create new sheets from a template sheet. I have already found and modified which works well : <code class="hljs vbscript">Sub CreeOnglets() Application.ScreenUpdating = False supOnglets Set bd = Sheets("bd")...
  20. Skybluekid

    Convert Column Dates to Text VBA

    Hi All, I have in column D a list of dates: <colgroup><col></colgroup><tbody> 43728 43710.35417 43732 43689.62014 43698.44236 43727 43708.5 43699 </tbody> I would like to convert these dates to Text and then format them as dd/mm/yyyy. I hear you cry "this is easy and why are...

Some videos you may like

This Week's Hot Topics