Increase rows by 1 when moving data from col. to col.

G

Gayle

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.
 
G

Gayle

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?
 
G

Gayle

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top