Search : in
By :

Copy one row plus

Bob, on Oct 20, 2009 10:12:44 am BST 
 Report this message to moderators

Hello,
I am trying and failing to copy rows to another location with multiple copies but only want to advance one row at a time. For instance I have information in row 1thru 10 cells A thru E. I want to this information to Row 20 thru 40 cells f thru J. What I'm trying to do is copy the original line 1 cell a thru e to the new location then copy those cells to a second location but without multiple jumps. What I'm trying to end up with is row 1 in 20, row 2 in 22, row 3 in 24, etc. This is simplified the actual rows and cells are much greater but if this can be done I can I can adapt. Thanks for the help, Bob

Configuration: Windows XP Internet Explorer 7.0

Best answers for « copy one row plus » in :
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Transforming columns into lines ShowTransforming columns into lines Example Limitations It is endemic for most Linux tools to work with lines, but not with columns (sed, awk, grep, etc..). However, it may happens,that you have a file where the data should be read in...
Copy rows based on a condition ShowCopy rows based on a condition Issue Solution Note Issue How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I've tried almost everything but...