Compare dates to copy data

[Very Basic User]

Help please... How would I get the following to occur. (Sheet 1 cell A1 =
2/22/10 when I run macro, look for 2/22/10 on sheet 2, and copy an area from
sheet 1 to the appropriate area of sheet 2. So each time sheet one date
changes, it copys the same area of sheet one into the correct area of sheet 2
that matches the date.

 

[Fred Smith]

If it was me, I would do the following:
1. Turn on macro recorder.
2. Go to Sheet2, filter the data for the date you want.
3. Copy the data to its destination.
4. Turn off macro recorder.
5. Modify the macro the pickup the data filter from cell Sheet1!a1, and the
destination.

If you need help, with step 5, let us know. Post the macro code when you do.

Regards,
Fred

 

[Very Basic User]

Thank you for answering! So when you say in step 2 to filter the data for the
date I want, what do you mean? Sorry, I am very new at this.

 

[Very Basic User]

PS: I got the filtering thing, but I have many totaling lines that make
filtering not available for a date range, I would have to remove the rows
that total each week and they feed into a monthly graph summary

 

[Fred Smith]

What identifies a total row? If, for example, it's the word "Total" in
another column, then you could use that to filter out those rows.

The other thing I'd investigate are Pivot Tables. They are very powerful and
easy to use. They would move your totals to another sheet, which would clean
up your data. Generally, you're better off having only data in one
spreadsheet, with summaries and graphs in others.

Regards,
Fred