tommypayne
New Member
- Joined
- May 6, 2011
- Messages
- 3
Hi,
I'm not sure if this is possible but I am looking to run some form of macro to duplicate a workbook into separate files dependent on the contents of a column.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
I.e. a macro that looks at column B (location) and then creates multiple files based on the content for each location. Maybe best to describe as creating a separate file based on auto filter results.<o></o>
<o></o>
Please let me know if you need any more information<o></o>
<o></o>
Thanks<o></o>
<o></o>
TP <o></o>
<o> </o>
I'm not sure if this is possible but I am looking to run some form of macro to duplicate a workbook into separate files dependent on the contents of a column.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o><o
></o>I.e. a macro that looks at column B (location) and then creates multiple files based on the content for each location. Maybe best to describe as creating a separate file based on auto filter results.<o
></o><o
></o>Please let me know if you need any more information<o
></o><o
></o>Thanks<o
></o><o
></o>TP <o
></o><o
> </o>
