auto populate

  1. T

    Need to changed the value in a cell based on another cell with multiple values options

    I need aformula that will auto populate like this: If A1 shows “M”,then auto populate in A2 “T”, or “T” , “W”, or “Th”, “F”, and so on. I was tryingto write an “IF” statement, and then a VLOOKUP, but I am not good at writingthese formulas. Could anyone assist in helping write this. I...
  2. T

    Auto populate holiday tracker from year planner

    Hi, I have a sheet "Planner" where I can input the holidays taken by employees. All these sheets currently work fine as they are if I were to input data manually. What I am looking to do is auto populate sheet "Holiday Overview" cells C4:N28 with the hours holiday taken which is based on the...
  3. A

    Check Boxes

    I am creating a rather small excel sheet. Only 4 columns, but it will become quite lengthy. I need a check box in it to use as the case goes to Appeal status. So, what I would like to do is for that check box, which I will have in column 1A. But once I enter a name in column 1B, I would like a...
  4. F

    auto populate with date + 6 months

    Hi Everyone, I'm in desperate need for a unction/rule. So, (this is embarrassing) a bunch of people are imputing dates in column G in a spread sheet; they are all different dates. These people need these dates plus 6 months to auto populate in column F. For instance: column G is 04/30/18...
  5. H

    Formula to read values from a range to and autopopulate info into 2 different columns

    Hi Guys. I am new to this forum, and not sure how to place my actual excel cells in here... Ok. So I will explain as best I can, I am after a formula (not a macro) to Take player preference and auto-generate a list; in this example, there are only 2 rewards and only 5 rewards available each...
  6. G

    Check Boxes - Auto Insert when inserting new row

    I have check boxes in one column on a form. When the user inserts a row I want the check box to populate as well in that new row in the same column as where the others are now. Is there a way to do that? Side Note: I already have a conditional formatting formula to shade alternate rows when...
  7. N

    Create a list of names based on a number indicator

    I have a list of QA Analyst, and a number of how many audits they need to complete. I then have another list of advisors that need to be audited. I want to apply the QA Analysts name next to the advisors names the exact number of times that the first list says they need to audit. I'm not sure...
  8. R

    VBA Code for Auto-Populating Text From One Table to Another

    I have a table that tracks a bunch of info such as, person, category, department, description, due date, and priority. I have, at best, extremely weak VBA skills, so I REALLY need help. Here is what I'd like to do, if it's even possible. I would like to have a VBA code that will...
  9. J

    Auto Populate from dashboard to second spreadsheet

    I have a workbook with multiple sheets. I would like to learn how to set up my dashboard so that I can enter data on it, then have the data fill in the first open row on the spreadsheet. The spreadsheet has 17 columns of data with 2 blank columns after the 5th and 9th columns of information...
  10. K

    Auto Populate a Cell Based on a Phrase

    Hey all: I need help figuring out how to auto populate a cell based on a phrase or text in another. So, for example: If I put 'Replace VCT in doorway' in A1, I would like 'TWO' to automatically appear in B1. Would it be easier for me to do this in Access and then export it to excel? Either...
  11. A

    Auto populate a column when other column is filled

    Hello there, I am trying to auto populate column B with number '1000' when column E is filled with data, for which I am using formula =IF(E2="","","1000") But this is not giving me the result I wanted. You help in this will be greatly appreciated. Thanks, Aashna
  12. M

    Combining auto suggest combo box and auto population using if statement

    I am trying to combine these 2 code lines to accomplish a drop down list with suggestive text. That also auto populates other cells when a menu is selected it populates menu items. The suggestive text works well but I'm a bit stumped on how to go about adding the auto population of the cells...
  13. P

    Help! - Auto Populating

    Hey everyone. Okay so I have a speadsheet with 8 columns which are: A - Name of Customer B - Date of Sale C - Month of Sale D - Cost E - Sell F - Margin G - Profit H - Description I want to auto populate Column H when I type in the name of the customer in Column A. In Description I have a...
  14. C

    Auto populate excel quotes from thousands of referenced price lists

    Hello, I am trying to determine if there is a way to create a workbook template for a sales quote that references other workbooks. In other words, is there a way to automate the population of data fields (eg. supplier, cost, description) when a manufacturer product number is entered into a...
  15. B

    Auto Populating new sheets

    I'm trying to figure out how to populate Sheet 2 (Item 1) with the information from Sheet 1 (Submittals log) Row 6 automatically. I'd like a new sheet created for each item in Column A with the same format as the Sheet 2, but with the information for the next Row down (Item 2) and I'd like the...
  16. S

    Excel to word autofill and auto populate???

    Sir, I got a excel data as follows: <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Loan Acc no Name address 1 address 2 address 3 address 4...
  17. M

    Excel Formula to Auto-populate Start & End Values in Datasheet

    Hi there Context of problem: I am trying to quantify lengths of fencing along a road into excel. I type the extents of the fencing into Table 1. Note that Start & End represents the location on the road. So for example, a fencing which starts at location "90" and runs to location "95" is 5...
  18. M

    Auto Populate sheet using multiple drop down lists

    Hi, I am looking to auto populate a spread sheet using multiple drop down lists, 4 to be exact. It is a dimensional drawing of a tool, where the dimensions will change when a different size and weight and material is selected from the drop down list. Please let me know if you can help me out...
  19. I

    How to auto populate date range (working days only) from start date and end date

    Hi I am now trying to create a excel macro to auto populate all the dates with reference to a start date and end date. The catch is that only working days are required in the range. My reference cells (start and end date) are in Sheet 1 while the destination cell range are in Sheet 2. The reason...
  20. J

    Populate a cell with a value simply by clicking on it

    Good afternoon. I am developing an evaluation tool that has a 4 point scale (Highly Effective (4) to Ineffective (1)). <tbody> Mr. Smith Highly Effective Effective Developing Ineffective Trait 1 Trait 2 Trait 3 Trait 4 </tbody> I would like to click...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top