Search results

Thanks Hui. Your comments about deleting a Min/Max legend name has helped me out of a spot. I've managed to make it work by using paste special > new series>going through and doing all the hiding, etc. One issue I've encountered is that the Horizontal scale changes from my required...

Hi I need to compare 8 charts, and their Max and min scales are all over the place. Therefore I've done some research and found that a common method is to create a new series that takes the MIN and the MAx of my data, and then copy and paste this series in to the charts. Change the data lines...

Didn't try that one. I'll give it a go.

Hi (again) I'm going through old spreadsheets and finding Idiosyncrasies with text formatting. I'm trying to turn everything into proper sentence case, e.g. The cat sat on the mat. And not THE CAT SAT ON THE MAT, or The Cat Sat On The Mat. I've tried combining LOWER and MID functions but I'm...

Hi I'm using Index and match to retireve data from another workbook. It works great except for one cell where the formatting may be slightly different (but not to the naked eye). I've read that match can include wildcard cahracters - ? or * in the lookUp part. My question is how are these...

Good question. I'll give your code a try and see where it takes me. Many thanks for your quick response. Mike P.S. Great website by the way.

Hi I've inherited a workbook that has lots and lots of yearly datasheets (and we keep adding to them). I'm in the process of amending a macro to recalculate the data in each sheet, but I wondered if there is a more suitable way to write an array for assigning the worksheets to a year, rather...

@Hui: it was an urgent question so I used all my available resources to see if I could get it answered as quickly as possible. As for the reply and how it's posted, well I thought other non-Excel ninjas might find the code (and it's structure) useful. No offence was meant.

@Oldchippy: thanks for the link. I can imagine I'll be using that page quite often. @Hui: that was something i tried but didn't manage to make work. Recently though I have learnt that you can use the same category in the values field more than once. Maybe that will be how I can make it work...

Hi I've also posted this question on another forum I often use (www.superuser.com) and a user called "dkusleika" posted a wonderful reply that worked a charm. I tinkered a little to catch some other formats that I needed deleting and it worked perfectly. Important note: He mentioned that...

Hi I've recently been handed an Excel file to format - 100's of lines. This could be a really long exercise if I work through it manually, so I wondered if a macro could help. My job is too: 1. Delete the rows where Dot&Dot&Dash are used at the beginning and together. Then; 2.Go through...

I've done some searching around and get the imporession this was something quite a few Pivot table users have asked about. A possible way to do it is by adding helper columns and making the calculation there. I'm still working on it, but if anyone has ideas let me know. Thanks Michael.

Hi all I'm struggling to make a PT show me the data how I need to present it. My 15 colleagues are chosing from 30 questions. I then use a PT to help me see what questions have been chosen by which. However, I also need to see how 'popular' each question has been...

Thanks Hui I've never used INDIRECT before, so I'll give it a go. Just to confirm, and I'm slightly confused: [list type=decimal] I create a table in each Master workbook where, [list type=decimal] $A$1 has Specific workbook name $B$1 has specific sheet name[/list type=decimal] Make the...

Hi I have many workbooks each with 5 specific worksheets (lots of people have their own workbook). I'm trying to collate the individual worksheets into 5 separate Master Workbooks (that I can work from). I'm having problems. Within my colleagues workbooks I've assigned specific Named Ranges...

Hi everyone I look forward to picking your brains and hopefully helping people out where I can. Many thanks Mike.