auto popluate

  1. C

    Query to auto populate another field in same record

    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...
  2. J

    Auto populate from 1 worksheet to 2nd worksheet.

    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...
  3. A

    Creating New Worksheet/Workbooks based on Existing Data from Master Sheet

    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...
  4. K

    IF formula help populate other fields

    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...
  5. J

    Data validation drop-down list

    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...
  6. J

    VBA Macro for Auto Printing from a List box

    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...
  7. R

    Auto Transfer Data from Master Sheet to Several other Worksheets

    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...
  8. S

    Auto Populate Horiziontally, with a twist

    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...
  9. N

    Simple auto populate value from list.

    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...
  10. T

    User input in a column, and creating option to select how many rows it will populate

    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...
  11. R

    Auto Populate Data between dates

    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...
  12. X

    Auto populating a key column in an output table based on a column from an input table

    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...
  13. K

    Auto Update Formula

    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...
  14. C

    Auto Populate Drop List from a selection in another Drop List

    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...

Some videos you may like

This Week's Hot Topics

Top