|
Iowa | I can't help you much with the macro since I don't use many or know much about them. Perhaps there is some reason you have "A" and "B" in separate files. I usually put all the related sheets into one workbook that ties them all together. One of my workbooks has 17 good sized sheets tied together and automatically updating with each other. No macros are needed to do that when they are all in the same workbook. There is only one file to open, close, backup, and keep track of instead of 17 files. | |
|