Excel Macro Covering Undetermined Number Of Worksheets

[SandraF]

Hello.

I want to use a macro to update certain fields on mutliple pages. (They will be the same fields on all the different pages). The problem is that the number of worksheets I will have will change everyday and the names of the worksheets will also change. The one thing that will not change is that all of these worksheets that I want updated will be betwwen two stationary worksheets that will never change.

 

[Dreamboat]

What is the name of the field?
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[SandraF]

The name of the field is called Invoice Date (A14) & Invoice Amount (F14). They are the exact same on all the pages. I have one worksheet that will list all this information line after line when you click on the macro. Right now I have one worksheet for each contractor, and list the invoices in those worksheets under the specific contractor.