Hi,
I am looking for a macro/vba module to delete a entire blank row if from A7 onwards if it is blank.In my enclosed workbook,A10 is blank,hence I want to delete the entire row,Similarly A12,A14.I have shown only few data here as more than 10k data is there which I cannot delete each row manually,since it is time consuming.
Thanx in advance.
Last edited by paradise2sr; 09-20-2017 at 08:32 AM.
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Another one :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Thanks all of you for your kind help.
Further to add,Suppose there are more data till I column.Now,if H7+I7,if both cells are blank,then it should delete entire row of 7th.Similarly if H8+I8 both cells are blank,then it should delete entire 8th row subject to condition that if D7,D8 column contains the word "cancel" then it should not delete the row inspite of being blank in H & I specific cell position.
I hope this will also be sought out.
Last edited by paradise2sr; 09-20-2017 at 09:47 AM.
ok I think post # 4 seems to be not workable in deriving vba code by all of u.I am revising the posit #4 code.
Further to add,Suppose there are more data till I column.Now,if H7+I7,if both cells are blank,then it should delete entire row of 7th.Similarly if H8+I8 both cells are blank,then it should delete entire 8th row.
I hope this will ease further.
Upload a new workbook that reflects what you need in your new question, it is hard to predict what you want just by guessing from your words.
ok I think post # 4 seems to be not workable in deriving vba code by all of u.I am revising the posit #4 code.
Further to add,Suppose there are more data till I column.Now,if H7+I7,if both cells are blank,then it should delete entire row of 7th.Similarly if H8+I8 both cells are blank,then it should delete entire 8th row.
I hope this will ease further.
Using programming language (like VBA), everything can be programmed, including the scenario in post #4.
What we really need is the !!!REAL!!! sample data with expected output, not just wording.
Do you catch what I mean ? Upload a new sample workbook that reflect the new scenario on post #4 and the expected result.
Plz find the new file in the link >> https://docs.google.com/spreadsheets...it?usp=sharing
Here if J+K column from 7th row onwards in respective cell if it does not contain data then it should delete that respective row taking into condition that B column does not contain "cancel".I have highlighted the row which is deleted in my expected result.My main raw data is "Data" sheet and expected output is "Expected Result".Rest are self explanatory.
Should be :
Please Login or Register to view this content.
Thanx from the heart a lot.It did work.
A slight change further is requested to be made in your code.Those entire data deleted permanently of respective rows can be made/extracted in a separate sheet.As this will help me in segregation of data which in reality is two different types.Sample I have reflected in the link mentioned in the post #9.
Hoping for your kind help in this regard.
Should be :
Please Login or Register to view this content.
Try
Please Login or Register to view this content.
That's an awesome work.
The two results are fine.A last modification in the code would be further be appreciated ,if the existing result is received in two worksheet rather than replacing/modifying my original data which is currently replacing the original sheet which means -
1st sheet - My original data (Currently replacing expected result 1).................I want this to be left intact
2nd sheet- Expected Result 1...................Existing result is required in separate sheet which is replacing/modifiying in the original data itself.
3rd sheet- Expected Result 2....................This is fine extracting from orginal data in a separate sheet
Hope this could be done easily.
Thanx both of you for your kind help in this regard.
Formula changed
Please Login or Register to view this content.
Last edited by jindon; 09-21-2017 at 10:47 PM.
Oh! I used the first code and that worked perfectly.Hopefully,thought the same would be of yours.And requested a slight change in code which I have further posted in Post # 14 which you have already solved in Post #13 except the column width adjustment which is very simple to me.Originally Posted by jindon
Thanx again to you as you were my favourite tutor in solving my complex large data case since inception.
And thanx to "Karedog" &" alansidman" too who consistently helped in resolving the issue.
Hence my issue is solved here.A similar format/Structure which is my next issue will be posting in few hours as I am facing in Normalisation of complex large data soon.And hoping the same help. there too with vba.
Last edited by paradise2sr; 09-21-2017 at 10:57 PM.
Please Login or Register to view this content.
Thanx it did work and hoping the same in forthcoming issue regarding normalisation of data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks