Glad it worked for you - thanks for feeding back.

Pete

Problems with formula within worksheet wrote:

Thanks it worked great and I am able to apply that to several othe places in
the worksheet.

"Pete_UK" wrote:

One way of doing it is to use Find & Replace a few times, as follows:

Highlight the formulae in the monday column and press CTRL-H. You want
to:

Find What: = (i.e. the equals sign)
Replace With: x=

This will turn the formula into text, i.e.:

x=Mon.!B7 etc.

Then click <copy on these highlighted cells and click over to
highlight the cells under Tues, Wed, Thurs and Fri and press <enter to
copy the "text" formulae across. Then highlight each of these columns
in turn to;

Find What: Mon.
Replace with: Tues.

and so on. Once you have done this up to Fri, then highlight all the
formula cells (including monday) and:

Find What: x=
Replace With: =

An alternative (formula) way is to use the INDIRECT function, but as I
imagine this is a one-off the Find & Replace method is just as good.

Hope this helps.

Problems with formula within worksheet wrote:

Here is more information. I want to copy the formula under mon over to tues,
wed, thurs and fri so that when it is copied is has the word tues, wed,
thurs, fri in place of mon. The worksheet picks its info up from seperate
workbooks for each day of the week. Is it possible?????
Mon Tues Wed Thurs
Fri

5537 Straight T =Mon.!B7 0.00 0.00 0.00 0.00
5537 Overtime =Mon.!C8 0.00 0.00 0.00 0.00
5537 Pre. Wage


"Problems with formula within worksheet" wrote:

I have a payroll worksheet that takes data from mon, tues, wed etc and puts
it in a master worksheet. Right now I take that info and hand write it onto
a time card. I am looking for a way to complete a worksheet so I can stop
writing. I will send a copy of the worksheet to anyone that wants to take a
stab at helping me fix this dang thing.

Debbie