Search results

Good Morning All, I was wondering if there is anyone who might be able to aid in helping me to speed up the running of my code in the attached file The Code initilizes a number of Arrays and the mashes them together to give me one give report that i then use to generate a set of pivot tables...

Good Evening all, I am looking for some help to speed things up i have 12 Subs following the code below, which assigns the given workbook/sheet/range to an 2D Array but this takes some time. Thesize of the ranges are variable based on the range in the given workbooks and they dont all start on...

Tank you both still not giving me the desired results

I have uploaded a File with the list

Good Morning all, I am struggling with a small task I am looking to calculate an incrementing Unique Value as shown in the table below for each “CR No” Design Zone and Nominated EDP

Thank you all for your help I am still not able to open the file however I think this is because of a custom number format [$-409]mmm-yy;@ that I have used and now cannot remove it as the workbook wont open

Hui, Thank you for your reply, I am trying to identify what formula I have used across 88 cols of a table so that that I can rebuild the sheet. I have looked at my email sent items and the sheet is too out of date by about a year to even start reworking it.

Good Morning all, I am having difficulties opening an Excel Workbook which has been a year in development (I know I should have made a backup), I have tried to open and repair the file however, when I do that it I loose all the formula etc. My workbook took references from multiple workbooks to...

Hello all, I am using the code below to open all the linked sources for my excel spreadsheet however on the line For I = 1 to UBound(v) I get a run-time error 13 type miss match Sub UpdateLinks() Dim v As Variant, i As Long v = ThisWorkbook.LinkSources(XlLink.xlExcelLinks) For i = 1...

Thank you all for uor help it is much appreciated I hadn't thought of a Pivot Table however both of these solutions worked Many thanks

Narayan & Bosco, Thank you very much both of those forumla do the job my only problem is i have over 20000 rows and they both take a long time to work, would there be a quicker way? Many thanks for your help Regards Stephen

Afternoon all, Im not sure of the best way to work this out. I download a sheet from a database with the CR number as the identifier the CR number (Column A) can have upto 12 * 8 rows each row has a focus date (Column L) im looking for away to identify the max date of Column L based on the...

Thanks for all your help guys after all the time and effort my works IT department has decided to develop a download from the system which better suits my needs. I would just like to say that I have enjoyed the learning experience that I have gone through over the last few weeks. Many thanks

I will try and provide the other sheets when at work tomorrow or at least a cut down version. My main when I look at the task manager and running processes I'm see circa 403000 kb memory used when it freezes

Thanks for having a look yeah running independently but trying to get it to run from the main file so that only 1 command button basically the main file has =dashboard.csva2 and so on

This is my full code, I have attached the file that concerns Sub DashboardCSV as the rest contain restricted data, Function WEEKNR(Datum As Date) As Integer Dim lnDatum As Long lnDatum = DateSerial(Year(Datum - Weekday(Datum - 1) + 4), 1, 3) WEEKNR = Int((Datum - lnDatum +...

Im having difficulty uploading a file

Thank you will give it a try

Good Morning All, I have tried all the variations of the code and the code works when I use a small set of data my problem is that when I use the full data set I get a not responding. I ask in hope that someone is willing to help.

I have tried to up load all the files but it says it is too big I will try another way thank you all once again

I would like to thank you all sorry for the late reply I have been in hospital without access to the internet. I have not had a chance to check all the replys but thank you very much.

Good Morning form the UK. I have a spreadsheet that is a download of a Database and I require to manipulate this to feed into a dashboard data table. I use the code below to do the manipulation but it takes forever and I do not know if or how to make it faster. can anyone help? Sub...

Ladies & Gentlemen, it is a pleasure to meet you all. I am looking for a wee bit of help on the chandoo.org CONCAT() Function I download a report form a database which gives me the attached excel spreadsheet. I found the and have decided that it is the best thing since sliced bread it has...

My name is Stephen Spittal and have recently devloped a dashboard for Change Managment I have gained a lot of help through viewing the Chandoo.org tutorials and blog articles. In the eyes of an Excel guru I am a novice but with in the eyes of the compnany i work for I am the guru if that makes...