Search results

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...

Anyone around? Any help likely?

Sample File: http://speedy.sh/EB7B9/Named-Ranges-Sample-Extract.xlsm Recap of Queries -The current VB code is for worksheets/ tables within the workbook - how do I link external workbook/worksheets/ tables in a similar code? Can I link an external closed excel file Table using VBA? -How to...

Bump.. Anyone there? Can someone please help me - I am stuck midway since 4 months.. Hoping for some help in the new year at least!

Bump.. No responses?! Hope to hear back soon - really need your help as I am stuck midway through implementation.

Jeffrey, In continuance to my above queries, -How to select only part of a table for consolidation using VBA? -How to insert "Auto Refresh Pivot Tables" command in VBA? -How to link an external Worksheet (i.e. in another workbook, maybe closed) using VBA I also have a cell (formatted as Number...

Many thanks Narayan for the links. Jeffrey, the sample file is uploaded at http://speedy.sh/wSJrm/Named-Ranges-Sample-Extract.xlsm Couple of additional queries - The current VB code is for worksheets/ tables within the workbook - how do I link external workbook/worksheets/ tables in a...

Ok. I didnt think a sample file would be needed as most of the queries are conceptual in nature. Will upload a sample before and after file shortly.

Happy to inform that I found a solution for my query as above. This is for anyone else reading the thread and facing similar issue. Hope it is ok to link to external forum (below). If not, mod please edit and I will ensure it does not recur. For calculating XIRR for data set A2:H22 Formula...

Sorry forgot about 9)Do I always need to save the file as XLSM file or can I save it as XLSX and still use the VBA/ Macro? VBA is completely new for me so pardon me if my questions are too simple.

Hi Jeffrey, Been a bit busy since a couple of weeks so couldn't get around to setting up the excel with VBA. Finally got it done today and it works beautifully. I had a few minor queries though and would appreciate if you could take me through them. 1)I have set up Summary table and have to...