I import our entire trial balance into Excel but for the purposes on this particular spreadsheet, I am only interested in the accounts prior to and including the "total income" account. Therefore, I would like to create an array from a loop that stops after reaching "total income". I would then like to make a drop-down of that list (which may vary in length based on the client and their particular trial balance) but not include any extra blanks. Does anyone know how to do this?
Thank you!!!
Last edited by letsExcelebrate; 03-13-2017 at 01:47 PM.
Please post a sample workbook with some typical data and expected results.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi letsExcelebrate
Welcome to the Forum!!!
This Code does not create an array...uses AutoFilter to accomplish what you've requested...CTRL + k will fire the Code.
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
that is fantastic! Thank you so much!!!
Hi letsExcelebrate
You're welcome...glad I could help. Thanks for the Rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks