Is it possible to have a macro or program do the following:
Scan the lines on a given column when a difference is found in the from one line to the next to insert a blank line (preferably 2), total the number of lines that were just "scanned", move on the next line and repeat the procedure? I have about 600 lines to do.
Dave
Hello and welcome to the forum,
The scenario you propose sounds very possible using vba. If this acceptable for you, then please post a before and after example.
Good luck.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Sorry, messed up my post.
Sorry again, I finally figured out how to upload a sample.
Last edited by David2011; 12-02-2011 at 01:02 AM.
Why not use the standard excel funtion under Data named Subtotal. For every break in specified data, you can do a function like sum or count on another column.
It can do exactly what you are looking for. It wil also group the data so that you could minimize the detail and only get the totals.
Last edited by Leamc; 12-02-2011 at 02:18 AM.
Good news, bad new. The good news is your idea produced exactly what I asked for. The bad news is when I turned in the finished product I got the old "that's good but what I really need is..."
Thanks for you help. Guess I'll have to put up a new post with a question about my new request.
So what's missing from the 'perfect solution'? I guess you are doing this for someone else since you are using the third-person?
abousetta
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks