Help with a formula that would update column information

[kimparker0261]

In my spread sheet
In cell I10, I need a formula that would input the date out of cell ,Input!G10 if the data is greater than zero and if it is less then zero then delete the row all together..
form.

This is the formula that I have currently
=IF(Input!G10>0,Input!I10,"")

However I need this formula to be able to delete the row if the argument is true that the column is greater than 0.

 

[Scott T]

A formula can not change data in other cells. You would either need formulas in the other cells to return blank or VBA to clear the data.

 

[kimparker0261]

Can you help me with the formula on what I am trying to achieve

 

[Scott T]

Something like this should work

=IF(Input!G10>0,what you want in the cell here,"")

 

[kimparker0261]

I would want the argument to read, if Input!G10 is greater than zero then display the information in I10 but if it is not then hide the lines. or delete the lines.

 

[Scott T]

To hide or delete you would need to use VBA.

If you need help with the VBA please post your data and exactly what you want to do.

 

[kimparker0261]

What do you suggest

I am working on a document that I am asking for people to input their data on one sheet and whatever they input on the sheet would output on another sheet if it have a qty of more than 0, also I would like for the sheet to not have blank lines and all the data be there together do you have an idea of how I could get this to work.

 

[Scott T]

I would probable create a loop that would check the data and copy it over when the code is run.

 

[kimparker0261]

Ok Scott can you show me the code on creating the loop

 

[Scott T]

To write the code I would need to know the layout of the data and the sheet names.