software

I need help on this project; conditional formatting does not work on different sheets and I do not know how
to change the formulas or what formula to use, that will work please help.

B1 this CELL equals 09/04/2006Sheet1 D5 E5 F5 G5 H5 I5 J5 K5 L5 M5
8 09/04/2006 17/04/2006 X X X X X X X
4 10/04/2006 14/04/2006 X X X X X

I would like this result on Sheet2. It should be the extra day from Sheet1 being placed in D5 (8-7 the days of the week
in G5 to M5) and the date (Sheet1 F5 -1) into Sheet2 E5, which would put correct date in F5 (=E5 D5) which in turn would
place a (X) in G5 and H5. Also the Site Number (A5) amp; Names (B5 amp; C5) would need to be copied over from Sheet1 to Sheet2
to match the row.

Sheet2 D5 E5 F5 G5 H5 I5 J5 K5 L5 M5 D5 E5
1 16/04/2006 17/04/2006 X X

This is what each Cell contains.

A5 - SITE number (001, A6 is 002 ect..)
B5 - Last Name
C5 - First Name
D5 - This is entered number
E5 - This is date entered (09/04/2006)
F5 - formula is =E5 D5 (resulting in 17/04/2006)

The next seven are day of the week starting with Sunday -ending with Saturday. Based on the formulas in the
next CELLS a (X) is placed in the CELL for each day that corresponds with the week in each sheet.
The formula below was provided by Peo Sjoblom Thanks again.

G5 - =IF(AND($B$1gt;=E5,$B$1lt;=F5),quot;Xquot;,quot;quot;)
H5 - =IF(AND($B$1 1gt;=E5,$B$1 1lt;=F5),quot;Xquot;,quot;quot;)
I5 - =IF(AND($B$1 2gt;=E5,$B$1 2lt;=F5),quot;Xquot;,quot;quot;)
J5 - =IF(AND($B$1 3gt;=E5,$B$1 3lt;=F5),quot;Xquot;,quot;quot;)
K5 - =IF(AND($B$1 4gt;=E5,$B$1 4lt;=F5),quot;Xquot;,quot;quot;)
L5 - =IF(AND($B$1 5gt;=E5,$B$1 5lt;=F5),quot;Xquot;,quot;quot;)
M5 - =IF(AND($B$1 6gt;=E5,$B$1 6lt;=F5),quot;Xquot;,quot;quot;)

thanks

Could you please post sample data (for example on cjoint.com)

It's hard to understand what you have and what you want.

Regards,
--
AP

quot;dpatte601quot; gt; a écrit dans le message de ...
gt; I need help on this project; conditional formatting does not work on
different sheets and I do not know how
gt; to change the formulas or what formula to use, that will work please help.
gt;
gt; B1 this CELL equals 09/04/2006
gt;
gt;
gt; Sheet1 D5 E5 F5 G5 H5 I5 J5 K5 L5 M5
gt; 8 09/04/2006 17/04/2006 X X X X X X X
gt; 4 10/04/2006 14/04/2006 X X X X X
gt;
gt; I would like this result on Sheet2. It should be the extra day from Sheet1
being placed in D5 (8-7 the days of the week
gt; in G5 to M5) and the date (Sheet1 F5 -1) into Sheet2 E5, which would put
correct date in F5 (=E5 D5) which in turn would
gt; place a (X) in G5 and H5. Also the Site Number (A5) amp; Names (B5 amp; C5)
would need to be copied over from Sheet1 to Sheet2
gt; to match the row.
gt;
gt; Sheet2 D5 E5 F5 G5 H5 I5 J5 K5 L5 M5 D5
E5
gt; 1 16/04/2006 17/04/2006 X X
gt;
gt; This is what each Cell contains.
gt;
gt; A5 - SITE number (001, A6 is 002 ect..)
gt; B5 - Last Name
gt; C5 - First Name
gt; D5 - This is entered number
gt; E5 - This is date entered (09/04/2006)
gt; F5 - formula is =E5 D5 (resulting in 17/04/2006)
gt;
gt; The next seven are day of the week starting with Sunday -ending with
Saturday. Based on the formulas in the
gt; next CELLS a (X) is placed in the CELL for each day that corresponds with
the week in each sheet.
gt; The formula below was provided by Peo Sjoblom Thanks again.
gt;
gt; G5 - =IF(AND($B$1gt;=E5,$B$1lt;=F5),quot;Xquot;,quot;quot;)
gt; H5 - =IF(AND($B$1 1gt;=E5,$B$1 1lt;=F5),quot;Xquot;,quot;quot;)
gt; I5 - =IF(AND($B$1 2gt;=E5,$B$1 2lt;=F5),quot;Xquot;,quot;quot;)
gt; J5 - =IF(AND($B$1 3gt;=E5,$B$1 3lt;=F5),quot;Xquot;,quot;quot;)
gt; K5 - =IF(AND($B$1 4gt;=E5,$B$1 4lt;=F5),quot;Xquot;,quot;quot;)
gt; L5 - =IF(AND($B$1 5gt;=E5,$B$1 5lt;=F5),quot;Xquot;,quot;quot;)
gt; M5 - =IF(AND($B$1 6gt;=E5,$B$1 6lt;=F5),quot;Xquot;,quot;quot;)
gt;
gt; thanks
In Sheet2 Cell B1
=IF(Sheet1!B1lt;gt;quot;quot;,Sheet1!B1,quot;quot;)
You can actually just autofill the entire Sheet2 to Sheet2, If started from
A1 throughout.
Then you can delete the columns and/or rows you do not need.

quot;dpatte601quot; wrote:

gt; I need help on this project; conditional formatting does not work on different sheets and I do not know how
gt; to change the formulas or what formula to use, that will work please help.
gt;
gt; B1 this CELL equals 09/04/2006
gt;
gt;
gt; Sheet1 D5 E5 F5 G5 H5 I5 J5 K5 L5 M5
gt; 8 09/04/2006 17/04/2006 X X X X X X X
gt; 4 10/04/2006 14/04/2006 X X X X X
gt;
gt; I would like this result on Sheet2. It should be the extra day from Sheet1 being placed in D5 (8-7 the days of the week
gt; in G5 to M5) and the date (Sheet1 F5 -1) into Sheet2 E5, which would put correct date in F5 (=E5 D5) which in turn would
gt; place a (X) in G5 and H5. Also the Site Number (A5) amp; Names (B5 amp; C5) would need to be copied over from Sheet1 to Sheet2
gt; to match the row.
gt;
gt; Sheet2 D5 E5 F5 G5 H5 I5 J5 K5 L5 M5 D5 E5
gt; 1 16/04/2006 17/04/2006 X X
gt;
gt; This is what each Cell contains.
gt;
gt; A5 - SITE number (001, A6 is 002 ect..)
gt; B5 - Last Name
gt; C5 - First Name
gt; D5 - This is entered number
gt; E5 - This is date entered (09/04/2006)
gt; F5 - formula is =E5 D5 (resulting in 17/04/2006)
gt;
gt; The next seven are day of the week starting with Sunday -ending with Saturday. Based on the formulas in the
gt; next CELLS a (X) is placed in the CELL for each day that corresponds with the week in each sheet.
gt; The formula below was provided by Peo Sjoblom Thanks again.
gt;
gt; G5 - =IF(AND($B$1gt;=E5,$B$1lt;=F5),quot;Xquot;,quot;quot;)
gt; H5 - =IF(AND($B$1 1gt;=E5,$B$1 1lt;=F5),quot;Xquot;,quot;quot;)
gt; I5 - =IF(AND($B$1 2gt;=E5,$B$1 2lt;=F5),quot;Xquot;,quot;quot;)
gt; J5 - =IF(AND($B$1 3gt;=E5,$B$1 3lt;=F5),quot;Xquot;,quot;quot;)
gt; K5 - =IF(AND($B$1 4gt;=E5,$B$1 4lt;=F5),quot;Xquot;,quot;quot;)
gt; L5 - =IF(AND($B$1 5gt;=E5,$B$1 5lt;=F5),quot;Xquot;,quot;quot;)
gt; M5 - =IF(AND($B$1 6gt;=E5,$B$1 6lt;=F5),quot;Xquot;,quot;quot;)
gt;
gt; thanks
gt;

I posted the sample here please take a look.
cjoint.com/?esfQSjBqKXYou will need some VBA code to fill your worksheet automatically
This can't be done with worksheet functions only.

Do you want me to make a try?

--
Regards,
--
AP

quot;dpatte601quot; gt; a écrit dans le message de ...
gt; I posted the sample here please take a look.
gt; cjoint.com/?esfQSjBqKX
gt;
I was wrong: I could do it with formulaes.
See example: cjoint.com/?eskQPqwOqg

HTH
--
AP

quot;dpatte601quot; gt; a écrit dans le message de ...
gt; I posted the sample here please take a look.
gt; cjoint.com/?esfQSjBqKX
gt;
quot;Ardus Petusquot; gt; wrote in news:u3rwtQsYGHA.3848
@TK2MSFTNGP05.phx.gbl:

gt; cjoint.com/?eskQPqwOqg

this is just what I was looking for your great and fast - how long have you
been doing this for?
thanks so much