Now even if someone gives all these details, we will still be in doubt about What if Interviewer asks something else? What if I am not able to perform well?
Today I am trying to explain a Puneet arora simple way to add a blank row after each record in your data. This trick is very special because without VBA it is the only method to insert a blank row to your data except doing it manually.
See the image below: Now the challenge is to do it without using VBA codes. So here you go with the solution.
Enter a series of numbers in the column next to your data. You can also use "Fill Handle" to put the series of numbers if your data is large, this is an efficient way of putting numbers.
Once you have numbers next to your data select the series and copy it. Go to the last number in the series and below it paste the full series again.
Now select your complete data along with the series entered. Now if you see your original data has got a blank row after each record. This is what we were trying to achieve with this trick. I know this can be done with a very simple VBA code, for my super efficient VBA loving friends I am posting the code in comments below.
I hope we you all have gained something out of this post. Your suggestions and feedback are most welcome.View Puneet Arora’s profile on LinkedIn, the world's largest professional community.
Puneet has 5 jobs listed on their profile. See the complete profile on LinkedIn and discover Puneet’s connections and jobs at similar companies. You can use these best ping sites to index any URL very fast.
Get the list of most used pinging tools on the initiativeblog.com ping services are totally free! CA Vinod Gupta Direct Tax Modules for CA Final Assessment year Finance Act set of 5 modules summary module not included (Module 1,2,3,4 released).
Follow All The Free Movies. Home; English; Hindi; Korean; Nepali; Contact. View Puneet Arora’s profile on LinkedIn, the world's largest professional community.
Puneet has 3 jobs listed on their profile. See the complete profile on LinkedIn and discover Puneet’s connections and jobs at similar companies. Satya 2 is a Indian crime film, simultaneously shot in Hindi and Telugu language.
The film was directed by Ram Gopal Varma with production design by Saini S. Johray. The film stars Puneet Singh Ratn (Hindi), Sharwanand (Telugu), Anaika Soti, Aradhna Gupta and Mahesh Thakur in lead roles. The film tells the story of Satya, an immigrant who comes to Mumbai aiming to refashion the mumbai.