Macro for Excel - Help Needed

**dominic21** · 01-14-2012, 12:25 AM

Please Login or Register  to view this content.

Here's what I have so far. Ideally I want it to do the following things:

-Save the Range("A1:B50"), then Range("A51:B100"), then Range("A101:B150") and so on.

- I want each of them to save as an individual .CSV file, with the file names increasing in integers of 1.

Any Excel Macro wizards out there? I would love some help with this, thanks.

**JieJenn** · 01-14-2012, 12:49 AM

I create a macro based on your criteria. The macro will first look the last row of column A, and decide how many csv files to produce. For instance, if there is 300 items, then the macro will produce 6 files (300/50 = 6)

Look at the sample file and see if that is what you're looking for. You might need to change the directory url.

Here is the code if anyone is interested.

Please Login or Register  to view this content.

**shg** · 01-14-2012, 12:57 AM

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

**dominic21** · 01-14-2012, 01:28 AM

Originally Posted by JieJenn

I create a macro based on your criteria. The macro will first look the last row of column A, and decide how many csv files to produce. For instance, if there is 300 items, then the macro will produce 6 files (300/50 = 6)

Look at the sample file and see if that is what you're looking for. You might need to change the directory url.

Here is the code if anyone is interested.

Please Login or Register  to view this content.

It works in the sense that it creates 6 csvs, but they all contain the 300 original rows. I need it to take 50 and separate it basically.

**JieJenn** · 01-14-2012, 02:54 AM

It is actually more complicated than I thought. Took me awhile to come up with an inefficient solution. Same file, but try this code.

Please Login or Register  to view this content.

**pike** · 01-14-2012, 03:35 AM

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc