Does anybody know how to automatically insert 5 blank rows between each row of data? I have 68 data files and each containing at least 320 rows, so it's not really an option to manually insert them.
I have to copy/paste some data in between, but it has to be aligned so I can sort/filter later on.
Select the 68 files when prompted:
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
What do I do with this script? Copy paste into command prompt? I'm sorry, total noob here.
Visit this page, and look for the section titled "Using someone else's macro"
http://dmcritchie.mvps.org/excel/getstarted.htm
You, sir (ma'am?) are awesome. Thank you so much! It totally worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks