Help with a formula that would update column information

kimparker0261

New Member
Joined
Jan 8, 2019
Messages
30
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.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,610
Office Version
365, 2016
Platform
Windows
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.
 

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,610
Office Version
365, 2016
Platform
Windows
Something like this should work
Code:
=IF(Input!G10>0,what you want in the cell here,"")
 

kimparker0261

New Member
Joined
Jan 8, 2019
Messages
30
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

Well-known Member
Joined
Dec 14, 2016
Messages
2,610
Office Version
365, 2016
Platform
Windows
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.
 
Last edited:

kimparker0261

New Member
Joined
Jan 8, 2019
Messages
30
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

Well-known Member
Joined
Dec 14, 2016
Messages
2,610
Office Version
365, 2016
Platform
Windows
I would probable create a loop that would check the data and copy it over when the code is run.
 

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,610
Office Version
365, 2016
Platform
Windows
To write the code I would need to know the layout of the data and the sheet names.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,497
Messages
5,414,892
Members
403,552
Latest member
Daniel Kuenstler

This Week's Hot Topics

Top