Hang on... you're overcomplicating htis (and so am I). Why can't you delete everthing in BVA each update and just paste the new stuff in. Providing the headings don't change, your Table will update. In reality, you don't need iNDEX-MATCH, as you're just using it to rearrange data. See a simpler alternative in Sheet1 - that you can pretty up. Alternatively, use your existing format in your own report format. It's not doing any harm!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Yes, perhaps you are correct that this has been over-complicated!
Headings all stay the same - a row may be added or deleted but that should be easy to spot when the template pulls data (I have 'check totals' in place as well if something is not in balance in the template).
I will continue using my cleaned-up template as I have some conditional formatting things embedded in there but if I keep the worksheet BvA and just do a straight copy-paste of the new data each month into BvA (and effectively using this as another template to house the downloaded data) then theoretically I could also leave the INDEX-MATCH formula to pull in the updated data in BvA to my cleaned-up template.
Oof - that was a lot of words to say I think we found our simplified solution!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks