Copying Data to a Specific Row Based on Date

  • Thread starter Thread starter PFH
  • Start date Start date
P

PFH

I have recorded a macro in Excel 2000 to copy data from a worksheet tha
collects daily data and paste the value to a monthly worksheet once
day. I would then like to be able to enable the macro to insert th
data into the appropriate row corresponding to the day of the month.
How can I do this? Thank you
 
you are a little skimpy on the details. What do you mean
by "appropriate" because code gets real picky.
 
By appropriate I am refering to the date in column A (1-31) which
corresponds to cells A10:A40, The data is then inserted from column B
to column P in the row which corresponds to the date in Column A. Hope
this clears it up a bit. Thanks
 
Back
Top