Recent content by binaryfingers

Thanks Yogia!

Yogia Excellent, twice in two days you have helped me save a lot of time! Thanks again,

Hi I have a range of weekly dates running horizontal from Column F to Column BE. on row 2 I have been trying to find a solution to sum row 7 from Column F to the column that matches the current weekly date. I believe it is a combination of Sum(indirect(match))) but not sure if there is an...

Yogia If you find time, would you mind breaking the following line down for me so that I can understand a little better the technique you are using, ActiveWorkbook.Names.Add Name:="Data" & yStr, RefersTo:=Range(Cells(4 + (i - 1) * 5, 1)(2, 1), Cells(4 + (i - 1) * 5, 1)(5, 12)) Its great...

Thanks Yogia, A massive help!

Hi Yogia This is excellent, thanks, I guess I didnt quite explain myself, sorry about that, I must get used to adding more detail. I was after the data range to be horizontal, eg A5:L5, then A10:L10. I realise I didnt specify an ending column, as I was unsure what column that would be at the...

Hi all I have a worksheet that has data structured into Actual, Forecast, Variance on three consecutive lines, eg Line 5 Actual Line 6 Forecast Line 7 Variance Line 8 Var % Line 9 (blank) Line 10 Actual Line 11 Forecast Line 12 Variance Line 13 Var % and this repeats itself for...

Excellent! Thanks Skip,

Hi I have a table that has 5 columns in it by 25 rows. In the 3rd column, are company names. Based on the cell matching the criteria of the company name, is there a way of changing the background colour of the 5 columns for that one row. Eg I have been able to set conditional format so that...

not really, it seems just to be a visible dotted line outling the 'workable' chart area. it 'just appeared', well I dont remember changing any settings and it would appear there isnt any changed as new graphs do not have this same dotted line. I have tried several googles and can not find any...

Hi, Thanks for the response, nope its not a floating dotted line, its a fixed dotted line with the words chart area Its there permenantly and pressing escape does not affect it. any other ideas? thanks,

Hi On a few of my graphs I have suddenly had appear a dotted line around my graph with the words 'Chart area' in the bottom right corner connecting the dots up. It must be a viewing setting, it doesnt appear on all charts or on newly created charts, does anybody have any idea how to remove it...

Hi Sweenster I tried the Text command, but missed the vital #.## and just put "%" thanks for your help

HI I would like to have a cell show a text word and a percentage together, however I am having trouble with the formatting. Heres the scenario. In B1 I have the text XBX In B24 I have the percentage 4.5% In A1 I would like to have the two joined together to get the following result XBX...

Geoff Thanks for the advice, were getting there! I can now get the local data produced dependent on which sheet is active, which is fantastic! Below are the new named ranges. Sku1Forecast =OFFSET(Sku1XValues,4,0) Sku1Range...