template

Hello, Is it possible to code VBA to link 2 to 3 sheets (template for Winshuttle). 1 button can run the 3 winshuttle scripts with 3 excel sheets template? Can you give me idea how will it be? Thanks

I have a workbook that has a template on a sheet named "template". I have another sheet names "People" that has a table that refreshes each day based a query. On column A it has a list of people's first and last names Goal: After the I refresh the query (separate macro), I want the new macro...

I am a newbie with Excel and could use help. I am trying to use a template for Ticket Tracking for our Non profit Theatre. Here is the template I am working on. https://1drv.ms/x/s!AvrJXpPq_XWokllNt6BaJTbrlgJI I would like to add 2 new prices under D3. Could anyone guide me on this? Thanks!

Morning, I have a template of which i use for invoices. I have made some alterations to the columns & what are in the cells but now my overall width is larger so when i preview it then you can see some is cut off etc. I use the same template for another company of which this hasnt been altered...

Hello, Does anyone know code that will copy a template worksheet multiple times? Original Sheet Name: Week Template I plan to have one worksheet for each week in the year (52 plus the 'Week Template' sheet Paste conditions: 1) row height 2) column width 3) fonts style sizes and colors...

Hi, I am trying to create the option to click a button/ field/ word on a line in an excel spreadsheet table that will generate a new tab which transfers some of the data from the fields on the row in to a new pre-defined template. The template requires the following fields to be populated from...

I have been looking for a VBA code that will basically take information from my worksheet and create a new sheet for every row. I have a template that I would like my data to autopopulate so that each new sheet is in the specific format I would like it in. anyone know how to do this?

Hi! I need some help here! I have been trying to 1)Create a button that pops up a form where I can fill in "Name" and "Time". 2)I have a word template, after fill in "Name" and "Date" in the form, I wish to link those two pieces of information to the title of the word template. For example, I...

Hi, I have a workbook where the first sheet is a template set up as I want it to look. I then have separate monthly sheets where I want all the details from the template and then subsequently figures will be entered. I have entered the following formula into cell A1 of the monthly sheet ='Taps...

I created a "template" worksheet, in which users create a copy of said template and rename to a variable name. On the template sheet, there is data and 2 charts that reference the same sheet name as the charts sitting on ( data is not on another sheet). After creating a copy of the sheet, the...

Hello there, I have the following issue: I have a report sheet in an excel file that combines the information from several template worksheets in the same workbook. I already got the idea how to create a template worksheet every time i hit the "+" button. What i now need is to enable a formula...

Hi, I need to send each person his excel attachment , with a template email what would be the solution for 100 more people

Hello, I have a new project to work on, and I am trying to find the best approach to get this done. In short, I have files summarizing business with our customers (about 400 of them). The format is not perfect, but I can probably work with it (columns are always the same, but information is...

Morning, I use the same worksheet template every month. I would like to put a code etc in Cell B1 which would just enter the month. So say starting in July the cell is blank. I open the worksheet the code looks at the current month from pc etc and enters JULY into Cell B1 Next month i would...

I have been trying to set up formula below on 3 line using a _ in between but code changes to red "=IF(ISNUMBER(MATCH(RC[-7],'[BR1 Import Template." & C & ".xlsm]Data Import'!C1,0)),VLOOKUP(RC[-7],'[BR1 Import Template." & C & ".xlsm]Data Import'!C1:C7,7,FALSE),VLOOKUP(RC[-7]+0,'[BR1 Import...

I have an Excel Macro Template file on our Network for our Sales Team to use. I want to record the user name and time/date in a seperate user log file hidden from the user, so I can keep track and frequency of the file being used. This would be VBA Code as an on open-event or after open in my...

Is it possible to do something similar to below? Open a workbook which automatically triggers a macro. Once the macro runs a dialogue box will appear and has options of "Herds: 1, 2, 3, 4" and "Hay: 1, 2, 3, 4" You must select either 1, 2, 3 or 4 for each of the options and press ok. Once you...

I run an export every month from Quickbooks - it is for accounting actuals for my company. It's a horrible format and not meant for external users. I'd like to create a more user-friendly template where, when I export the data, it automatically populates into my template as well. This would...

Hello ~ Hello I'm using the following to try and open a saved Outlook Email Template - But I can't escape RunTime 438: "Object Doesn't support this property or method" Dim MyItem As Outlook.MailItem Set MyItem = Application.CreateItemFromTemplate("C:\Users\ABC1234\Desktop\Untitled\*.msg") Set...

Hello there, I'm hoping to get some advice and guidance on how to start. I used an Excel calendar template, which was perfect because it has a select year option to display all 12 months of the year, then I listed out some dates for events A, B, C to conditionally format it on the calendar...