When requesting a report on my database it saves to excel leaving blanks.
Using sumproduct I can not copy my formula down the column because it seems
that the blank spaces copy the previous adjacent answer until a non blank
result comes up in the column. How can I fix this. I tried copy/paste with
skip blank but that did not work.

I think you'll need to give some more details.

What are you actually trying to do?
Copy non-blank records to another area?
Something else?

Can you post:
Some sample data from the database
The formula you're using that's not working


***********
Regards,
Ron

XL2002, WinXP


"asg2307" wrote:

When requesting a report on my database it saves to excel leaving blanks.
Using sumproduct I can not copy my formula down the column because it seems
that the blank spaces copy the previous adjacent answer until a non blank
result comes up in the column. How can I fix this. I tried copy/paste with
skip blank but that did not work.

If you want to remove blank cells, select the range, press F5, click special
and select blanks, press Ctrl + - (Ctrl key and minus key) or editdelete,
then select entire row or select shift cells up depending on if there are
rows where the blanks are that have values in other columns


--
Regards,

Peo Sjoblom



"asg2307" wrote in message
...
When requesting a report on my database it saves to excel leaving blanks.
Using sumproduct I can not copy my formula down the column because it
seems
that the blank spaces copy the previous adjacent answer until a non blank
result comes up in the column. How can I fix this. I tried copy/paste
with
skip blank but that did not work.

Here is the formula I am trying to copy paste down the column. DATA07-05 has
bank spaces on some lines due to nothing to report. There are numerous
blanks throughout the report. I will uses this formula for several columns
but I change the column search criteria. I normally don't have a problem
when the report is populated with a number. I hope this better explains this.

=SUMPRODUCT(('DATA07-05'!$A$7:$A$446=GA!$A4)*('DATA07-05'!$C$7:$C$446=GA!$C$4)*('DATA07-05'!$D$7:$D$446=GA!$A$1)*('DATA07-05'!$J$7:$J$446))

"Ron Coderre" wrote:

I think you'll need to give some more details.

What are you actually trying to do?
Copy non-blank records to another area?
Something else?

Can you post:
Some sample data from the database
The formula you're using that's not working


***********
Regards,
Ron

XL2002, WinXP


"asg2307" wrote:

When requesting a report on my database it saves to excel leaving blanks.
Using sumproduct I can not copy my formula down the column because it seems
that the blank spaces copy the previous adjacent answer until a non blank
result comes up in the column. How can I fix this. I tried copy/paste with
skip blank but that did not work.

Rows that have blank cells have data in other cells in different columns. I
can not elininate or move the data. Will what you describe still work?

"Peo Sjoblom" wrote:

If you want to remove blank cells, select the range, press F5, click special
and select blanks, press Ctrl + - (Ctrl key and minus key) or editdelete,
then select entire row or select shift cells up depending on if there are
rows where the blanks are that have values in other columns


--
Regards,

Peo Sjoblom



"asg2307" wrote in message
...
When requesting a report on my database it saves to excel leaving blanks.
Using sumproduct I can not copy my formula down the column because it
seems
that the blank spaces copy the previous adjacent answer until a non blank
result comes up in the column. How can I fix this. I tried copy/paste
with
skip blank but that did not work.