Hello,

I have 86 separate files that analyze account volume in the 86 different sales territories. Each file has four tabs, one for each product category. I need to compile a master for the entire organization and would like to use a macro to do so. The account information begins at row 11 (column a) on each tab in the individual files. The macro would essentially need to take the cells, starting at row 11 and paste their values into the next available row in the corresponding tab (column a) in the Master file. If possible I'd also like the macro to paste back over the copied rows, in the individual files, as values as well, and then save the file under a different name in the same folder (e.g. C:\X\Y\example.xlsx->C:\X\Y\example1.xlsx where example.xlsx would be the original individual file and example1.xlsx would be the individual file with the values pasted over the formulas).

Thanks in advance for your help!