Tech Support banner

Status
Not open for further replies.
1 - 6 of 6 Posts

·
Registered
Joined
·
3 Posts
Discussion Starter #1 (Edited)
I have an Excel 2000 spreadsheet with approximately 600 pages of data on it. The data is presently a single column of nearly 6000 cells of barcodes. My end need for this will require me to print a hard copy to carry around with a scanner.
Is there a way to take the 6000 cells in a single column and convert it into 3-4 columns wide (see below) without manually copying and pasting for days?

Present Form

1
2
3
4
5
6
7
8

Desired form (per page)

1 9 17
2 10 18
3 11 19
4 12 20
5 13 21
6 14 22
7 15 23
8 16 24
 

·
TSF Enthusiast
Joined
·
6,298 Posts
you could probably hire someone to make you a macro that would accomplish that.

600 Pages? Wow. I hope you have at least three backups of that, as large important documents have a way of disappearing.
 

·
Registered
Joined
·
28 Posts
Fox said:
you could probably hire someone to make you a macro that would accomplish that.

600 Pages? Wow. I hope you have at least three backups of that, as large important documents have a way of disappearing.
That would take one hell of a macro...
 

·
Registered
Joined
·
3 Posts
Discussion Starter #4
:upset:


Well! Thanks for the input! I had to take a shot at it. I guess I'll be doing CTRL-C , CTRL-V in my sleep tonight. Thanks again!


Oh... I have 3 copies on 3 different drives, 1 local and 2 shared!

been there...done that
 

·
Registered
Joined
·
22 Posts
am i missing something here?

putting the mouse in the first cell, dragging down to cell 2000 = 2 seconds

putting mouse in 2001st cell, dragging down to cell 4000 = 2 seconds
cutting that selection and pasting it in column 2 = 2 seconds

dragging mouse back down to cell 4001 = 2 seconds
dragging from 4001 to 6000 = 2 seconds
cutting and pasting that selection in column 3 = 2 seconds

so you have 3 columns of 2000 instead of 1 column of 6000 in about 12-15 seconds.

am i missing something here?
 

·
Registered
Joined
·
3 Posts
Discussion Starter #6
Yeah! If I did it that way, I would have the problem of sequencing. I would have 1-20 in the 1st column and (instead of 21-40) I'd have 2001-2020 in the second column.
 
1 - 6 of 6 Posts
Status
Not open for further replies.
Top