Move to match cells - 39970

My spreadsheet looks like this:

             A                     B              C
D               E
  1 000801025-8 009601025-3 2007 000801025-8 2007
  2 000801026-9 009601026-4 2004 000801026-9 2004
  3 000801028-1 009601028-6 2006 000801028-1 2006
  4 000801036-8 009601036-3 2008 000801036-8 2008
  5 000801044-5 009601044-0 2007 000801044-5 2007
  6 000801044-5 009601055-0 2004 000801055-5 2004
  7 000801055-5 009601064-8 2001 000801064-3 2001
  8 000801055-5 009601091-2 2006 000801091-7 2006
  9 000801064-3 009601095-6 2002 000801095-1 2002
10 000801091-7 009601097-8 1998 000801097-3 1998
11 000801091-7 009601098-9 2004 000801098-4 2004
12 000801091-7 009601105-2 2007 000801105-7 2007
13 000801095-1 009601106-3 2002 000801106-8 2002
14 000801097-3 009601110-6 2001 000801110-1 2001
15 000801097-3 009601111-7 2003 000801111-2 2003
16 000801097-3 009601112-8 2004 000801112-3 2004
17 000801097-3 009601113-9 1998 000801113-4 1998


D6 matches A7 so I want to move cells B6 thru E6 to row 7.
D7 matches A9 so I want to move cells B7 thru E7 to row 9
D8 matches A10 so I want to move cells B8 thru E8 to row 10.
etc.


How do I do that?


0
gcotterl
3/31/2010 8:20:40 PM
excel.programming 6508 articles. 2 followers. Follow

0 Replies
709 Views

Similar Articles

[PageSpeed] 45

Reply:

Similar Artilces:

Color a certain range of cell if a cell contain specified word
E.g a b c d e f g h 1 2 3 Group1 4 5 6 7 8 9 Group2 if a cell contain the word "Group" + a single char, i want the row which is the same the cell containing "Group" to be autohighted In tis case, it will be Cell A3-H3, and Cell A9-H9 to be auto-highlight! Put cursor on col A>format>conditional format>formula is>=left($a4,5)="group">format as desired>copy format (use format tool) to col e then copy format the row down/up as desired. -- Don Guillett SalesA...

Cell Notes
I have inherited a spreadsheet that has a cell that whenever you put the cell pointer over the cell a note pops up with a description of the cell and notes about the cell that someone apparently entered. Its not a comment and can not be edited by comments. I have never seen this before. Does anyone know how to edit these notes or delete these notes? Thanks -- Ray Maybe it's from Data|Validation|Input message tab rayd wrote: > > I have inherited a spreadsheet that has a cell that whenever you put the cell > pointer over the cell a note pops up with a description of the ...

Jumping to a hidden cell on enter
I've got 3 drop down lists in which the source cells are located i hidden rows above the data cell. Each of these 3 data cells are righ on top of the other (of the unhidden cells) and every time I use one o them and hit enter, rather than going to the next unhidden cell down it goes to a hidden cell. I can see it displaying the cell destinatio and it's contents in the input window. I try to unhide then rehide an it's always the same cell it goes to upon enter. Does anyone have an ideas about what is causing this glitch? Thanks Trace ---------------------------------------------...

Data validation master cell
Is it possible to change what list is in a cell by selecting the name o that list from a "master" cell? For instance, say the master cell is A1, and it's validation lis contains the list "cats, dogs, horses". The list in B1 would be based on what list is selected in A1. Fo instance, if A1 was set to "cats", then the choices in B1 would b something like, "Calico, Tomcat, housecat, Siamese". What I really want to do though, is only have one "master" cell an have dependent cells that change depending on the master. So, if A1 is the master,...

using seed cells and spinner
I am using office 2002. I am trying to use a spinner with a seed cell. The cell that I am trying to link it to is formated with %. How do I make it so that when you use the spinner, the %cell goes up by 1%. Ex. 1%,2%... I'd use a second cell. With A1 the linked cell, use =a1/100 and use that helper cell in further formulas???? pganeb wrote: > > I am using office 2002. I am trying to use a spinner with a seed cell. The > cell that I am trying to link it to is formated with %. How do I make it so > that when you use the spinner, the %cell goes up by 1%. Ex. 1%,2%......

How to Drag cell/=code so that worksheet name (e.g., 1,2,etc) increases sequentially?
Hello - I have an excel workbook within which I have named eac worksheet numerically, i.e., 1,2,3,4,etc... Is it possible to drag code so that the worksheet name wil sequentially progress but that the cell will remain the same? Fo example 1!$D$4 will upon dragging it become 2!$D$4? Thank you in advance! Michae -- Message posted from http://www.ExcelForum.com Hi try the following =INDIRECT("'Sheet" & ROW(1:1) & "'!D4") and copy that down -- Regards Frank Kabel Frankfurt, Germany > Hello - I have an excel workbook within which I have named each ...

Excel 2000
I keep getting the message "To many different cell formats" If I close Excel and restart it I can go for another 10 minutes and then the message comes up again and I cannot format a cell. This MSKB article helps a little. http://support.microsoft.com/?scid=kb;en-ca;213904 HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- On Tue, ...

Protect cells with formulas only
What is the best way to only protect cells with formulas in them? Many thanks -- John F Excel 2007 XPproSP2 Not sure if there is an easier way, but you can: *Select the entire sheet (you can do this by clicking on the icon above row 1 and to the left of column A) *Right click in the sheet and select FORMAT CELLS *Go to the Protection tab and UNCHECK LOCKED *Now, go back to your sheet, right click on the cell(s) you want to protect and again select format cells *Go to the protection tab and CHECK LOCKED *When you are done selecting the cells to be locked go to the ribbon and select t...

Locked cells are still able to be selected with proper protection
An excel worksheet I'm developing has rows that alternates between locked and unlocked cells. When I protect the worksheet with the option for users to select unlocked cells and format cells checked I'm still able to select and format locked cells by drag the cursor vertically from one unlocked cell to another. Is there a way to prevent this from happening? Any help would be appreciated! Hi Jesse Select the whole w/sheet < format < format cells < protection < uncheck then check locked < ok Select the areas you need to allow access Format < format cel...

Move to a specific cell on exit of current
I'd like to move to a specific cell on exit of the current cell. Can do this? Thanks -- jafo ----------------------------------------------------------------------- jafo1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2459 View this thread: http://www.excelforum.com/showthread.php?threadid=38184 Private Sub Worksheet_Change(ByVal Target As Range) Range("B3").Select End Sub Put this in the appropriate sheet module. -- Earl Kiosterud www.smokeylake.com/ ------------------------------------------- "jafo1" <jafo1.1r41ms_111958238...

PO Receipt / Invoice Match
In what GP table is the Purchase Order Receipt Number and it's matching Invoice Number stored? Thanks! Bryan Bryan, You will need the POP30310 POP30300 and possibly POP10500 This should give the required information. Mick "Banner" wrote: > In what GP table is the Purchase Order Receipt Number and it's matching > Invoice Number stored? > > Thanks! > > Bryan ...

autoformat the column of a cell area
Hi, Is there any way to format one cell are so that that the width of a cell area (something like format column width to contents) but without formating the cells above or bellow the area I want to format I have tried autoformat but it really does not give me what I want ! Somehow I cannot remove the autofilter that appears in the formated area. Thank you, best Hugo Personal.xls. Personal.xls is located in the XLStart directory, and is used to store macros and things that you want to be available to all workbooks, whenever you start Excel. By default, it is hidden in Excel, but if yo...

Matching in VBA
Hi All. Can anyone please offer some advice on where I might start to create a macro to solve the following problem: I have a series of xls files containing data each with a prefix of 1.1, 1.2, 1.3 etc. I want to take the data from each of these files in turn and paste it into a master spreadsheet. In the spreadsheet there are sheets with names that match the prefix of the downloads e.g. 1.1, 1.2, 1.3 etc. I need to macro to match up the xls file name to the sheet name to determine where it pastes the data. I have code to enable it to copy and paste the data into the sh...

chart moving on worksheet
Dear experts, I have a worksheet with data that gets updated every week and I would like to add on top of it a chart that shows an analysis of this data as changes are made. When I say on top I really mean it - I would like the chart to always show on the top right-hand corner of the screen and stay there even when the users scroll the data on the worksheet. Of course it should be possible to move the chart if the users need to. Is this possible at all in Excel 2003? Many thanks in advance for your help! Best regards -- Valeria ...

If cell contatin string like .... copy in Offset mode
Hi , and a good day everybody Please to help me with this problem : I have in a range (f or example : A1:E100 ), in different cells , numbers like in the follow format /(string) like : 12-16-18-25-33-43 ; The other cell contain another values , like : 3 , - , etc . I need a code to loop through my range cell by cell , and , IF the value of cell is in string mode like : 17-28-34-36-39-42 ( can be different numbers , but with the sign - beetwen them ) to copy them in another range , for example G1 , useing Offset function , like : Offset ( 1, 0) . A lot of tha...

Macro to copy a Cell Content automatically IF G12 cell <>""
I am having the below Macro code for moving the cursor E11,F11,E12,G11 & G12 and these cells are not protected and rest all other cells are locked (Other than M11 cell). I got this code in google web search. Now I want to add a small condition which is if a person enter any value in G12 cell then the Macro should automatically do copy the M11 cell. That’s all. M11 cell is not having any lock! Note:- The Cursor should move in this order only that is E11,F11,E12,G11 & G12. So please don’t change the cursor movement. The cursor should not move to M11 cell and all...

How to populate all cells of a column with the same comment?
Thanks in advance. Copy the cell with comment Select the target cells Right-click > Paste special > Check "Comments" > OK -- hth Max ----------------------------------------- Please reply in thread Use xdemechanik <at>yahoo<dot>com for email --------------------------------------------- "cyril" <someone@microsoft.com> wrote in message news:#KMWYg9vDHA.2456@TK2MSFTNGP12.phx.gbl... Re: How to populate all cells of a column with the same comment? > Thanks in advance. �� 38 ��������� �ļ��ߣ�Ken Wright (ken.wright@NOSPAMntlwo...

Add new line in a cell
I must be suffering from oldtimerers disease but I can't remember how to to add a new line inside a cell. I have tried various combinations of alt, shift, ctrl, enter but I can't get it. Thanks Did you try alt-enter? (Remember to toggle the wraptext setting: Format|cells|alignment tab) Rob wrote: > > I must be suffering from oldtimerers disease but I can't remember how to > to add a new line inside a cell. > > I have tried various combinations of alt, shift, ctrl, enter but I can't > get it. > > Thanks -- Dave Peterson Dave Peterson wrote:...

Hide text that doesn't fit in the cell
How can I hide the part of the text that is too long for the cell? This automaticly happens when in the cell on the right is already a text. But I want this also when there is no text in the neighbouring cell. (Note: I don't want to use wrap text) Hi see your other post -- Regards Frank Kabel Frankfurt, Germany "Rene" <Rene@discussions.microsoft.com> schrieb im Newsbeitrag news:51EBA07E-568C-4036-A64E-F6E31A1E6AC4@microsoft.com... > How can I hide the part of the text that is too long for the cell? This > automaticly happens when in the cell on the right is al...

Fill in blank cells with line above
I need to fill in the blank cells with the information from the cell above until the next cell is not null. For example: Column A Bill blank blank Bob I need the blanks to read as Bill. Is there a function or something I can use. Watch this short video: http://www.contextures.com/xlVideos01.html#FillBlanks -- Biff Microsoft Excel MVP "gleakos" <gleakos@discussions.microsoft.com> wrote in message news:11EE6E99-730E-4E10-9E5E-AE09221E19A0@microsoft.com... >I need to fill in the blank cells with the information from the cell above > until the next cell is not null....

when I add values in cells which have been calculated with percen.
I have set up a salary schedule to calculate employee/employer percentage deductions, social security contributions etc. and when adding, say the employees' contributions, the total is 1 cent too little compared to doing a manual calculation. Obvioulsy there is a rounding issue somewhere but how can I fix it ? Any sufggestions gratefully received ! Hi Have a look here: http://www.mcgimpsey.com/excel/pennyoff.html -- Andy. "David" <David@discussions.microsoft.com> wrote in message news:0B822E6D-A446-40FE-B634-C3473FB644F7@microsoft.com... >I have set up a sala...

How do I anchor adjacent cells ?
Col A of spreadsheet (the recipient) contains Anchored cell refs to another workbook (the source), and then I enter info in Col B which relates only to the cell in Col A (eg B1 to A1 etc). If I later insert rows within the data of the source workbook, and update the recipient spreadsheet upon opening it, the data in Col B no longer matches the cell in Col A. Is there any way of keeping the relationship between the adjacent cells, ie some form of anchoring, so that this does not happen? Two thoughts: 1) make sure both spreadsheets are open when you change the structure of the source wo...

How do you move an inserted picture in word 07
I have inserted a pic into my document but when I try to move it it doesn't go where I put it. It goes just above or below etc. I have turned off the snap to grid feature but still can't move stuff to where I want. How can I fix this? Inserted pictures are (by default) inserted in line with text, thus they behave much as a large font character. In order to move them around you need to select and change the wrap to something other than in line. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<...

Formatting cells for worksheet data transfer
Sheet 1 contains two columns. Each column lists a hockey roster. Column A is the "White" team. Column B is the "Dark" team. There are 22 spots consisting of regulars and numerous substitutes. Any one player may appear on "White or "Dark" from week to week. At the bottom of the rosters will appear the score from a given nights game. On Sheet 2 is a list of all players (regulars and all subs) in column A. Column B is "Wins". Column C is "Losses". Column D is "Ties". My question is: how do I format this s...

Autofilling next empty cell in column?
Other than copying formulas manually to the next row of empty cells, can a function within the preceding data entry cell do the work upon completion, <enter>, or auto summing? All cells within the range will have entries, so no isolated empty cells are present to mess up the integrity. These are scientific, engineering functions with no limit to range of entries. Having searched through several manuals and this forum, I'm not too optimistic for a solution, but keep trying... Thanks, -- Bruce McC You can create a macro that does this. Otherwise, if you double click on th...