If you post your macro code we will be in a better position to assist
you.

Generally speaking, you will have lines in your code containing
phrases like:

Sheets("Sheet3") etc

and you will need to change these to:

Sheets(my_sheet)

where my_sheet is a text variable that is built up into the sheet name
that you want to reference.

Hope this helps.

Pete

On Mar 17, 3:05*pm, Coni wrote:
Is it possible to do a macro to update information between the following
situation.
1 - Journal Spreadsheet - same every week - needs to be updated in cells J2,
J5, J8, etc. - every 3rd cell with information from spreadsheet 2.
2 - Payroll Spreadsheet - different every week - information in column H -
cells H13, H14, H15 update cells in spreadsheet 1 - i.e. H13 to J2, H14 to
J5, H15 to J8, etc.

When the new payroll spreadsheet (spreadsheet 3) comes into play, it has a
different name because of the date i.e. Payroll 2-15-08 - my macro only works
from Spreadsheet 1 to Spreadsheet 2 - when Spreadsheet 3 comes into play - is
there a way to do a macro to use this new information to go into Spreadsheet
1 - the Journal? *Can this be done when it has a new name (different date)?

I know about the + and = signs to update/change information from one
spreadsheet to another - that is how I wrote my first macro. *The cells we
need to use for the upated information are in the same location every week.. *
Spreadsheet 3 creates the problem....

Or is there a better way? *Thanks for any input!
--
Coni