template

  1. R

    Data Validation with multiple condition

    Dear Friends, We have a new data entry operator who will be entering all the new employee data in a spreadsheet. We need to build a template for this person as he is a fresher to MS Excel. Seeking your help to construct the template on below example. We have built 2 worksheets - 1. Master...
  2. D

    "Save As" through VBA

    Hi! Just recorded my very first macro (yay!). It's a simple one doing mainly sorting and copying. I'm missing some functionality though that might not be possible to record, however could perhaps be modified within the VBA code? The file is template.xlsm - given it's a template in nature, I...
  3. M

    VBA: copying and renaming template files based on data

    Hello, I'm looking for some help! I have several rows of data with the following sample information: <tbody> A B C 1 Item Decription Units Prop. Line 2 Removing Asphaltic Surface SY 0004 3 Removing Guardrail LF 0014 </tbody> I also have a "Templates" folder with template excel files...
  4. D

    Rounding Table Formula

    hi guys i have a pricing template that i want to implement to round up price points what's the formula please? <colgroup><col span="3"><col></colgroup><tbody> Between Round Up To $ 0.01 $ 0.27 $ 0.28 $ 0.29 $ 0.47 $...
  5. L

    Custom Chart Template/Formatting issue

    Hi all I have created a chart template to format a series of charts in a dashboard i have developed, is there any way to embed the template into a workbook so that when I email the chart the charts will follow the template format when someone else opens up the document on their own computer...
  6. B

    VBA to add sheet to new tab

    Good afternoon, I have developed a pretty complicated sheet for some users, but they are still having issues copying a page and pasting into the template. Basically, the sheet I have made stays static, then every week they need to update the orders sheet, and stock information. (They are...
  7. J

    Custom Email for Marketing Campaign

    Hi everyone, I was able to see a code to send customized emails to multiple recipients by the process of mail merge. The only problem that I have right now is that the word template becomes an attachment to the outlook email. here is the code below: Option Explicit Sub CreateWordDocuments()...
  8. J

    VBA help with generating 2 new workbooks from 2 different templates

    Hi All, I'm fairly new to VBA work in Excel, but I'm learning quickly. I've sorted out how to generate a new workbook from a template excel file, but I'm struggling to sort out how to generate two different new workbooks from two different excel template files (named Template1 and Template2)...
  9. K

    Gantt Chart Template Progress Bar Help!!!

    Hello, I've been tasked to customize the "Simple Gantt Chart Template" based in Excel to an Annual Template as oppose to the weekly one that's already in the Simple Gantt Chart Template. I need to adjust the following: 1.) I want the progress bar formatting to change from purple to the...
  10. B

    Ensuring the function "Evaluate(Name)" is using the correct workbook when multiple workbooks are open

    Hello Excel Geniuses. Every time I log in I learn how much I don't know about Excel. Thanks to you all. Here's my latest conundrum. I have a workbook template that is populated externally. When this template is opened, VBA code uses takes that data and organizes it, adds formulas, populate...
  11. S

    Macro to link template to master workbook

    Hi I have a master workbook which contains sales teams monthly and annual data. I also have a template that is used for monthly sales. How do I set it up so that when I use the template to create a new month this will link to the master workbook? Thanks Sarah
  12. J

    Insert entire sheet into another or template

    Hello everyone, First let me explain what I am doing because there may be a better way of doing it. I am creating an excel for a set of users. They will enter in a SKU, and based off that sku I want it to pull due dates for that project, as well as populate a template for the category that sku...
  13. I

    how to make a copy template + make new hyperlink to new copy template.

    Hello everyone, I need some help to make a new macro. Atm i have it setup to press a cell that he creat a copy of the template and it give it a new name. Only what i really want is that he also make a new Hyperlink and put it in a new cel. So basicly if i make a copy of the template the name...
  14. G

    Extracting data by filter, pasting into template, saving, repeat

    Hi Folks, I am hoping for help to assist in splitting a report and saving in an already defines format. I run a report that is about 20000 lines long and contains roughly 20 columns of data. One of the columns is a name and I would like to filter on each name then export the data into...
  15. S

    VBA Copy & Paste tab based on criteria

    Hi All, I have spreadsheet I am working on that I know could benefit from a Macro, but my VBA experience is minimal so I'm having difficulty wrapping my head around how to write it. Currently I have two worksheets (1 Master & a template that feeds off of it), the structure of the master tab...
  16. R

    Use Macro to add Sheet (template) and consolidate at the end

    Hey I'm trying to semi automate a recurring process. There are about 4-6 different cases that can occur in any combination. scenario 1: 5 times case A and one time case B; Scenario 2: 2 times case A and 3 times Case B. You get want I'm saying. For each case (A,B,C,D etc) I have a template that...
  17. E

    Create copy of current workbook and save as filename in cell

    Hi guys, I have a spreadsheet I use as a template for employees to fill in. I would like to save the workbook after employees have entered details under their name located in cell M1 but not overide the current template. So they start by opening the spreadsheet template.xlsm. Enter their...
  18. E

    Copy & Rename Multiple Sheets

    Hello All, I'm interested in creating some VBA to copy multiple worksheets while also allowing a user to edit the names. I have the following worksheets - Template - Template Timeline I would like to create a macro that copies them into the same workbook (moved to end) with a popup that...
  19. G

    Chart Template tedious issue

    Good afternoon everybody, I am having an issue with a chart template. I am working on a scatterplot based on 36 observations, I therefore have 36 X and 36 Y displayed in two columns. I generate a scatter plot and I apply a very nice template to have a better visualizations of data markers. This...
  20. N

    How to use a common template on my code

    So I do I set a template to have information look better? I have wrote a code that creates and renames worksheets based on my list. Each worksheet has Net operating income statements. Now I need these sheet look clean and with a common template. So how do I add a template on top of the code I...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top