1. R

    VBA to Open a Template workbook and insert value from active worksheet

    Hello! Hope you all are doing alright. I wonder if anyone could help me to acomplish a task thru VBA. For starters I cannot right code, but i am pretty good at combining different solutions found on the internet and apply them to my need. 1 - I need a macro that looks in C column and macthes...
  2. N

    Kickstarter template

    Is there an experienced Kickstarter user on this forum? I am looking for a reliable Excel template to calculate my pledge goal and BEP. Can somebody supply me with that? Look forward to any help/suggestions. Kickstarter has one on GoogleSheets but I have not been able to access it so far...
  3. R

    Creating multiple excel files from a template - renaming and saving them based on list

    Hello Guys! I am really new with VBA, i hope You can help me with this. My girlfriend got a task at her workplace, to create 400+ excel files. I think this could be easily done with VBA. I tried many codes, but unfortunately i don't have the knowlege to modify them at the moment, but i really...
  4. H

    Need to automatically extract 10~12columns of values onto a fixed template for consecutive printing on another sheet.

    Heya :S I'm trying to use excel to automatically fill in my Journal vouchers for transaction recording. What I would like to figure out is how I can type in a list of values on one sheet (let's call it 'Journal Input'), roughly 10~12 columns in total and contains both words and numbers, and have...
  5. J

    HELP.. Combined table by adding each date to fixed header line on seperate sheet by using VBA

    Hello Brave Excel Lovers and Helpers I have an Excel File in which there are three Nos. Sheets and a Userform (File is attached) RawDatabase ReportTemplate MyReport I can only generate report for single selected row from Userform Listbox1 (see MyReport) But this is not what I need. I then...
  6. A

    Can I create a changeable table template for multiple workbooks that automatically update when I update the template?

    Hi everyone. I'm trying to create a Master Excel sheet that stacks up multiple children spreadsheets that have the same set of columns. I can easily do that using power query or the Data tab in Office 365. However, the problem is I may want to add or remove columns of the children sheets later...
  7. C

    Help merging database with template

    Help me merge these please? Template: First Name Last Name Email* Mobile Phone* Country Block Communication Employee Email Contact Tag 1 Example: John Example: Doe Required Example: johndoe@yahoo.com Required Example: (123) 456-7890 (Only if Email column is blank) Example: US (Select from...
  8. Jaafar Tribak

    Which template is the current workbook based on ?

    I can't find a workbook Property or Document Property that return the template the workbook is based on. Any ideas? Regards.
  9. 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...
  10. 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...
  11. 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.
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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 ?
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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