In this video, I show how to insert multiple blank rows between every row of data. A trick I learnt from Bob Umlas Workbook can be found here drive.google.c... #InsertRows
What would be also interesting is how how to sort a column and insert 2 blank lines when the first 3 characters of a cell changes AND insert a subtotal in column "e". Column 1 has many rows where the first 3 characters do vary. A macro for this would be great. I can't find a way to do this.
Hi. What a lot I learned from you in a short time. Wow! Thank you! Could you please tell me, for example, how to insert 3 rows, taking as reference the data from the first column which are products items/codes, therefore multiply the data in those rows and in the second column will be the origin country of that product. And at the end a product has 4 rows with different countries of origin.
Thank you so much for the feedback. I made one on Inserting blanks between columns ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iT_eNsq8x-8.htmlsi=qviBlEy4EUrA5ge6
The idea would be to create a series of 30 1s 30 2s 30 3s...1,1,1....2,2,2.......then at the end some blank rows wirh the sequence 1,2,3 to 34(approx 1000/30)...If you sort the entire data by this column, you will have what you want
For a dynamic result,you can check out my video here , easy if you use Office 365 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MoLSCQMIu6A.htmlsi=tm0Chr_BZOx_NSHX
I just made a video on using it on columns here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iT_eNsq8x-8.htmlsi=qviBlEy4EUrA5ge6. I hope you like it
I just did it with a 1000 rows and 2 blank rows and it works flawlessly, as expected. Maybe try reviewing your steps, you should be able to get it to work. if not, kindly provide feedback and we will find a way to take a look at it
Such a very brilliant, useful, and fantastic time (and energy) saver! Thank you, my Friend! I'll never get those wasted hours back again, but that is over with now! You're the best! Thank you! Thank you! And, of course, THANK YOU!!! ~I wish all Good Beings here a Happy and Healthy 2023 ...and Beyond. Oh, yeah ...THANK YOU!!! ~Most Gratefully, Wombat Willie ʕ•́ᴥ•̀ʔっ
Hi brother, in my case, there are 10,000 serial numbers & around 1110 blanks rows have to be inserted between each of those 10,000 serial numbers. Is this possible ?
If i do the maths with the numbers given, you would exceed the 1,048,576 rows that an Excel sheet has. Even though I am trying to understand why 1000+ blank rows are being inserted between the rows 😁😁
@@techempire1647 Not anything different at all. The only time the technique would be a challenge is when you are hitting the limits of Excel's row handling
Thank you for your feedback. What's your specific request as it appears the video does not address? it. In any event, youtube allows you to slow the video down to a speed you consider appropriate