Search results

Hi Alan, while creating a 2nd query, I realized that 16 headings that I wanted to use are in Column numbers 94 to 109. There were few other random headings that also I had to use. So, I selected column 94 to 109 and then used Ctrl key to select few others and I used 'Grouping' and that appears...

Hi Alan, yes, I can see that this will work. I knew that we can select and Move to the beginning but the thought never came to mind how this could be exploited to get the desired result. Thanks Regards

Hi I have a dataset of 170 Columns and about 7000 Rows. In the Transform, I need to drag many columns appearing at different locations in the dataset, to the front. I can Select any column and drag it to the front. However, it become very time-consuming when dragging individual column each time...

Hi I have attached 2 files. The sample data is same in both files, however some columns are hidden in data test 2 file. Requirement is to Create hyper-links. e.g. in the ID Slicer of data test 2 file, I click on 56. This will result in row 73 only visible which pertains to ID 56. Then I click...

Yes, it works. Thanks very much Cheers

Great, many thanks. will test tonight and come back to you. Cheers

Hi I have a workbook with lot of slicers. If I saved this as a Web page, the slicer functionality ceases when the file opens in the Web Browser. Quick question: Is this doable (i.e. save spreadsheets with slicers in web format which then allows user to use slicers in the web browser in the same...

Yeah I know sometimes hands are tied and we don't have much wiggle room. Thanks for your help though. I'm sure there will be answers coming.

Why need many weekly sheets? Well I don't Have any way out as that's what I have to work from. This won't change I mean the current structure of the document. Unfortunately though. So trying to find a way out in the given circumstances. The data table solution won't work. The actual document has...

Thanks. This is the conceptual dummy sample sheet of actual what I work upon. The only difference is that in the actual each day has about 40 rows and 5 columns of data. Activity remains the same but other info like volunteers names differ subject to their availability. and then there is a...

Hi In the dummy sample file attached, there are 2 worksheets named week wise i.e. Week of 29 July, Week of 5 August. In the actual document, there will be about 10 tabs belonging to each week. Each individual week will have data date-wise i.e. Mon 29 July, Tue 30 July, till Fri 2 Aug...

thanksssssssssssssssss yes works perfectly fine gaining learning though, and yes, already started studying VBA from the link that you had suggested. much appreciated

Hi Marc I have removed IsNumeric as advised but its throwing up an error: copy pasted here the code after removing IsNumeric: Any advice, please let me know. regards t

@Marc L @GraH - Guido @p45cal @vletm @AliGW My thanks to you all for your wonderful contribution and help. I appreciate your time and effort put in to find the perfect solution. I consider this thread as close, now. Regards t

Dear Marc, Thanks a lot for the solution, but most importantly, for the clear direction. On my new journey now. Regards b

Dear Marc I have one question, and I also seek advice. First things first, an update: I have tested in real environment using the real project and it works just as intended. Serves purpose 100%. Tons of thanks. Q: Can the codes be Alpha and or Alpha-numeric? Currently, they are only numeric...

Dear Marc. I have created a fresh workbook, a replica of my finished product and have used this latest coding. Yes, it works as intended. I placed codes in a separate sheet and created 3 further worksheets with tschedules. I have tried all 3 individually and yes, this works perfectly fine...

Thanks Marc, will test tonight and let you know. regards b

@Mark L @GraH - Guido @p45cal Brilliant, I will recreate fresh work-book replica of my exact requirement, save it in required format and attach. @p45cal correct "At its simplest you may want the code to run on ALL the sheets except your tCodes-containing sheet; let's say you called that sheet...

@p45cal Hi Dropdown solution provided by you is also very helpful, however, looking at the scope of my current project the solutions provided by @GraH - Guido and @Marc L are the most suitable one. Having said that, I will use your solution in a different project. It will be put to good use...

@GraH - Guido @Marc L Thanks very much for your help. Both solutions works perfectly fine. and yes, this is THE perfect solution. In the final product, I will have tCodes in one data sheet. the final product will have about 20 worksheets. The code just now needs refinement so that it applies...

Hi Marc I have tried this, and yes, this works too. I have just one last question. How we can make this work on any additional worksheets to be added to same workbook. Yes we can make duplicate of this and add and rename and change the name in the vBA. Can there not be a solution (code) taht...

Dear P45 Finally got time now to look at it. Yes, this sounds good. I will still explore as to which of the solution could be the best one for the project currently in hand. Suffice to say that I have got more than what I was expecting and each of the solution suggested in this forum will be...

Hi P45 Unfortunately, I am not able to open this and clear security (Blocked content) due to blockage my official policies. i did not know that before. i will have a look tonight on my laptop at home, and will come back to. Kind regards t

Dear all, Its 00:45 hrs in this part of the world (NZ). I better go to sleep now. Will return to find magic answers in the morning. Thanks again.