auto-populate

Hi! I've just been Googling excel forums trying to find a way to do this. I just want to make a cell auto-populate a body of text based on a dropdown menu selection. I know how to do that, though... However, I want to be able to EDIT the text that populates...and I DON'T know how to do that...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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