Search results for query: *

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

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

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

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

Hi I have visited this challenge before and despite numerous attempts I am still drawing a blank and really need your help. I have 4 named ranges as follows Sku2Forecast =OFFSET('Sales Report Jan06-Dec06 new.xls'!Sku2XValues,4,0) Sku2Range =OFFSET(PS2!$D$6,0,0,1,COUNTA(PS2!$D$6:$HF$6))...

Hi I have the following formula =VLOOKUP($B53,Pricingsheet2006value,MATCH(PS2!GN56,Pricingsheet2006date,0)+1,FALSE)*GN59 and in the next cell =VLOOKUP($B53,Pricingsheet2006value,MATCH(PS2!GO56,Pricingsheet2006date,0)+1,FALSE)*GO59 In Cell A1 I have the sheet name, in this example PS2 Is...

Hi All Skip, I found this code provided by you previously to insert a new line every x number of rows. Can it be modified so that it inserts row 1 (containing header data) each time? I need to insert it every 72nd line. Sub InsertEmptyRows() 'this is generally not a good idea 'a better...

Hi I have a worksheet that is keeping track of companies and their associated monthly revenue by month. The worksheet uses a sumif to collect the revenue. The worksheet is laid out by company in ascending order (a-z) However the A company is not the largest ytd revenue Is there a way that I...

Is there a way of being able to look up a value in a cell by the background colour of the cell? We use a spreadsheet that has several different product codes in column c, and each product code has mulitple values with diferent colour backgrounds on the same line(each colour representing a...

Hi I use the following code to return a value from a cell. =INDEX('YTD ''06 Analysis'!$B$5:$IT$500,46,(MATCH(Summary!$C$3,'YTD ''06 Analysis'!$B$5:$IT$5,0))) This basically matches the column with a date designated on the summary sheet, then moves down 46 columns and pulls the data out...

Hi I have 5 sheets formatted the same way. I would like to use a named range to pull data from the sheets and would like to know if I can do one named range but have the sheet name used as the 'differentiator' I also have the name of the sheet in Cell A1 if that helps, by using the FAQ...

Hi Is there a way to add a number to a cell reference. I have the following reference on a summary sheet that I would like to increment by 20 ='Total Sheet'!D858/1000000 I would like to increment the D858 to D878 then D898 Is there a way to do this? Thanks,

Hi I am trying to create named range that pulls the current worksheet into the named range so that it is relevent to that worksheet. I have been advised that INDIRECT is the right way, although I have not been able to get this to work, Is it possible? Thanks,

Hi I have a DNS server running on win2003 os. I am having trouble with it on non .com domains. If I do nslookup pg54.com I get the following result server ns1.99hosts.com address 87.127.247.122 non-authoritative answer: name: pg54.com address: 195.74.109.99 However if I do the nslookup...

Hi all I currently have a win2k server running DNS and hosting approx 200 zones. I have a new win2003 web edition server that is now running DNS too. I would like to know if there is a way of being able to transfer all the zone records from the old 2k server to the new 2003 server. Each...

Hi I am hoping you can help advise on a best pratice solution with named ranges. I have 5 sheets that are all formatted in the same style. On each sheet I have a chart that I am using named ranges on. the coding is as follows: chart1Forecast =OFFSET('GameStation Sales Report...

Hi Is there a way of being able to use a text value as part of a formula I have the following VLOOKUP($B308,INDIRECT("'["&TEXT(C$7,"MMMM YY")&".xls]"&$B$307&$A$294&"'!"&'Master data'!$F$4),MATCH($A$293,INDIRECT("'["&TEXT(C$7,"MMMM YY")&".xls]"&$B$307&$A$294&"'!"&'Master data'!$E$4),0),FALSE)...

Hi I have a formula that is being truncated by the cell for display. Is there a limit to the number or characters that a cell can display? Is there a way of being able to read the whole formula without it being truncated? Thanks,

Hi I would like to be able to pull data from a cell matching the appropriate date and currently use the following formula. =INDEX('FEB 06'!$C$5:$Z$100,24,(MATCH(Summary!$C$3,'FEB 06'!$C$5:$Z$5,0))) This works great, however I would like to take it one step further and have the FEB replaced by...