Recent content by juzzvinay

Yes I agree with you - I think there is some other formula which is slowing it down. I just tried it in the test files (without the main files open) and it works superfast. With 6GB of RAM, my pc has no reason to slouch. Will try again to make the new formula work. It works fine for Security...

Lori is on a roll!! Works great - a bit resource intensive, but not too much. Unfortunately, the above is not working error free - or maybe I haven't understood it well enough to implement it correctly. I'm not sure about which portion of the file is requiring time to save but the file...

Wow.. Thanks Lori! Seems to work - will try in it one of the main sheets tomorrow and let you know how it goes. Never in a million years would I have been able to structure this on my own!o_O Awesome:):DD :awesome::awesome::awesome::awesome::awesome:

As required, latest sample file is attached. Calculation is set on Manual because it takes too long to respond. So please press F9 after making any changes.

I came back to this thread to actually post some updates on the XIRR formula last time. Previously I needed to find out the XIRR of a series of portfolio transactions i.e. XIRR of the entire portfolio. Now recently we needed to expand this to find out XIRR of all stocks/ asset classes...

Thank you very much Kind Sir!! This is just :awesome:! I was so sure that the solution was within reach and all it took was just a few additional words. Of course knowing which words and where to use them is what makes all the difference. I am sure it will work although I should probably check...

Sample File http://speedy.sh/9tST7/Named-Ranges-Sample-Extract.xlsm VBA Code - As suggested by @jeffreyweir (Modified from code in http://chandoo.org/forum/threads/creating-a-priority-table-from-multiple-tables-solved.10785) Private Sub Worksheet_Activate() Dim lo As ListObject Dim...

Thanks SirJB7 for the quick revert. I thought it would be a simple entry to input external tables/worksheets/ workbooks. If you can think of some way to modify the code to allow one time setup of external file links it would be great but don't waste too much time over it. At the risk of...

Hi, Apologies for the delay in replying - financial year end pressures!! SirJB7 - could you explain the 'simple' code? How can I select what portion of which table from which worksheet from which external workbook should be merged? For ex, I have 4 different (but similar layout and format)...

@SirJB7 Thank you very much!! I really thought you had forgotten about it ;) - let me try to understand it during the day and see if I am getting stuck again. I am sure many people, along with me, will find this useful. :)

@Cruiser Thanks - would appreciate the help on the question. I solved it somehow, but I don't think I will be able to do it again. So it would be good to know an alternative.

Sir JB7 Hope you have had the time to go through the post. Do let me know if you can help me out. Looking forward to hearing from you. Regards

Sorry SirJB7 - I tried to minimize and prioritize the questions but I guess once my curiosity itches, it needs to be scratched.:) Juanito - Thanks for the suggestion. I have come across the RDB add in earlier and its from there I got the idea of a userform asking which worksheets/ tables should...

Thanks SirJB7.. Your solution works but it is not suitable in my case as I frequently update the associated worksheets - around 200 a month. Also, since I have more than 8000 rows across worksheets and 40 odd columns the file size is unwieldy as well. Jeff's solution works just fine - I am only...

Thanks so much SirJB7! I will definitely try out you suggestion and let you know how it works. From what I understand this is not automated and I will have to manually add rows in the summary sheet each time new rows are added in the 3 dynamic tables. I have already implemented a VBA solution...