Automatic deletion of blank rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2042833%22%20slang%3D%22en-US%22%3EAutomatic%20deletion%20of%20blank%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2042833%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20searching%20through%20this%20for%20a%20long%20time%2C%20no%20success.%3C%2FP%3E%3CP%3EHere%20is%20the%20thing%3A%3C%2FP%3E%3CP%3EThere%20is%20an%20excel%20file%20linked%20to%20google%20form-%20requests%20from%20google%20forms%20are%20going%20to%20excel%20automatically.%3C%2FP%3E%3CP%3EWhen%20new%20requests%20pop%20up%2C%20very%20often%20blank%20rows%20are%20created.%3C%2FP%3E%3CP%3EI%20can%20delete%20them%20manually%20but%20it%20takes%20time.%3C%2FP%3E%3CP%3E(here%20is%20one%20of%20the%20examples)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22TomekBanach_0-1610095481170.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244864iEAB361A24B9D247D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22TomekBanach_0-1610095481170.png%22%20alt%3D%22TomekBanach_0-1610095481170.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWhat%20might%20be%20the%20thing%3F%3CBR%20%2F%3E-%20this%20is%20an%20open%20workbook%2C%20maybe%20if%20someone%20was%20clicking%20on%20particular%20row%2C%20that%20request%20can't%20pop%20up%20on%20this%20row%3F%3C%2FP%3E%3CP%3E-%20I%20was%20thinking%20about%20creating%20a%20macro%20to%20fix%20this%2C%20but%20still%20you%20have%20to%20run%20it%3C%2FP%3E%3CP%3E-%20there%20is%20an%20calculation%20in%20one%20of%20the%20rows%20%3DMAX(0%3B%5B%40%5B%3Ddate%5D%5D-%5B%40%5BSpecial%20time%5D%5D)-%20to%20count%20time%20difference%20between%202%20columns-%20it%20might%20be%20the%20issue%3F%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20U%20give%20me%20some%20ideas%3F%3CBR%20%2F%3EI%20have%20been%20looking%20at%20this%20topic%2C%20but%20with%20no%20success.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fdeleting-blank-rows-in-excel-but-not-deleting-partially-blank%2Fm-p%2F206107%23M6824%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fdeleting-blank-rows-in-excel-but-not-deleting-partially-blank%2Fm-p%2F206107%23M6824%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2042833%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello,

 

I have been searching through this for a long time, no success.

Here is the thing:

There is an excel file linked to google form- requests from google forms are going to excel automatically.

When new requests pop up, very often blank rows are created.

I can delete them manually but it takes time.

(here is one of the examples)

TomekBanach_0-1610095481170.png

What might be the thing?
- this is an open workbook, maybe if someone was clicking on particular row, that request can't pop up on this row?

- I was thinking about creating a macro to fix this, but still you have to run it

- there is an calculation in one of the rows =MAX(0;[@[=date]]-[@[Special time]])- to count time difference between 2 columns- it might be the issue?

Can U give me some ideas?
I have been looking at this topic, but with no success.

https://techcommunity.microsoft.com/t5/excel/deleting-blank-rows-in-excel-but-not-deleting-partially...

0 Replies