My guess is that there is a possibility to write a formula that would be in column D, and maybe also in column E, that would copy and paste the data into columns D and E when there is a name both columns B and C. This would make the copy and paste automatic instead of manually copying and pasting.
The formula would say if there was a name in column B and C then copy A and B into D and E. Walter On Tue, Oct 27, 2009 at 2:30 PM, Walter Hildebrandt <[email protected]>wrote: > Johnny, you are correct that sorting does "compact" columns D and E. The > problem still remains how to get the data out of columns A and B into > columns D and E. If it is not possible to get the data out of columns A and > B, then it is a help knowing that columns D and E can be "compacted by doing > a Sort. (I can manually copy, one row at a time, the rows in column A and B > that also have a name in column C, into the same row in column D and E, and > at the end Sort to "compact". When a lot of rows are involved it is easier > to paste on the same row and at the end doing a Sort. As compared to going > up in columns D and E and "compacting" as each row is Pasted. > > Walter > > > On Tue, Oct 27, 2009 at 12:16 PM, Johnny Rosenberg <[email protected] > > wrote: > >> Well, the simple answer would probably be to sort columns D and E. >> >> Johnny Rosenberg >> >> >> 2009/10/26 Walter Hildebrandt <[email protected]>: >> > My question is, how can I do the following? >> > >> > There are 200 rows involved. The following explains the question. >> > >> > Cell A1 has the number 1 in it, cell A2 has 2 in it, cell A3 has 3, cell >> A4 >> > has 4 >> > >> > Cells B1 has the name name1 in it, cell B2 has name2 in it, cell B3 has >> > name3, cell B4 has name4 >> > >> > Cell C1 is empty, C2 has hame2 in it, cell C3 is empty, C4 has name4 >> > >> > The 2 from cell A2 is copied into cell D1 and name2 from cell B2 is >> copied >> > into >> > E1 Also the number 4 in cell A4 is copied into cell D2 and name4 from >> cell >> > B4 is copied into E2. >> > >> > In other words when both Columns B and C have the same name in them then >> > columns A and B are copied to columns D and E and everything that is >> copied >> > is "compacted" so there are on empty rows between what is copied into >> > columns D and E >> > >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> >
