Search results

Hi I've recorded myself copying a legend from my correct workbook (Mike1) into another one (OtherWorkbook) that I have opened. I'll be doing this process quite a few times so wanted to make a short macro to help me do this. Unfortunately, the 'OtherWorkbook' name is very specific, and I can't...

Hi My question is: Any ideas what I would need to change to make the conditional format data bar size represent the cell number compared to 100%? Rather than compared to the highest number in the range of numbers? I was trying to make a table full of numbers look more...useful. So I thought I...

Hi I'm updating multiple sheets that contain the same structure - 4 tables, one below the other, numbered rows from 50-250 and 7 columns. Above each table is a slightly different title, but each table has the same column headings. (see attached file) I had recorded myself using the find and...

Hi I'm working through multiple, and slightly different sheets, and trying to select a range based on a condition in a column that will not be part of the final range. I would then format the numbers within my final range. Column A = contains number "14". (Row n) Final range = $C$5:$F(n)...

Hi I've a list of country names with * at the end of some them. This list is generated each year, and some country's lose the * depending on the year. I'm going to extract data from each year using INDEX/MATCH so I need to remove the * at the end of each country. I've found and tried this...

Hi I'm trying to figure out how to make an X-Y Scatter include a line between data points even if they are far apart - 5, 6, 7, 17 , 29, 32... I have a dataset that has products sold over years. Unfortunately, there are missing data points for some products over a number of years, i.e. 1965...

Hi I was reading, and now implementing, the article about improving in-cell charts with negative values. I've run in to a problem. When I apply the formula used in the downloadable sheet, it does not show up my small % values. I've therefore tested with some other % values and only begin to...

Hi Apologies for the cryptic title. I'll try and explain. I have a lot of line graphs that I need to compare against each another. I have a common scale used on all (see my MAX/MIN question) and it's really helpful. However, the graphs have a lot of their data stretching along the...

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

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

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

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

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

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