template

Hi I have this formula below which works on a template I have but I want to add this into my userform1. My range is in sheet called ‘Data’ A1:R17 and the AC3 (Match) is now ComboBox2 and AC4(Match) is now ComboBox1 and I want the result to go into TextBox53 [CODE]...

Hey i'm having trouble getting an outlook code to work in my favor. Basically i have a userform that an end user fills out and it assigns 2 strings to errorHD and issueHD I want to check if the user already has outlook open If its not then open outlook Then use a template that looks like Name...

Hello Forum, I have exhausted every effort in searching all over different forums for a solution to my predicament. I would be eternally grateful to anyone that can find a solution to my issue.:( This is what I’m trying to accomplish: I have one master sheet called “Master” There are six...

Hello, I am trying to accomplish the following: In my workbook I have a master spreadsheet named PLC Config. In PLC Config there are eight different cell value options (SPARE,ECOM,AI,AO,AIAO,DI,DO,DIDO) for cell range B12:N12. The same cell value options are present in cell ranges B15:N15...

Hope someone can help with this, I have a a csv text file that needs importing to a template then modifying using power query. Trying to find a way of being prompted with a dialog box for the source file so different named source files from different locations can be imported to the same...

I am looking for a way to see if the workbook name contains the word "Template". If so, I want the macro to prompt the user to save the file. I have the code listed below, but it does not seem to give the correct response. How do I get this to work? If ThisWorkbook.Name = "*Template*" Then...

I have an .xltm file on a shared network drive. I set it up as a template to enable multiple users to use the same document at the same time, opening each instance as a template page... but... when they open it, the macro goes to save the file as a generated name... a pop up occurs stating that...

I have inherited a process which has a template workbook with Macro buttons so users can move to specific sheets. The template has been used to create approx 700 files. I have been making some amendments to the template, which has included changing one of the worksheet names - this means one...

Greetings! I am quite new to this forum and know very little about VBA. Seeking your expertise in a matter that I've been searching for a couple of days to no avail. I am looking for a vba code to copy a Range from a sheet named "Estimation" of multiple workbooks in a folder to a template and...

Hello I am working on an excel file with 7 sheets. The main interaction that a user will have with the worksheet is through a user form. The user form as multiple pages and one page is already completely functional. The next page, however, is giving me a lot of problems. The first problem I am...

I have a macro that creates a folder for every new client we engage with a specific folder structure. It copies a template folder to the desired location, then renames the folder based on the input in the excel workbook I run that macro from. Sometimes when I open the template, it has an...

Hello All you Excel Gurus, I need a little insight. I have a template that has multiple columns and multiple rows. Set up with accounts, subtotals and grand totals. The template will have a Rollup total section on the top and multiple regions below it. My main issue is that it will be...

I have an email template stored on the desktop, labeled Email.msg. The Email template is in HTML format. I want to take a cell containing the recipients name from a cell in Excel and adding the name to the Email template. I have put a placeholder in the places where the recipients name should...

I constantly change and save my default Excel template in: C:\Users\dmalfoy\AppData\Roaming\Microsoft\Excel\XLSTART Does anyone have experience changing the default Excel template in a Citrix Virtual Desktop? I put in a ticket to my IT department and their response was clearly that of a deer...

Hi guys, I am in the process of running a planning cycle and have currently I have managed to design what the template will look like for one area i.e. EMEA. We have numerous areas which have multiple cost centres which are further broken down into accounts at hierarchy levels 1 and 2. I am...

Perhaps you can help me solve this issue. I created a timeline using Excel template called "Timelines with milestones (yellow)" please view below Everything went smoothly, bounds were adjusted, data was entered and it worked intuitively. I even gave a presentation to my boss and showed him...

Is there a setting or a macro that could disable the auto function of a macro-enabled template from adding a number? I have a workbook that is used for every bit of work done in house, and is copied many times. I chose to use a template to discourage anyone from making edits to the original...

I have about 400 files in an old template. The data in each file needs to go into a new template. Most of the cells between the 2 templates don't match (cell B7 in old template may go to cell C14 in new template, even in a different tab sometimes). ... I really don't want to do it manually 1 by...

Hi I am using Windows 10 with Office 2010 I want Excel to open to macro enabled template but where to put? Thanks

Hi all, got a quandry here. Let's say I have a table like the below: <tbody> Paper Company Template Flag 1 Aber Chronicle JG UK 2 Aber Chronicle JG UK 3 Ban Guard JG UK Y 4 Ban Guard JG UK Y 5 Biggle Chronicle JG UK Y 6 Biggle Chronicle JG UK Y 7 Biggle Chronicle OM UK 8...