Insert a blank row in incomplete sequence
Hello folks,
I have a sequence of data (1-31) in column "E", and sometimes a number is missing in between and I need to insert a blank row where the missing number would go.
I've searched and found this code from excel forum for a similar problem, but it needs a small change since the code is for a sequence of "0-9". Could you please help me?
2016-09-28_17-52-42.png
Thank you for the time.
Please Login or Register to view this content.
Last edited by Moriexcel; 09-29-2016 at 05:31 AM.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
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
Maybe:
Please Login or Register to view this content.
Thanks. But a small issue is still remaining.
For example: It gives me this 2016-09-28_21-23-15.png, but I would like to have
30
31
blank or 1
blank or 2
3
4
I'm sorry, but I can't see your .png view. Can you post another sample showing what you are getting and what result you want?
OK no problem.
The code gives me this for example:
30
31
blank (created by code)
3
4
while I need to have:
30
31
blank (for 1)
blank (for 2)
3
4
Hope it helps. If not please let me know to attach the output file to the original post. Thanks again.
///////////////////
Last edited by Moriexcel; 10-01-2016 at 03:23 AM.
Does anybody has a solution for my problem?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks