Hello.
I am trying to create a macro in Excel that will copy some fields in multiple pages (the fields are the same in all the pages)into fields in one other page. The problem is that the pages I am copying from are not a fixed number. I could have four worksheets, or two worksheets, etc. and the names will also change. The only good thing is that these pages will always be inbetween two stationary worksheets. I am wondering how to do this.
I am trying to create a macro in Excel that will copy some fields in multiple pages (the fields are the same in all the pages)into fields in one other page. The problem is that the pages I am copying from are not a fixed number. I could have four worksheets, or two worksheets, etc. and the names will also change. The only good thing is that these pages will always be inbetween two stationary worksheets. I am wondering how to do this.
