Excel Help - Macros question?

Asked by johnny0313x (1855

) November 24th, 2008

So I have a file with about 18,000 rows. I have to god help me – divide this file into different files separating the file in groups of 100. So I take 100 rows past it into a new sheet and save….then over and over and over til I run out of lines. This is painful….and slow. I know there is a quicker way to do it with macros but I don’t have much experience with them. I tried to record one but it kinda pasted the first 100 and stopped. Can anyone write one for me or tell me a quick suggestion. Im at work now lol

Observing members: 0

Composing members: 0

5 Answers

this is the first post on here that i have not gotten a response for within minutes…I am shocked! Have a stumped your guys?

johnny0313x (1855

)“Great Answer” (0

) Flag as…

ok I have a little experience with Excel…which edition of office are you working in?

if you create and record a macro, you can make sure the cells aren’t relative when you create the macro, which would mean, the macro will start running with the cell you have selected, not just run the macro over the same cells over and over again.

so you will have to manually select each cell every 100 cells, and run the macro with either a button you inserted, or the shortcut command key to run the macro.

RandomMrdan (7436

)“Great Answer” (0

) Flag as…

that still might make things a little easier its better then selectng all 100 at a time. I am using microsoft excel 2000

johnny0313x (1855

)“Great Answer” (0

) Flag as…

It can be done using the Visual Basic Editor. I’ll see if I can figure out the code, but might have to wait until I use the reference book at work. (If your not done by then that is)

JohnRobert (490

)“Great Answer” (0

) Flag as…

i figured it out ha thank you though :)

johnny0313x (1855

)“Great Answer” (0

) Flag as…