If you are using my button you would specify the 'copy from cell' and
the 'copy to cell' once for each item

Then each day after just click the button and it would update the line
according to the day number.

I showed only 3 lines as that was as per your sample, they were

Range("sheet2!a" & dy).Value = Range("sheet1!b3").Value
Range("sheet2!b" & dy).Value = Range("sheet1!b4").Value
Range("sheet2!c" & dy).Value = Range("sheet1!b5").Value

If you have more you would just copy a line and keep pasting and
amending to form a new line, ie, 1 copy and 3 pastes gives

Range("sheet2!c" & dy).Value = Range("sheet1!b5").Value
Range("sheet2!c" & dy).Value = Range("sheet1!b5").Value
Range("sheet2!c" & dy).Value = Range("sheet1!b5").Value

and with a small amount of typing you can amend to the required cells.

You do NOT have to select the cells before pressing the button.

You do need a range of cells that can be entered/calculated for each
Day

Does that help to un-confuse you?



n0 h4ck1ng Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395696