LinkBack URL
About LinkBacks
Hello everyone.
Is there any way to paste 16000 barcode numbers so it will flow into 16 columns, 1000 in each.
Thank you in advance.
Hello everyone.
Is there any way to paste 16000 barcode numbers so it will flow into 16 columns, 1000 in each.
Thank you in advance.
To my knowledge, it would require VBA, or some other method of transforming data (such as PowerQuery).
You can't just copy and paste special to do what you are looking for.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
Welcome to the forum!
Paste your list into column A of one sheet (called "PasteList" in the attachment), then use the following formula in A1 of another sheet:
=INDEX(PasteList!$A:$A,(COLUMN()-1)*1000+ROW())
Fill right 16 columns and down 1000 rows. If you want numbers instead of formulas, just copy the results and pastevalues over them. See the attachment for a demonstration - or just replace the list on PasteList with your own:
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
CAntosh. Thank you so much. This works fine and I can stop dreaming about copy-paste everynight. Thanks again!
Glad to help, good luck!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks