auto populate

  1. K

    How to Auto Populate Entire Row With Previous Values Already Entered by Entering Name on First Column?

    Hello, I do alot of repetitive work and looking for away to auto fill a row with the last entries I entered based off of a name in the Second column. Every day I need to enter in the same values, but sometimes one value changes and stays for awhile. So I would like to populate from the last...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top