Hi All,

I have a clever Macro that can take the data in a File table, filter by say, a Region number, cut the data into a new Excel file and save as by Region name (or other preset name) in an output folder. It saves me hours. The challenge I have is that this raw data is all on one tab and therefore so is the output. If I have two tabs of raw data, Sheet1 & Sheet2, and a common column name – i.e Region number on both tabs, has anyone built (or can build a macro) that can do the same as above but for both tabs. So the output would be a series of new files, saved to where I need them, with a file name I can set, cut by Region number, but with two tabs of data for each Region.

Help and thanks!

​Hi All,I have a clever Macro that can take the data in a File table, filter by say, a Region number, cut the data into a new Excel file and save as by Region name (or other preset name) in an output folder. It saves me hours. The challenge I have is that this raw data is all on one tab and therefore so is the output. If I have two tabs of raw data, Sheet1 & Sheet2, and a common column name – i.e Region number on both tabs, has anyone built (or can build a macro) that can do the same as above but for both tabs. So the output would be a series of new files, saved to where I need them, with a file name I can set, cut by Region number, but with two tabs of data for each Region.Help and thanks!  Read More

​