auto popluate

Hi, I was using this code for the past 4 months to send email by setting up a template for the main body so that my template is intact in HTML format with my signature and link but it stopped working today. Can anyone help? Option Explicit Sub Send_email_fromexcel() Dim EApp As Object Set...

Hi there, I'm a bit stuck on some VBA code and need some help! I want to create some code for a macro button that will auto populate a value from cell A1 in cells Q19 and AJ19 and carry on doing this every 14 cells in both columns. It would be great if the VBA loop ends at row 355 as this is...

I'm trying to out do myself, I have a basic form built out with drop downs and blanks. So far i have formulas in place that will find an "Available" ip by using xlookup, and i also have an xlook up to find the row, column and sheet name, i have a cell formulated to show a complete location (ex...

Hello Excel Gurus! First time poster here :) I am trying to set up a spreadsheet for a psychiatric provider to use to track when clients need to be seen. Ideally, I would like it to be the last name, first name, frequency, last seen date, needs to be seen date. I know how to do the basic last...

Form called Input Allotments that shows the current funds of one state. Subform that shows all that states transactions: master_data_auto_fiscal_year_subform based on a Query. Query: Master_Data_auto_fiscal_year it has all the fields from the MasterData table The query takes the date entered and...

Hello All Not sure what direction to go or how to phrase but looking for the following. When a quantity is inputted into worksheet 1 (labeled: product), that quantity and item description will auto populate onto worksheet 2 (labeled: totals). Worksheet 2 should not have any quantities if...

I am in the process of automating some of my workflow and cannot figure out how to best approach this situation. I have an inventory sheet that I would like to create new sheets off of based on categories. Each category would need its own file generated along with all items included...

Hi, I am trying to figure this one out, Hopefully someone can help me. Basically I have a sheet like this: <tbody> Post Name Announce Desc. File code Audio file code Station 1 Station 1_welcome 112 B76 Station 2 Station 2_welcome + Dept. 1009 Y677 </tbody> I have a separate sheet with...

I created a drop-down list with different fruit names and I want the user to be able to type in the first couple letters of the fruit name and have it auto-populate. For example, if the user types in "ap", the word apple would automatically appear. Is there a setting within the data validation...

I have 2 sheets "Printout" & "Notice". I want the Printout sheet to Print Automatically after selecting the Value from K1 cell. K1 cell is the dependent list based on Data validation. I want to Print from A1 to I59 Range of Printout sheet. When I select a list in the K1 cell various cell of the...

Hi all! I've been researching this for days and cannot seem to find the proper way of doing what I need! I feel like it's pretty simple..... I have a master sheet where data is entered as such: <tbody> Date Log # Building Rep 12/31/16 123456 5 Jane Doe 1/4/17 789012 10 Jane Doe...

Hello, Here is my problem: I am averaging the numbers in rows 1, 2, 3 in column A in cell A5, so my formula in cell A5 is this =Average(A1:A3). Rows 1, 2, 3 continue on until column AD, with each cell below A5 (A6, A7, etc.) containing the average of the next column in line, example: A6...

I'm looking to use the data validation tool. I'd like user to choose cell value from a very long list. Instead of have to click on the dropdown and scroll to value, how can I have them start typing and have excel auto populate value from list? I'd like to keep the function as simple as possible...

Hello Community, I am seeking the advice of any advanced users in my attempt to create an efficient user input, data entry form for the creation of table metadata. Scenario I am looking to design my sheet/Macro with the top two rows as user inputs, which will then paste these into a table...

Hello, I have a unique question. I am trying to auto populate data (resource needs) between two dates in excel. For instance, each month from January 2015 (start month) to December 2017 (end month) I need 5 resources. Jan 2015=5 resources, Feb 2015=5 resources, and so on all the way to...

Hi, I have a table which a client is populating with information. The first column contains key information to identify the line of data. The summarized output will be in a second table designed to be more clean and printable than the data input table but the first column needs to correspond to...

So, I have a workbook containing multiple worksheets and I'm trying to clean it up a little bit. This workbook is a list of people that my company contacts and it states if they accept an invitation from us when we contact them or not (in other words there are a bunch of yes and no's next to...

Hey I'm really hoping someone can help me out with this one. Basically what I'm trying to do is create a drop list depending on the option selected on another drop list. I think the main issue I'm having is that the option list is on another Sheet and excel keeps telling me I can't do a...