Move to match cells - 104077


            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 down to row 7.
D7 matches A9 so I want to move cells B7 thru E7 down to row 9
D8 matches A10 so I want to move cells B8 thru E8 down to row 10.
etc.


How can I do that?

0
gcotterl
3/31/2010 9:32:08 PM
excel.programming 6508 articles. 2 followers. Follow

0 Replies
753 Views

Similar Articles

[PageSpeed] 19

Reply:

Similar Artilces:

formatting numbers in cells
Hi. I tried to format a group of horizontal cells by going to format celss, then entering the following: number, 2 decimal places, $ sign and then (2,184.10). I clicked on okay. What I ended up with was the correct formatting in the last cell, and the rest of them have #### in the cells. Can someone tell me why this happened and how to correct it? Thanks! one reason for #### is that the cell isn't wide enough for the format specified. Try widening the columns. In article <2ee201c40087$e561bfb0$a601280a@phx.gbl>, "Mary Jo" <anonymous@discussions.microsoft.com&g...

Filling cells in between pairs of numbers
Hello all, I am trying to find an easy way to fill in cells in between pairs of numbers each of which is exactly the average of the pair's difference averaged by the number of these cells greater than the previous. So I have 1 1 2 3 4 8 5 6 7 8 20 9 10 12 13 14 15 45 I want: 1 1 2 3.333333333 3 5.666666667 4 8 5 11 6 14 7 17 8 20 9 23.57142857 10 27.14285714 11 30.71428571 12 34.28571429 13 37.85714286 14 41.42857143 15 45 I know I can do a Fill, Series, but then even with a macro that does a "control shift up fill series enter",...

Moving a Bound Object Frame Control
I have a Bound Object Frame control that was created by Auto-Form to display line drawings I created using Paint, and then inserted into an OLE field in the table that Auto-Form used to create the form. I cannot change the properties of the control using VBA code. Particularly I'm concerned about moving the control and making it visible and invisible. Whenever I start the command "Me.ControlName." no properties come up to change A response from a previous question indicated that I may need include some additional references, but i have no idea what to include. Any hel...

Vlookup, Index or Match
I posted this yesterday ... could not see ... so reposting it again Hello All, I am using Office 2003 and have the following problem: Sheet PROD (figures for example purpose only- it can be numeric or alpha numeric) Col B Col H 1 Mar-07 123 2 xx xx 3 xx xx 4 Mar-07 345 5 xx 6 Mar-07 678 7 Apr-07 910 8 xx xx 9 Apr-07 122 .... .... .... Below there are other months also...Col B will go down for a complete year. i.e. probably 500 Rows down. I have a Sheet name REPORTS where I wish to have the information from Sheet PROD when I input the Month ...

Merge Cells not available
I am attempting to merge cells in a spreadsheet, but the Option to merge both on the toolbar and in 'Format'-'Cell' are greyed out. My worksheet is not protected. Every Worksheet in the document acts the same. If the workbook is shared (Tools, Share Workbook) merging cells is not allowed. -- Jim Rech Excel MVP "Flash24" <Flash24@discussions.microsoft.com> wrote in message news:BB8D4738-3CD6-4575-B44E-02FA32D88B9B@microsoft.com... |I am attempting to merge cells in a spreadsheet, but the Option to merge both | on the toolbar and in 'Format'-'...

Objects copied when resizing/moving multiple objects
When I try to resize or move multiple objects in a powerpoint file, the objects are all copied. What is causing this, and how can I stop it? I use Powerpoint 2003 on a computer with Windows Vista. See if this helps: Office shapes move or duplicate themselves when I click them (VISTA) http://www.pptfaq.com/FAQ00882.htm Lucy -- Lucy Thomson PowerPoint MVP MOS Master Instructor www.aneasiertomorrow.com.au "quietchick" <quietchick@discussions.microsoft.com> wrote in message news:79F9A07E-525E-4F8E-98C5-9A83C5B0443A@microsoft.com... > When I try to ...

lock first row and first column WITHOUT selecting Cell "B2" first?
Hi, I'm new to this group. From a VB6-Program I create a new workbook with 1 worksheet. After writing the title row I want to set the first column and the first row non-scrollable. This is my actual code in the VB6 program: ws.Range("B2").Select ActiveWindow.FreezePanes = True I tested it, it works. My Question: is there another way to do this WITHOUT selecting the cell first? Doing it with an non-active window? I've searched to no avail, but probably haven't asked the right questions or used the correct terms. (English isn't my first lang...

I need to split a cell into 4 cells and keep in the same column
Data | Text to Column ? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "dc" <dc@discussions.microsoft.com> wrote in message news:251EEB9F-0B6B-439B-B81E-BEECDA1D5B75@microsoft.com... > With the amount of detail provided............... How about a guess? You have 4 words in A1 and want them placed in A:A4 Select A1:A4 and Edit>Fill>Justify Gord Dibben MS Excel MVP On Tue, 19 Sep 2006 13:02:02 -0700, dc <dc@discussions.microsoft.com> wrote: Not much to go on. You say "split" so I presume that you want only a p...

Sort Treats Empty Cells As Largest Value??
I have several projects that sort data from greatest to least (descending). That is, nothing is considered greater than a million. Of about 4000 rows between a third and a half are blank (no count). I need the maximum values/count at the top of the list, but Excel puts these empty cells at the top of the list. As a result I have to do a lot of moving of large groups of data around to put the empty/blank cells at the bottom of these lists -- a real time consuming pain. Is there a way to have Excel treat empty/blank cells as having lower values than cells with values? I assume I could f...

Count if cell contains a comma
I want to count the cells which contain a comma. Is it possible to do something like: =COUNTIF(B2:B53,FIND(",",B2:B53)>0) -- Thanks, Fred Please reply to newsgroup, not e-mail =COUNTIF(B2:B300,",") Try this out ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements On Sun, 7 Dec 2003 20:02:29 -0600, "Fred Smith" <fredsmith99@yahoo.com>...

HIdden Cells?
I would like to be able to hide columns automatically in a spreadsheet if no data was entered in the cells for that column without having to highlight the column and choosing hide. Eg: The spreadsheet has column headings, but for printing purposes I would like to hide that column if no data has been entered under any number of headings. Is there anyway this can be done automatically? Thanks for your help I wouldn't do it automatically when printing, but I would use a macro that I could run on demand: Option Explicit Sub hideCols() Dim iCol As Long With ActiveSheet ...

Exact number of digits in a cell
Sorry to post simple question in this forum but I need to use a function key to check if the correct number of digits are in a cell. I presume it would work such as 6 digits entered True, 4 or 7 False. I have tried a number of books but am struggling a little. Help very much appreciated. Roger You can use the len function to return the # of characters in a cell. i.e. =if(len(a1)<>6,"You entered the wrong # of characters","You entered the right # of characters") ----does the following if a1 does not equal 6, says you entered the wrong # otherwise says you en...

excel locks up after selecting a cell
I have a laptop...so the problem is not a scrolling mouse wheel.....when I select a cell in the workbook it will not let it go....as I move the mouse around it keeps selecting all the sells as if i have the mouse held down....do not appear to have a key stuck either......however...when the cell is selected...(before i click the cursor in a cell) i can move around to different cells with the arrow keys and it only selects one cell at a time...like it is suppose to...as soon as I click with the mouse the whole spreadsheet continues to be selected wherever i move the mouse...even if i mov...

Continuall Add ing values in a cell
Hi Everyone- I suspect that this question has been asked before but it is difficult to know how to find the correct thread. That being said, here it goes. I would like to make a cell continually add values entered into them. For example, I have a cell that has a value of $12.37 and I have to add to it a new value as I encounter it, lets say $8.73. As it stands know, I pull out my trusty calculator andsum up the two values and key in the sum into the field. I have a pile of recites that I need to add as they come up. Any help is greatly appreciated. Manuel A. Ayala CAD Concepts...

Save as CSV file leaves CELLS content between quotation marks
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Oke I have something really weird, <br><br>Normally when you &quot;save as&quot; and choose CSV or Txt, each cell is divided by a comma (period) but the contents of a Cell is not between quotation marks. (windows) <br><br>Now on mac: When I choose UFT-16, TXT windows format, CSV windows format or Mac format. All these options leave a file where my cell contents are between quotation marks. I do not want that!!! How can I get rid of them....? <br><br>gr <br><br...

How do I match 2 items in excel to return a unique value?
For example, how do I match product codes and warehouses to return an unique price? It is a lot easier to answer a question like that if the rows and columnns data is provided. After all, nobody on this side of the server can see your worksheet. "Stumped" <Stumped@discussions.microsoft.com> wrote in message news:DF1EE951-D4F8-48AA-8040-4305FD948EB5@microsoft.com... > For example, how do I match product codes and warehouses to return an > unique > price? You are way to vague with your post. We need more details of what you are trying to ac...

Moving rows with Hyperlink doesn't move hyperlink address
When I Hyperlink cells to another sheet's cell and when I move data to other row/ column or I insert rows/column it does not move hyperlinked address. Can anyone advice me how to move hyperlink address with insert/move rows/column/cells. Thanks Hi the HYPERLINK always refers the cell position but not the content of this cell. So you can't do it this way "Samad" wrote: > When I Hyperlink cells to another sheet's cell and when I move data to other > row/ column or I insert rows/column it does not move hyperlinked address. > > Can anyone advice me how...

Moving data across columns
Hello Everyone, I hope someone can help me. I have a file containig contact informatio with all the data in column 1 i.e. name in cell A:1, complete addres in cell A:2, phone number in cell A:3. I need the data in a database format i.e. name in A:1, address in B:1 city in C:1, zip in D:1 and phone in E:1. I have about 1,500 files s the Macro would have to move down and repeat the process. Also, since A:2 contains the full address, the macro should also brea apart this information so that the city, state and zip is in its ow field. I may need two separate macros to accomplish this. Does a...

Exchange 5.5 to E2K3 Large mailbox moves
What is the expected time for large mailbox moves, from Exchange 5.5 to E2K3; ie. Large Gig mailboxes of 1, 2, 3, 4 and over, is there an expected time to move, and ould Ex-merge be a better process then the Exchange Wizard? -- Al On Tue, 4 Oct 2005 06:34:21 -0700, "Al Morales" <AlMorales@discussions.microsoft.com> wrote: >What is the expected time for large mailbox moves, from Exchange 5.5 to E2K3; >ie. >Large Gig mailboxes of 1, 2, 3, 4 and over, is there an expected time to >move, and ould Ex-merge be a better process then the Exchange Wizard? Exmerge w...

Explain INDEX MATCH
Can someone please explain the Index, Match formula to me? It is used in a spreadsheet and I need to understand it. Thank. Nadine wrote: > Can someone please explain the Index, Match formula to me? It is used in a > spreadsheet and I need to understand it. Thank. http://www.contextures.com/xlFunctions03.html There are many different potential ways to write a formula using Index and Match. If you post the specific formula, it may help someone explain the usage further. Very briefly the syntax for Index is (Array,Row num, [Col num]) Thus Index(A1:A5,3) would re...

using named cells across worksheets
I've named various cells after producing a multi-worksheet model. The named cells can be applied in the worksheet they are in but I can't see how to apply them across other worksheets. At the moment, the only option I can think of is manually updating every formula in all the connected worksheets! Any ideas. Nick You defined the names so that the names included the worksheet name, too? Sheet1!test sheet2!test .... Sheetx!test Then you can just use them by making sure you include the complete name: =sum(sheet1!test,sheet2!test,sheetn!test) Is that what you meant??? Nick Malon...

Calculating from last inputted cell
I am trying to write a formula to input the data from the last inputted cell in a range to another cell. Reading through some earlier threads I found a formula that works in 2 stages, the first finds the last inputted cell to return the cell reference, and the 2nd stage reuses the result, the formulas were =MAX(ROW($A$1:$A$200)*($A$1:$A$200<>"")) If the above formula was entered into cell B1 the 2nd formula would be entered in the cell where I wanted the data displayed and would be =INDEX($A:$A,B1) The 2 formulas work providing the entered data starts at row 1, my p...

How to auto-enter date when cell is clicked?
My spreadsheet is on a shared server, and has several columns of data entered by various people. These are columns D through L. In the far right column, I want them to just be able to click on the cell and that day's date appears. It needs to be static - not auto-update every time the file is opened. It's in Column L. The top cell is in Row 4. When they enter or change data on a row, the date they did it needs to appear in column L in that row. The point is to keep their data entry time to an ABSOLUTE minimum. I know they can select the cell and type control-;, but I'd like to e...

count cells in autofilter
while working in an excel spreadsheet, i use the autofilter tool to sort data. on some spreasheets it will list the total number of items found from the autofilter (ie., 10 of 15 records found. How do i get this to display automatically each time? If your list has many formulas, the Status Bar might show "Filter Mode" instead of a count of the visible records. You can use the Subtotal function to count the visible rows. The Status Bar may also show 'Filter Mode' if a cell in the list is changed, after a filter has been applied. The following MSKB article has inform...

cell value plus text
I would like to know how to get the value from one cell (C81) entered into another cell (N81) and then have text after that value. For example, if C81=2, I need N81 to have 2 plus text (2 oranges). If this is not possible, I do have the text in the first row and could reference that cell, but then would need to know how to string the two cells of text together (i.e. C81=2 and C1=oranges so N81=2 oranges). Try one of these: =C81&" oranges" Or, using a cell to hold oranges: C1 = oranges =C81&" "&C1 -- Biff Microsoft Excel MVP "Deanna" <...