Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Fastest way to do this?
I have 10000 logins and their respective passwords. Logins are in col A and
passwords are in B. Logins contain serial no. like LGN00001 to LGN10000 What I want is to have the first 200 logins/ pwds on the first page like 1 to 50 in col A,b then 51 to 100 in C,D then 101 to 150 in E,F and 151 to 200 on G and H, The same thing is repeated for the rest of logins. 201 to 250 on A,B etc. any cool macro would help. thx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros or the Fastest way to Autofill Rows | Excel Discussion (Misc queries) | |||
Repeating a Cell Format For Many Rows: What's Fastest Way? | Excel Discussion (Misc queries) | |||
What is fastest for this? The Small VBA or many Worksheet Functions...? | Excel Worksheet Functions | |||
What is fastest way to print labels from Excel data? | New Users to Excel | |||
Fastest Way to Filter/Delete | Excel Worksheet Functions |