auto-populate

  1. Z

    Formula - Creating A Sublist from a master list

    I have a master list of clients in a sheet (Client List)- the list is broken down into 3 columns - client code, client name, AT Member 1. On a separate sheet, I am trying to create a formula that will auto-populate under the correct AT Members name. ex: Client List! TSM Toyota of Southern...
  2. P

    Copy data from sheet 1 to multiple sheets automatically

    Hi, I am trying to copy data that is repeated from one sheet to multiple sheets. I’m using excel as a database and I don’t want to have to update names of employees on every sheet manually. I want the names and other relevant info to auto populate when it it entered on sheet 1 to the other...
  3. I

    VBA code to auto-populate details for certain cells based on certain conditions

    Hi, I'm trying to figure out how to auto-populate details for certain cells based on certain conditions: Columns A, I, L, and Z should auto-populate Date when Column B has information keyed in Column F should auto-populate "Walk In" and Column G should auto-populate "Endorsed to" when Column...
  4. D

    Auto-populate Text in one worksheet into a table on another worksheet

    Is there a way to auto-populate text into a table on a different sheet? I have Date (Column N), Time(Column O), Message (Column Q) in on worksheet and would like it to be auto-added to a table in a different worksheet
  5. H

    Auto-populate Dates

    I have a worksheet which is used to create two week schedules....two weeks - Sunday through Saturday. Is there an easy way to have it populate the days of the month in the cells for the 14 days? Ie, if I entered 14 in the cell below Sunday - the cells below the days for the next two weeks...
  6. P

    XML-PDF Automatic Form Population from Excel Source - xfdf/ns1 Issue

    Hi guys, Thanks for taking the time to look at this question for me. The Situation I'm trying to automatically populate multiple .pdf's from my Excel source data. So far I've been successful with all of these forms, I have been using Foxit Reader to export the .xml data from the form and then...
  7. S

    Autp Populate Cells on a Different Sheet within a Document

    I have been trying to figure this out for 3 days and am at the end of my rope. I am designing a spreadsheet for a construction firm. The workbook contains an the estimate, client proposal and the PO's for 3 different vendors. On the estimate I have a dropdown list for the vendor, category...
  8. C

    Populate Data Using Given Variables, NON-VBA

    Hello there, I'm not sure if there is a way to do this, but I wanted to ask anyways... I have a data table I would like to populate automatically using a combination of variables and constraints. Basically I want a dynamic set of data that provides the following: Data Vintage_Month and...
  9. P

    Auto-Populate Calendar with Info from Master Sheet

    Since I had such success with someone solving my problem yesterday (serious props to Rick Rothstein for a beautiful code), I thought I’d try again today. Unfortunately, I’m a little out of my depth with VBA. Here’s what I need. I have the master sheet (TentaSchedule) and I need a few pieces of...
  10. F

    Aggregating time data in one workbook and automatically populating the results in a second workbook

    I set up two workbooks to track time required to complete tasks. Each workbook has one worksheet, with the variables date and time being in common. I want to share one workbook(book1), while the other is for private use(book2). The shared workbook has individual tasks listed, along with the...
  11. D

    Rewritten Post of Adding Macros for Adding Rows

    My original Post was apparently confusing those trying to help me figure out this dilemma, so I am reposting a more broken down version of the post I'm new to registering to this site but have used the related posts on the forums before but I can't seem to find something more specific to my...
  12. B

    Auto-Populating Excel Data Table (like queries for a database)

    The basic setup is that I have an Excel file with multiple sheets, each of these sheets has a data table. These data tables (lets singular-ize them and call it Table_Data for the example) list a Date (numeric), Description (text), Category (text), Value (numeric), and a other pieces of...
  13. K

    Help?!?! Pulling Values, Auto-Populating & Printing

    Hello everyone! Let me first say that I am a complete newb when it comes to Excel Macros. I am pretty interemediate in terms of Excel in general, but can't quite figure out macros. I am working on a report where I have a sheet that auto-populates various values (i.e. vehicle's license plate...
  14. D

    Conditional Formatting

    Hello, first post! So I'm at a stand still with conditional formatting. My desire is to create a fully automated spreadsheet where the filling of one cell auto populates other columns. Specifically, I want to format column K, to where if $b1="text", $k1=$j1-$g1. I do not want to drag a formula...
  15. M

    How do you add IF-formulas in MS Access Table/Form List Box (or Auto-populate a list?)

    Hi! I'm new at using MS Access. My team needed a task tracker that would encompass various task groups so I decided to use a Task Management template to create an MS Access database. Under one task group, we have a number of sub-groups that currently keeps one excel file tracker each. For...
  16. D

    Separating and condensing data from table

    Hi, Hopefully someone can help me with a problem I can't seem to get my head around. Here's an example sheet: http://i.imgur.com/QWnpSLM.png I type names into A2:A8 and use VLOOKUP to fill B2:B8 with codes from H2:H10, so far so good. But then I'd like to generate a table in D2:E8 which lists...
  17. E

    Style number / part number auto-populate in 2nd table

    I am a novice in excel (2010). I own a t-shirt brand, when I put together a print run with multiple designs, that have multiple colored shirts per design (as shown in my screenshot). I need to then total up the number of: SMALL BLACK-T, MEDIUM BLACK-T, SMALL BLUE-T, ETC from all designs...
  18. L

    How do I auto-populate cells based on what is in another cell?

    Hi,This has probably been answered somewhere else but I can't seem to find anything close enough to what I need (and my Excel knowledge is fairly basic)!I have a large spreadsheet that tracks various projects. When a project is complete i change the '% Complete' column to 100% but when I do that...
  19. C

    VBA Userform populates next blank row

    So I have a VBA Userform with combo boxes and textboxes. I already had the combo boxes set up to populate a cell in the workbook as an array, but I'm having problems populating the next blank row. I have it set up for data entry, so a person could enter multiple events without exiting the form...
  20. H

    Auto-updating Macro that can pull data from several files in a folder

    Hi, I am trying to make a Macro for excel 2003 that pulls data from different files in a folder, and it runs/updates whenever the file is opened so that if the files that it is referencing are updated, the values it has pulled are also updated. The macro would auto populate a column by taking...

Some videos you may like

This Week's Hot Topics

Top