mabey this will help explain my prob. on page one there are 6 cells
looking for data for that day b2....e2.....h2.....k2...etc than on
page 2 there are six more b46.......e46........h46 so on and so on for
23 pages that would be for one day ie the 14th.. on the 15th it would
be the cells right below those all other cell are doing calculations
for that day based on those numbers so ...with 23 pages and all those
single cell it would take a while to select them than run the macro
here is the formula i have in b2 right now

=IF($A1=TODAY(),Sheet1!B2,"")

does this help with what im looking for or am i confused beyond help???
lol

thanx


--
n0 h4ck1ng
------------------------------------------------------------------------
n0 h4ck1ng's Profile: http://www.excelforum.com/member.php...o&userid=18410
View this thread: http://www.excelforum.com/showthread...hreadid=395696