Hello!
I have 6 columns in a sheet, and over 700 rows. I am wanting to separate the rows with a blanks row, by either column A or column B. I have two sheets with the same info, just separated by the different columns. Is there a function or a way to do this, besides going through each one individually and separating it myself?? PLEASE HELP!!!
Welcome to the Forum.
Its very much possible. Please attach a sample file containing dummy data so we can help you more easily.
Also, on what basis should the blank rows be inserted?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Here is the start of what I am working on.... There are two sheets, Jan 2012 and Jan Ven 2012.
In the Jan 2012 sheet I am needing to separate the information by Column A(date). So at the end of each date I need to add a blank line, so I can add a total at the end of that day. I add rows everyday with new info. There is an example of what I am needing it to look like.
Same goes with Jan Ven 2012.... only I am needing to separate the info by column B(Vendor). Again I add to these daily and have to re-separate them each time.
Thank you in advance for any help!!
Subtotal should do it.
See this Link
At the subtotal window first drop down 'At each changes in:' select VENDOR
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
I am still having issues with this working for excel 2010.
Sort your data by VENDOR then do the SUBTOTAL. See the attached.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks