IF Function
 

If a Cell in Column A is Blank Paste Cell J From the same row to make a
summary page.

ie Date
A J
1 500
2 500
3 500
4 500
Blank (500) Paste this one
6 600
Blank (600) Paste this one
8 700


ie Summary
500
600
ect..

IF Function
 

Use AutoFilter.

You can filter column a to display only rows with blanks in column A. These
rows can then be copied elsewhere.
--
Gary''s Student - gsnu200755


"Terry" wrote:

If a Cell in Column A is Blank Paste Cell J From the same row to make a
summary page.

ie Date
A J
1 500
2 500
3 500
4 500
Blank (500) Paste this one
6 600
Blank (600) Paste this one
8 700


ie Summary
500
600
ect..

IF Function
 

Thanks for the reply gary but this is not exactly what im looking for.
The data is already summarized and i could copy and paste the results into
the summary page quite easily.
The problem arises because the data changes each week, for this reason the
summarys i need are in different cells each time.

Im looking for a formula which will take the summarized data from each week
and put it into the summary sheet. I guess I probally should have mentioned
this in advance.


"Gary''s Student" wrote:

Use AutoFilter.

You can filter column a to display only rows with blanks in column A. These
rows can then be copied elsewhere.
--
Gary''s Student - gsnu200755


"Terry" wrote:

If a Cell in Column A is Blank Paste Cell J From the same row to make a
summary page.

ie Date
A J
1 500
2 500
3 500
4 500
Blank (500) Paste this one
6 600
Blank (600) Paste this one
8 700


ie Summary
500
600
ect..