skipping blank cells while I am Coping a formula down using the fill handle in Excel

[Corried]

Hello Excel

Would love your support

How To skip blank cells while Coping a formula down by dragging the fill handle.

https://imgur.com/R1fDNf6

I have a formula which to copied data on a next worksheet. The problem is. I want to copy the formula down, while skipping the blank of black cells which is indicated on the picture above



Thanks in advance

 

[bobsan42]

there are two ways to do it - one is not applicable in your case: it would require to have always the same number of balnk and non blank cells.
The other way to do it is to make the area a filtered list and Fliter out the blank cells. Then Filling down will not affect the hidden blank cells.

however I would normally have the formula everywhere and figure out a way (depending on the values in the blank cells or another condition) to make the cells only to appear to be empty.

 

[Corried]

The other way to do it is to make the area a filtered list and Fliter out the blank cells

Thanks for your reply. The problem I am having is this. The formula is paste without pasting on the blank cells but with the wrong reference number. How can I get around this?

Thanks in advance

 

[bobsan42]

what is the formula?
I cannot completely understand what you are saying.

 

[Corried]

Thanks for your reply. The problem I am having is this.

1. The cells are update but carries the wrong reference number. in other words, if the reference number in cell #1 is "A5" than follow by a blank cell in cell #2 after, follow by a cell with value on cell #3. the next reference valve should by "A6".

See example:

Correct Pasting #1 Example

=SUMPRODUCT('[Countries Indicators #1 NSB (1).xlsm]PMI'!A5)	Correct value on Left
	Blank Cell on Left
=SUMPRODUCT('[Countries Indicators #1 NSB (1).xlsm]PMI'!A6)	Correct Value on left

Wrong Pasting #2 Example

=SUMPRODUCT('[Countries Indicators #1 NSB (1).xlsm]PMI'!A5)	Correct value on Left
	Blank Cell on Left
=SUMPRODUCT('[Countries Indicators #1 NSB (1).xlsm]PMI'!A7)	Wrong Value on Left

The problem I am getting is #2 example. How can I fit this?



Thanks in advance