Compare dates to copy data
 

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.
--
Thank you for your time!
John

Compare dates to copy data
 

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" wrote in message
...
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.
--
Thank you for your time!
John

Compare dates to copy data
 

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.
--
Thank you for your time!
John


"Fred Smith" wrote:

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" wrote in message
...
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.
--
Thank you for your time!
John

.

Compare dates to copy data
 

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
--
Thank you for your time!
John


"Fred Smith" wrote:

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" wrote in message
...
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.
--
Thank you for your time!
John

.

Compare dates to copy data
 

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

"Very Basic User" wrote in message
...
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
--
Thank you for your time!
John


"Fred Smith" wrote:

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" wrote in
message
...
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.
--
Thank you for your time!
John

.