• Hi Guest: Welcome to TRIBE, the online home of TRIBE MAGAZINE. If you'd like to post here, or reply to existing posts on TRIBE, you first have to register. Join us!

Excel scripting/macro help


TRIBE Member
Hey guys,

Need a bit of a hand with this one -- hoping someone here has had to do something like this before.

Ideally I'd like to move a bunch of data subsets within a master file to new workbooks with a naming convention. I'd like for this to happen automatically.

So, the name in column A(text, no other char types present) would determine the first part of the file name, while the second part would be the current month and year(numerically represented).

The active columns stretch to M, and the number of rows depends on the number of entries(so it's not static).

Does this make sense or should I give an example? Are there any free add-ins that will do this for me?

Any help would be greatly appreciated