• 0

Automatic Splitting of Excel Files


Question

Hi Guys,

One of my daily tasks at work is to create 9 CSV files and cut and paste approx 1200 records from a master sheet into said CSV files. This is a long and boring task and I'm sure it can be automated somehow.

Essentially all I need it to do is cut from the master sheet from:

A1 - F1200

Paste into CSV A File:

D2

Save and close the file, then go back to Master sheet and delete the empty cells then continue until all CSV files are done.

Any idea how something like this would be doable?

Thanks

Chris

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0

Record a macro of you doing this once, then take a look at the code it writes and replicate it for the other files.

This sounds like it would be fairly simple to automate.

Link to comment
Share on other sites

  • 0

Wow you're so helpful!

I didn't mean to be rude but it would have taken you less time to find out how to record a macro using Google than to ask someone else to do the search for you. Macros are dead simple so just do a search for instructions.

Link to comment
Share on other sites

  • 0

I didn't mean to be rude but it would have taken you less time to find out how to record a macro using Google than to ask someone else to do the search for you. Macros are dead simple so just do a search for instructions.

While I appreciate that, I've just got into work, my Co-Workers off and I've got a thousand things to do. So I'll research this later, but it'd be nice to refresh this thread and have a few links waiting for me. Such is life.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.