| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increase rows by 1 when moving data from col. to col.
Is there a way to move data from one column to another and have it
automatically update the row number by 1? Example: Move Col-A to Col-D row 1 = BW1 row 1 = BW2 row 2 = BW43 row 2 = BW44 row 3 = BW85 row 3 = BW86 row 4 = BW127 row 4 = BW128 I'm not good at explaining what I want to do, so hopefully the example helps. And it will certainly speed up the process as I'm now having to manually change line by line and there are MANY lines. -- Gayle |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increase rows by 1 when moving data from col. to col.
Column D formula:
=LEFT(A1,2)&(RIGHT(A1,LEN(A1)-2)+1) "Gayle" wrote: Is there a way to move data from one column to another and have it automatically update the row number by 1? Example: Move Col-A to Col-D row 1 = BW1 row 1 = BW2 row 2 = BW43 row 2 = BW44 row 3 = BW85 row 3 = BW86 row 4 = BW127 row 4 = BW128 I'm not good at explaining what I want to do, so hopefully the example helps. And it will certainly speed up the process as I'm now having to manually change line by line and there are MANY lines. -- Gayle |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increase rows by 1 when moving data from col. to col.
Thanks for the prompt reply . . I'll try it. But I failed to show the
contents &BW&1, &BW&43, etc. . . . will this make a difference? -- Gayle "dhstein" wrote: Column D formula: =LEFT(A1,2)&(RIGHT(A1,LEN(A1)-2)+1) "Gayle" wrote: Is there a way to move data from one column to another and have it automatically update the row number by 1? Example: Move Col-A to Col-D row 1 = BW1 row 1 = BW2 row 2 = BW43 row 2 = BW44 row 3 = BW85 row 3 = BW86 row 4 = BW127 row 4 = BW128 I'm not good at explaining what I want to do, so hopefully the example helps. And it will certainly speed up the process as I'm now having to manually change line by line and there are MANY lines. -- Gayle |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increase rows by 1 when moving data from col. to col.
More specifically . . what I gave you was probably a little vague...
Here's some firm data: Col. AU Col. BC Col. BK Currently have I want to have I want to have Row 20204: =$BW$18372 =$BW$18373 =$BW$18374 Row 20205 =$BW$18414 =$BW$18415 =$BW$18416 Row 20206 =$BW$18456 =$BW$18457 =$BW$18458 down to Row 20243 =$BW$20010 =$BW$20011 =$BW$20012 When using what you gave me . . I received a #Value error. The Data is currently "0" or blank in all the rows being referenced = Row #18372, etc. Thanks for your help... -- Gayle "Gayle" wrote: Thanks for the prompt reply . . I'll try it. But I failed to show the contents &BW&1, &BW&43, etc. . . . will this make a difference? -- Gayle "dhstein" wrote: Column D formula: =LEFT(A1,2)&(RIGHT(A1,LEN(A1)-2)+1) "Gayle" wrote: Is there a way to move data from one column to another and have it automatically update the row number by 1? Example: Move Col-A to Col-D row 1 = BW1 row 1 = BW2 row 2 = BW43 row 2 = BW44 row 3 = BW85 row 3 = BW86 row 4 = BW127 row 4 = BW128 I'm not good at explaining what I want to do, so hopefully the example helps. And it will certainly speed up the process as I'm now having to manually change line by line and there are MANY lines. -- Gayle |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving data from multiple rows to single rows | Excel Worksheet Functions | |||
| Moving data from multiple rows into a single row | Excel Discussion (Misc queries) | |||
| Moving data in rows to columnar | Excel Discussion (Misc queries) | |||
| moving column/cell data to rows/cells fails | Excel Worksheet Functions | |||
| Splitting data in a single cell that is seperated by commas, then moving to make individual rows | Excel Discussion (Misc queries) | |||
Linear Mode
