I have cells which will read values only on certain dates, after the date
changes, the values dissapear and the new values are entered. But I need to
capture the values on a daily basis ( copy - paste - values only) from one
sheet to another in the rows matching a certain value ( Julian Dates - in row
499)

First the code needs to check the (Today()) cell in A1 sheet1 ( witch is
calculated in JULIAN DATE CODES ( 1-365)
then it should :

In sheet1 - Find /or match cell in row 499 ( column c through IV) which
equals (this value- Julian date)
Then copy rows 500 to 540 under matching Julian date from this column and
paste values in sheet2 to rows 36 - 76 in matching Julian date column.

I have a button ready (send data) which I would assign the macro to .
Can I also have the data entry cells (A151 - A300) cleared after this button
has been activated - ready for the next day

How would I go about doing this?
Thank You for your help in advance.