#### when word is typed in cell, how can the row auto displays data?

```I have created a column of drop down cells in "A."  When a value for "A" is
chosen, I would like the rest of the row automatically display the associated
data.  How can I accomplish this?
```
 0
KT (80)
6/22/2005 4:35:42 PM
excel.misc 78881 articles. 5 followers.

3 Replies
364 Views

Similar Articles

[PageSpeed] 40

```Assuming the associated data is in a lookup table, say A1:H100 on Sheet2,
use

=VLOOKUP(A2,Sheet2!\$A\$1:\$H\$100,2,False)

and then repeat with offsets of 3,4, ... etc.

--
HTH

Bob Phillips

"KT" <KT@discussions.microsoft.com> wrote in message
news:3F5A2F57-D843-4DFF-9B7F-286D68645638@microsoft.com...
> I have created a column of drop down cells in "A."  When a value for "A"
is
> chosen, I would like the rest of the row automatically display the
associated
> data.  How can I accomplish this?

```
 0
phillips1 (803)
6/22/2005 4:41:32 PM
```I am afraid you are talking over my head.  Let me be more exact.

Sheet 1 is where I am entering data,  Column A consists of a list of foods.
Columns B through I give their various food values.

On Sheet 2, when I am choosing a food from the dropdown list in column A, I
would like the values for columns B through I to automatically enter into the
appropriate cells.

How do I make this happen? (In layman's terms)
"Bob Phillips" wrote:

> Assuming the associated data is in a lookup table, say A1:H100 on Sheet2,
> use
>
> =VLOOKUP(A2,Sheet2!\$A\$1:\$H\$100,2,False)
>
> and then repeat with offsets of 3,4, ... etc.
>
> --
>  HTH
>
> Bob Phillips
>
> "KT" <KT@discussions.microsoft.com> wrote in message
> news:3F5A2F57-D843-4DFF-9B7F-286D68645638@microsoft.com...
> > I have created a column of drop down cells in "A."  When a value for "A"
> is
> > chosen, I would like the rest of the row automatically display the
> associated
> > data.  How can I accomplish this?
>
>
>
```
 0
KT (80)
6/22/2005 7:00:08 PM
```As I said, with adjusted reference points,  in B2 enter

=VLOOKUP(A2,Sheet1!\$A\$1:\$I\$100,COLUMN(),False)

and copy across to column I

--
HTH

Bob Phillips

"KT" <KT@discussions.microsoft.com> wrote in message
news:6E895C31-8E40-4BF0-853E-8BE2E16D1DBB@microsoft.com...
> I am afraid you are talking over my head.  Let me be more exact.
>
> Sheet 1 is where I am entering data,  Column A consists of a list of
foods.
> Columns B through I give their various food values.
>
> On Sheet 2, when I am choosing a food from the dropdown list in column A,
I
> would like the values for columns B through I to automatically enter into
the
> appropriate cells.
>
> How do I make this happen? (In layman's terms)
> "Bob Phillips" wrote:
>
> > Assuming the associated data is in a lookup table, say A1:H100 on
Sheet2,
> > use
> >
> > =VLOOKUP(A2,Sheet2!\$A\$1:\$H\$100,2,False)
> >
> > and then repeat with offsets of 3,4, ... etc.
> >
> > --
> >  HTH
> >
> > Bob Phillips
> >
> > "KT" <KT@discussions.microsoft.com> wrote in message
> > news:3F5A2F57-D843-4DFF-9B7F-286D68645638@microsoft.com...
> > > I have created a column of drop down cells in "A."  When a value for
"A"
> > is
> > > chosen, I would like the rest of the row automatically display the
> > associated
> > > data.  How can I accomplish this?
> >
> >
> >

```
 0
phillips1 (803)
6/22/2005 10:44:36 PM

Similar Artilces:

Repeating data on matching cells
When the data column C matches the data in column A, I need the data in columns C and D to be repeated for all matching rows. For example: This is my data: a b c d 009701449-2 071712 009701449-2 071712 009701449-2 071712 009701452-4 008710 009701449-2 071712 009701455-7 008710 009701449-2 071712 009701460-1 008710 009701449-2 071712 009701465-6 058617 009701449-2 071712 009701467-8 059602 009701452-4 008710 009701468-9 059602 009701452-4 008710 009701455-7 008710 009701455-7 008710 009701460-1 008110 009701465-6 058617 0097...

Printing WORD docs from a form
I have a button on a form and I want it to print a Word mail merge document that contains data from the database that is linked to my application. I'm using the following code but always get a 5922 error - Word can't open the source... All variable names contain valid data, so that's NOT the problem. With appWord .Visible = True .Documents.Open pathdocname With .ActiveDocument.MailMerge .MainDocumentType = wdFormLetters strConnection = "DSN=MS Access Databases;" _ & "DB...

where is that save data feature for backup?
Hi All, On sql 2005, where is that console that allows me to save my data to a directory for easy backup? If I remember correctly, I can set this on a schedule too? I was shown this a few years back, and for my life I can not remember where it was. :'[ Many thanks, -T ToddAndMargo (ToddAndMargo@invalid.com) writes: > On sql 2005, where is that console that allows me to save my data > to a directory for easy backup? If I remember correctly, I can set this > on a schedule too? I was shown this a few years back, and for > my life I can not remember where it ...

problem with BOLD. ITALIC...using Word as editor
I compose a msg using Outlook. Word is the editor. I set a word in bold ot italic. I send msg to myselg, reading in Outlook. The bold or italic is gone. What to do? Thanks, Leo Are you sending the message as text only? If so all formatting will disappear. If you want to retain your formatting you'll need to send your messages as HTML. You can check this in your Outlook options. -- Martin Sketchley | www.msketchley.pwp.blueyonder.co.uk (remove EGGBEANSANDSPAM to reply by e-mail) ...

Delete all rows except...
I receive a weekly report & have been asked to delete all rows except for two particular rows. Here are the two criteria which are in column A cells: AWH98228 and AWL99467 Can anyone offer help? Thanks Try this: Sub RemoveRows() With Application .ScreenUpdating = False .Calculation = xlCalculationManual End With LastRow = Range("A" & Rows.Count).End(xlUp).Row For r = LastRow To 2 Step -1 'Headings in row 1 If Range("A" & r).Value <> "AWH98228" _ And Range("A" & r).Value <> &quo...

Windows XP: Open file in read-only: Word, Excel, Visio
I'm often sharing files on a network drive with someone. Often, one of us knows that we don't need to open a file for modification, and we only need read-access. Is there a way to open a file in read-only mode so that when someone does need to open it for modification, the read-only user is not blocking that? If there is not a way to do this native to Windows XP, is there a way to do it from the three applications that we use most, namely Word, Excel, Visio? All are 2003 versions. Thx. I used to save files like this in "read only recommended" mode. File|SaveAs|Tools|Ge...

Copy and paste to the last row
Dear ALL, pls help me for macro. I want copy the last row of column A, B and C. and Paste the row down. Example, my last row of A is A120, copy cell A120:C120. then Past to A121 Thanks so much hi if i understand correctly, this should work for you.... Sub movedownone() Dim r As Range Set r = Range("A65000").End(xlUp) r.Resize(1, 3).Copy Destination:= _ r.Offset(1, 0) End Sub regards FSt1 "tran1728" wrote: > Dear ALL, pls help me for macro. > I want copy the last row of column A, B and C. > and Paste the row down. > > Exam...

Not enough memory error trying to open a Word X file
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Error message: &quot;There is not enough memory or disk space available to complete the operation&quot; when trying to open a Word X file in Office 2008 in Leopard or Snow Leopard on iMac that works fine in Word X despite resaving a new version. Any tips? Not enough information to answer. Check that OS X and Office 2008 have the latest updates applied. Use Disk Utility to Repair Permissions. Check the access your user ID has to the system Temporary folder (don't worry about this if you ar...

hiding cells with a certian type of formatting
How do I get excel to hide cells that has not been formatted in a row or colum that I applied a format condition to.? just for clarification...do you want the entire cell row or column to b hidden, or do you want the text color of the contents of just that cel to be changed to WHITE or whatever color would hide it given its fil color -- Excel_Gee ----------------------------------------------------------------------- Excel_Geek's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2642 View this thread: http://www.excelforum.com/showthread.php?threadid=39828 ...

Cannot upgrade to Word 2007 from Word 2002 as word crashes when tr
We have a word add in that programatically inserts an auto text table then adds rows to it. This works ok in Word 2002 but occasionally crashes in Word 2007 - this is not a consistent crash when we carry out the same operation it happens in no specific sequence. The only place we are able to track it down to is the auto text table inserting rows. Word itself is crashing. We are using COM AddIn written in VB6. Does anyone know of any key differences/issues between Word 2002 and Word 2007 that could cause such an error. Or is there a better way to attach a debugger/word debugg...

Can't apply a background
I'm using the Microsoft Step by step Visio book and I'm on page 96 trying to apply a background to a practice file from the CD supplied with the book. I'm using a trial copy of Visio 2007. I can't apply a background. Is this a known bug or an undocumented feature? Many thanks, //Roger. "Roger" <Roger@discussions.microsoft.com> wrote in message news:074F084D-2BE2-44D2-BFC9-0575D492F842@microsoft.com... > I'm using the Microsoft Step by step Visio book and I'm on page 96 trying > to > apply a background to a practice file from the CD sup...

Word 2007 TOC Not saving settings...
Hi there, When I use Word 2007 TOC, and I want to edit an existing TOC layout, etc. It wont remember my settings. I go to References Table of Contents Insert Table of Contents Then I make my chnages here, such as changing the levels of the various styles and how they show up Then I select OK, the TOC is created.. I then decide I don't like the changes I made, or I need to include another style So I go to References Table of Contents Insert Table of Contents The changes I made are no where to be seen. I have to start over from scratch. What am I doing wrong,...

Macro to split the contents in a single cell separated by "," into next cell in that column
Hi, I have sheet 1: column A column B columnC WR# Phase SP# Row2 60625 1-0110 60625RB1,60625NS1,60625GW1,60625BB1 Expected Output on clicking a button: column A column B columnC WR# Phase SP# Row2 60625 1-0110 60625RB1 Row3 60625NS1 Row4 60625GW1 Row5 60625BB1 Is there a way to split the contents in cell C2 separated by comma (,) and place it on next cell in column C itself? Ple...

Encoded Word Documents
We have recently purchased a new pc with windows 7 and have installed the Microsoft Office software however when I got to open a PDF or word document from a webpage a file conversion pop up box comes up and asks for me to select the encoding that makes the document readable but none of them do. even the windows default doesn't work...... You cannot open a pdf in Word. You need Adobe Reader. What you're downloading from a web page probably isn't a Word document, either. On May 27, 4:25=A0pm, Newuser <Newu...@discussions.microsoft.com> wrote: > We have rece...

Where can I get a copy of the Microsoft calendar control?
In Excel 97 I have a calendar control. Those files with the calendar control do not work in Excel 2003, because I don'd have the calendar control in Excel 2003. Is there some type of calendar control for Excel 2003? Thank you. Shelley I think there's a link to a free calendar control at the bottom of Ron de Bruin's page: http://www.rondebruin.nl/calendar.htm shelley wrote: > > In Excel 97 I have a calendar control. Those files with the calendar control > do not work in Excel 2003, because I don'd have the calendar control in Excel > 2003. Is there some ty...

Filling in Cell above with Data from below
Have data where I need to fill in A1 with A2 Data, A3 with A4 and so on: Col A 123 XXX 345 YYY Need it to end up like: XXX XXX YYY YYY How can I do this? visit www.ExcelGoodies.com If A1 and A3 are blank: Select A1:A4. Press Ctrl+G. Click special, blank. Start typing a formula: = Then press the down arrow key. This should finish the formula and create: =A2 Press Ctrl+Enter to apply formula to all currently selected cells. If needed, you could then do a copy, paste special - values only. ======= If A1 and A3 are not blank, but you want every other line copie...

message disappears too fast; how can I see it?
Outlook 2002, SP3. I've noticed when I exit the program, as it is closing, it puts up a rectangular message box (after the main window has closed), then closes it immediately. It takes just a fraction of a second, just long enough for me to see there's something there, but not long enough to see what! If you have any idea what this could be, or how I could slow it down so I could see it, let me know. The program seems to operate correctly in every other respect, I just don't know what that blazing fast message box is trying to say. thx, Randy Randy Nevin wrote: > Out...

Bulk E-mail with Non-Word Attachment
I need to be able to send a bulk e-mail (not from a template) with attachments of a number of different document types to a group of contacts (could be from a Saved View or Marketing List). Direct E-mail, Quick Campaigns and Mail Merge do not seem to be able to do this. Is there another way? Thanks. Nope. Take a look at this blog http://groups.google.com/group/microsoft.public.crm/msg/0a84808e99645006?dmode=source&hl=en Cheers, Venkatesh ---- On May 16, 11:57 pm, DStella <DSte...@discussions.microsoft.com> wrote: > I need to be able to send a bulk e-mail (not from a tem...

auto rcvd email retrieval
Hi, 3 mos. new to this world, after a ten-year hiatus, this AM, for, starters, I'm adding a disconnected table to a burgeoning contractor's .mdb. tblMyControlNumbers shall be keyed with a string I can find in the Author property of some .docs and maybe .xls's and it looks like this: "Jim Shores_1040000, Jim Shores_1040001, _1040003, and so forth and so on. Well, yesterday, there was a online order-form field at some mail-order house that called for a .Purchase Order Number'. Which means I have recieved a email with "Jim Shores_1040029" in its body. How ...

Word Wrap: Where is it in Word 2007?
I have Googled and Googled and cannot find any page that tells me where Word Wrap is. For such a basic feature you'd think it would be under View. Suggestions? On Mon, 18 Jan 2010 18:55:28 -0600, "Gary Gary" <blah@blah.blah> wrote: >I have Googled and Googled and cannot find any page that tells me where >Word Wrap is. For such a basic feature you'd think it would be under >View. Suggestions? The reason you aren't finding anything is that word wrap is automatic in Word unless you turn it off, or possibly if something is broken. Wha...

Where are my saved word?
I open the attachment directly, it is .doc and edit it in a loong time, what I ask is when I press save button and it show nothing so I think it succes. And I close it!! I can't find it now, could you help me ????? Thanks! It is gone. When editing an attachment, you /must/ save it to your HDD first, edit it and then reattach it. -- Bruce Hagen MS-MVP [Mail] Imperial Beach, CA "smezsc" <smezsc@discussions.microsoft.com> wrote in message news:3AF0D07A-D490-4819-A649-1C5FC079027F@microsoft.com... >I open the attachment dire...

Does Office 2003 Pro Excel have auto-save?
I am trying to set up Auto save in Excel 2003 Pro. I found auto recovery but that is not what I am looking for. I think it may be an add-in. Thanks! ehop, From a previous post by Dave Peterson: If you're running xl2k or earlier, install the autosave addin via windows|Start button|settings|control panel|Add or remove programs If you're running xl2002+, then if you can find a copy of the autosave addin from an earlier version, it should work ok. But xl2002+ has something called autorecovery. It's not the same as autosave, but will allow you to recover files if excel/windows c...

Data, Group got error message Cannot shift object off sheet
I created a command grouping several columns together by going to Data, Group. When I go to click on the "-" sign to group. It gives me an error message;"Cannot shift object off sheet". Why? and how can I fix it. Maybe you have some objects that get rearranged when you hide the columns using your grouping symbols. This may have some suggestions that work for you. It's kind of a similar problem. XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default.aspx?scid=kb;en-ca;211769 Remember to look for comments and merged ...

maximum rows limitation in an access 97 table
we have an access97 db which has 32405 rows, is there such a limit of 32700 rows in access 97 and if there is, can this be rosolved by upgrading to Access 2000 or higher. > is there such > a limit of 32700 rows in access 97 No, the limit is that the database cannot be larger than 1GB. Check out other specifications in Access Help, using "specifications" as a search criterin in the Search Wizard. -- Cheryl Fischer Law/Sys Associates Houston, TX "GM" <anonymous@discussions.microsoft.com> wrote in message news:07b501c3aadf\$4d6d6630\$a001280a@phx.gbl... >...

word 2002 compatibility with Windows 7
My niece is handicapped and her new computer has Office 2007 on it. She would like me to install word 2002 on her Inspiron 546. Is this possible? Yes, if it is licensed for another computer. If it is an OEM version, it cannot be installed on any but the system with which it was sold. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Sharon F" <SharonF@discussions.microsoft.com> wrote in message news:216DC8A6-4282-46A1-876D-B4D76E793F33@microsoft.com... > My niece is handicapped and her new computer ...