Hello all,
I am trying to work out general formatting macros which will allow me to see data the way I need it regardless of the amount of rows containing data but never to more than 400 rows.
For example:
A B
1 aaaaa =IF(A1="",<FORMULA>,"")
2 bbbbb =IF(A2="",<FORMULA>,"")
A... =IF(A...="",<FORMULA>,"")
A400 zzzzz =IF(A400="",<FORMULA>,"")
How do I copy the formula to only those rows that contain data? In this case, to skip row ... while pasting the formula down the B column.
I have run into situations that the copy function fills the 65635 cells down the column, which then does not allow me to use the 'go To -> Special -> blanks; & delete those full rows. I've tried using Paste special as value, and still the same issue; especially if the column that I am trying to refer the formula to has been used on 'paste to column' activities before.
Thanks in advance for your insights.
I am trying to work out general formatting macros which will allow me to see data the way I need it regardless of the amount of rows containing data but never to more than 400 rows.
For example:
A B
1 aaaaa =IF(A1="",<FORMULA>,"")
2 bbbbb =IF(A2="",<FORMULA>,"")
A... =IF(A...="",<FORMULA>,"")
A400 zzzzz =IF(A400="",<FORMULA>,"")
How do I copy the formula to only those rows that contain data? In this case, to skip row ... while pasting the formula down the B column.
I have run into situations that the copy function fills the 65635 cells down the column, which then does not allow me to use the 'go To -> Special -> blanks; & delete those full rows. I've tried using Paste special as value, and still the same issue; especially if the column that I am trying to refer the formula to has been used on 'paste to column' activities before.
Thanks in advance for your insights.