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.

 

[kimparker0261]

How can I share the sheet with you

 

[Scott T]

You can post a sample

1. Posting Aids
2. You cannot attach or upload actual files as samples.
3. However, you can post small Excel screen shots using MrExcel HTML Maker (updated 2017) (Win), Forum Tools Add-In (updated 2017) by RoryA (Win & Mac), Excel jeanie by Peter Haserodt (Win) or Borders-Copy-Paste (Either). There is a little more help about some of these methods in this Attachments Sticky. Test the methods in the Test Here forum before use in a main forum for the first time.
4. If posting vba code, please use Code Tags - like this

   Paste code here

   - or use the VBHTML Maker
5. There is a Test Here forum on this board where you can test these posting aids before using them in your actual questions.

1. N.B. With any of the Add-Ins with recent versions of Windows, you may need to "unblock" the file. In Windows Explorer, find the file, right-click, Properties, General tab, tick the 'Unblock' box down near the bottom ..​

Or you can manually make a table on the forum with your sample data.

 

[kimparker0261]

Ok this is the shared link for the excel sheet.


this is what I am trying to archive
for example in h9 on the output tab, I would like to post the data from the H9 on the input tab if the qty in G9 is greater than 0


https://1drv.ms/x/s!AoRYGdvX8gxwgVkw2ydT776EVxJB

 

[Col Delane]

From the look of your two sheets (Input and Output), they're almost identical, so why bother having both?
Why not just use some VBA to delete (perhaps after alerting the user who inputs the value) any row that has a qty in column G that is less than zero (i.e. anything EXCEPT a blank or a number > 0)?

If the above is not acceptable, how are you getting the data entered on Input replicated on Output for rows where G?? > 0 (this could be fully automated)?

 

[Scott T]

If I understand what you want then something like this may work. The results on the other sheet would update as users change the input sheet.
https://youtu.be/fDB1Ktyhp3Y