I have an Excel workbook with multiple sheets. Each sheet contains a range of data located in the same rows/columns (a template of sorts). What I want to do is to design a workflow/app that will select a specified range of values from all included worksheets (i.e. Sheet 1, B2:B250; Sheet 2, B2:B250; Sheet 3, B2:B250...) and copy this range of values into successive columns on a new worksheet (or even in a new workbook).
In the ideal, I'd end up with a new sheet/book that contained successive columns, each reflecting the selected range of values on a given sheet. Is there a way to do this w/in Automator? Moreover, if this could be done, could the name of the given source sheet be copied/pasted automatically as a header for the new column on the new sheet?
Obviously, I have fiddled with this to the point of frustration. So, I now am forced to solicit more expert help. Thanks.
In the ideal, I'd end up with a new sheet/book that contained successive columns, each reflecting the selected range of values on a given sheet. Is there a way to do this w/in Automator? Moreover, if this could be done, could the name of the given source sheet be copied/pasted automatically as a header for the new column on the new sheet?
Obviously, I have fiddled with this to the point of frustration. So, I now am forced to solicit more expert help. Thanks.