Microsoft Excel help!

[Plane Sailing]

Moved to computer forum

 

[Mycanid]

Wondering when this would happen.

 

[Ayrk]

For the you sheet where you don't want to copy over the zeroes, what you can do is insert a column and number each row you are copying 1 through whatever. Then sort the whole thing by the column with the 0's in it and that will place all the rows with the 0s at the top or bottom.

Then copy everything except the zeroes to the new sheet. Then sort the copied stuff by that column you numbered 1 through whatever and that will return it to its original order without any of the zeroes.

 

[Infiniti2000]

For not copying zeroes, the easiest thing is to have in between sheet with a simple formula, something like "=IF(Sheet1!A1=0,Sheet2!A1,Sheet1!A1)" where Sheet1 contains the values to copy and Sheet2 contains the values to copy to. Once you copy this formula to Sheet3 (in every similarly placed cell of the others), just copy it and paste special (Values) over the values in Sheet2.

Even easier would be if you had blanks instead of zeroes. Then you could just paste special (skip blanks).

You could write a VB script that would be the easiest of all--once you write the script.

 

[Redrobes]

Im absolutely not an excel wizard so forgive me if im miles out but could you not add a value to all the row numbers from a single box. If this box value is 0 then all the rows with 0 in them would then be 0+0. If the single value box had a 1 then all the row values would be 0+1 etc. Now if you wanted to show all the rows then set the single box value to 1 and they all appear and when its zero they all hide using your conditional formatting. Is this possible ?