I'm trying to make a macro that does the following:
- Asks how many new excel files you'd like to create
- Counts all of the records from the main file and divides them up evenly between the new files

For instance, my main file will likely have 500 records. If I say I want 5 files, I want it to count how many records the main file contains (500), and create 5 new files with 100 records each.

I'm very new to VBA and have no idea on the syntax to use.

Thanks,
Wire

You may use the END PROPERTY to locate the bottom last row. Look it up in the vba help file.

Use INPUTBOX METHOD to catch the number of workbooks/sheets you need. Lookup the method in vba help file.

Start the macrorecorder and create a wbk/sheet. Cut or copy/paste the content from your main sheet to the other wbk/sheet. Stop the recorder and you'll have the code you need to do the actual transfer of data.

The rest is footwork. Make the necessary calculations and loops to repeat the procedure.