template

  1. E

    Template generator and data sorting

    I have the following data excel code that looks at a sheet of data and sorts the data based on a number and copies it to a new template sheet. A B C............ Line: 51106-02 AB ZONE 51106-02-904-601...
  2. H

    macro enabled excel vba save workbook in specific folder while downloading

    Hello all, I need help in VBA as m new to it. I have a macro enabled worksheet lets say template available at server. Whenever I click on it to download, I want it to be downloaded at specific folder itself. the code should be in that template itself. Any help will be appreciated.
  3. M

    Excel Template with Command Buttons

    Hi all, Just starting out with Macro and recording (not yet moved on to VAB and coding) and have got stuck / cant locate any advise on the following. I have created a 'Quotation' template with Macro command buttons to generate formatted pivot table and open a Word document for emailing. These...
  4. Loadtoad

    creating workbooks from template from a list

    hello all, I have a template and a workbook with a list of names. I need a macro to use the template to create workbooks named from the list of names in another workbook. Template name= v4 Template List of names workbook= Roster (on data tab) Thanks in advance Rod
  5. Y

    Create user specific documents from template using values stored in spreadsheet

    Good Morning All, I’ve been attempting to generate user specific documents from a template, but I cant seem to get it working. I have all the information in an excel spreadsheet and would like to create a personalised copy of the template for each row of the spreadsheet. Essentially, the...
  6. S

    What formula to use - if the specific group of cells contain a "yes", change the yes to "confirmed"

    Hello, I'm doing a template to check availability and coordinate common slots for 3 different groups of officers (admin, relationship and finance). So I have a template that has a list of dates (B1 to V1) and with the list of officers (admin: A2 to A6, relationship: A7-A12 and finance A13-18)...
  7. T

    Easy question for those who know - data population into a template...for printing.

    HI Folks.....Just a regular Pool Service guy here....Looking to use Excel to maintain Route Sheets. I want to have one sheet that has a long list of customer names, address, and other things...and be able to populate a single template when I print them out. The template will have the names...
  8. S

    Issue: combining multiple workbooks with same table names

    I have a template (*.xltm) which has a few different tables in it, each table is named based upon what it is used for. Example: tblDates; tblLocations; tblStatus; etc A number of in-cell formulas reference the tables by name and their contents. When I save the file, it gives it a unique file...
  9. H

    VBA copy excel into template Word document

    Hi, I work for a charity near Liverpool (UK) and need some help please. When we send our template introduction letter to our beneficiaries we have to include a selection of 5-10 (out of around 50) standard paragraphs of text to insert into a letter. Currently we use Word 2016, and set up a...
  10. D

    VBA to take template with formulas and create and rename a sheet

    I have this excel workbook that has a tab for every month. This tracks awards given to my employees. I have a main sheet named Master that holds a few formulas to randomize and the template for the tracker. I need a code that I can put into a button that when pressed creates a new sheet...
  11. Z

    Macro Help

    Hello, I need help from the experts. I'm creating an inventory file for all users and I have the main sheet called "Users" where I have a table with the names of the users in the column A, starting in the cell A1 and goes to A200. I need to create a new sheet using the sheet called "Template"...
  12. E

    Copying a certain amount of Worksheets based on input from a Userform

    Hello, I'm very new to VBA and I'm trying to copy a certain amount of Worksheets into a Workbook based on input that a user puts in a textbox on a userform. Basically, I have multiple users that will be using the same template. Depending on the user will depend on how many template worksheets...
  13. A

    Variable file location

    I have a folder that is a template for multiple forms. I wrote a code that open the forms and publishes to another location. Works fine. My problem is that since this is a template that my users use to make a new file the location changes The area in red font is my issue. my simplistic...
  14. A

    VBA help on file location

    I have a set of docs in a folder that is used as a template. Our people Copy template into a different location. Everything works but a macro that opens files. Below is my template location and name. How do I structure the Macro to adjust to new location? Workbooks.Open Filename:= _...
  15. T

    Search for a specific template

    Hello friends. I have a very important project that I work on. I will be grateful if you could help me. I need to group and search the data on Excel. Below you can see the schema of the data: Column A Column B Column C Column D Column E 1. X 1 July 2. Y 2 July 3...
  16. H

    New worksheet creation from Table

    Hi, I'm using the following code to take the names located in a range, make a copy of a template worksheet called "blank", duplicate that template the number of required times, then rename the new worksheets with the list of names in the previously stated range. Two questions though: first, if...
  17. D

    Database to Template - Ideas welcomed

    I am putting together a database that I'd like to be able to have a macro assigned to a button that will take the information I have, and add it to a table that will continuously update. I'll build an invoice (or pre-invoice), and I'd like the following data to populate from the invoice, to the...
  18. E

    Macro to insert a template?

    Hello I have a template that is full of formulas, text and formatting. When I open any new excel file, I want to click a button and load that template in a new sheet so that the formulas will be populated based on the file I opened. How do I do this without converting all the text and...
  19. R

    Macro That Opens Another Workbook, Filters Results and Spits into Separate Workbooks

    Hello all, I need some help I am trying to create a macro that opens a specific workbook in a specific location, or allows me to choose the workbook I am opening I then want to go to a specific tab and filter row 4 of that opened workbook I then want to filter column U for the value "V" of...
  20. J

    Sending Email using Outlook Template Formatting issue

    Good Afternoon, I recently was upgrade to Office 365, now when i send my emails through excel,the format is changed. My bullets go to asterisks, and no pictures are displayed.If I display the email first, then hit send everything works great. It is onlywhen I use “.send”. I was looking for a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top