• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by TonyNZ

  1. T

    Power Query - Drag and Drop

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

    Power Query - Drag and Drop

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

    Power Query - Drag and Drop

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

    Hyperlinks

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

    Slicers and Web page

    Yes, it works. Thanks very much Cheers
  6. T

    Slicers and Web page

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

    Slicers and Web page

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

    Email from Excel

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

    Email from Excel

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

    Email from Excel

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

    Email from Excel

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

    Data / Conditional Formatting

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

    Data / Conditional Formatting

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

    Data / Conditional Formatting

    @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
  15. T

    Data / Conditional Formatting

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