Search results

Ah how odd. Using windows 7, excel 2010

Yeah same issue, as I scroll I want rows 1-12 to disappear until the top row is 13, then keep 13 at the very top. Rowa 1-13 are always on show in your example. Thanks

Hi Dave (or anyone), Just noticed when I delete the content of a cell i get an error Runtime error 1004 Unable to set the IndentLevel property of the Range class Assume it just needs a clause to state if it's blank do nothing (or leave at indent 1)? My VBA not quite there! Cheers

hi, nope not working. Rows 1:12 staying visible at all times. Tried various kiRowsPerScreen to see I could get it to work. Cheers

Here you go...crack it ;) https://dl.dropboxusercontent.com/u/9071274/Sparkline.xlsx

Evening all, Anyone else have issues with sparklines not showing similar values in a relevant fashion. i.e. i have two values, 8% and 9%. The two column sparkline shows one about 2 pixels in height and one about 100 pixels high. You'd expect there to be little difference or at worst a...

Hi, thanks for the replies and apologies for slow reply, away for the weekend. Unfortunately Luke thats not what I am looking for. I want to be able to see all rows, but when i scroll down the info in rows 1:12 isn't important to see, so I want row 13 (table headers) to stay at the very top as...

Hi, Hopefully an easy one! I'd like to be able to freeze at row 13 (my table headers), but having it stay att he top of the window, i don't want to see the info above as i scroll further down to save screen space? Possible? Thanks in advance

How do, actually that would cover a few of the cells, I have one that can have be +/-, so I've split the cells! Cheers Paul

Hi, I've got two values in a cell, one value is a %age of budget the other variance in £s. I'd like to be able to have green for positive and red for negative, formula is as follow: =TEXT(VLOOKUP($B$2,Data!$B$9:$DA$32,2,FALSE),"0%")&" / "&TEXT(VLOOKUP($B$2,Data!$B$9:$DA$32,19,FALSE),"0%")...

Hi, I've set up a macro to move a sheet from one file to a new file, then copy paste special values, save it and email it. When I open the file it asks if i want to update the links, when i check the edit links, it's linking to the old file, anyway i can find out where the link is? The...

Sorted, it didn't like the date formatted as a month, had to use month() Cheers

Thanks for quick reply, unfortunately when I try use it, not working. I'll provide my full line in case that makes a difference. ActiveWorkbook.SaveAs Filename:= _ "C:ReportsWeeklyReports" & ActiveWorkbook.Worksheets("Summary").Range("D77").Value & "2013 Touring Weekly Revenue - " &...

Hi, I'm trying to save a file in a location, I'd like the "Month" sub folder to be taken from a cell in the file, i.e. May, June. So instead of month it would be "A1" for example? ActiveWorkbook.SaveAs Filename:= _ "C:FolderSubfolderMONTHfile.xls" , FileFormat:=xlOpenXMLWorkbook...

Works a treat! Cheers Dave, appreciated (not sure how to close a post)

Yes. I meant to say exit cell, not exist! ;)

Thanks for the quick response Dave. How do i get it do the indent on exist of the cell?

Hi, I have a column of data B14:B10000 (in fact this is a merged column with column C, i.e. B14:C14 merge to hold the info, as I need to cells above). The cells will either contain text or a date, if it's text I'd like to indent by 1, if it is a date indent by 3. It's a product/sub...

Hi, I have a list of employees in one sheet, one column has a Yes/No value. I then have another list in sheet two, with the employee name and more info. Ideally if I select yes in sheet one against and an employee name, I would like to have the second sheet filter only on these employees...

Hats of to you Narayan, works a treat. U'll swot up on offset as it's been the answer to a few of my questions in the past! Thanks again

Hi, hope you can help, you normally do! I'd like to be able sun a column of data, e.g. A1:A52 but have the ability to change the reference A52 based on another formula/cell. It refers to 52 weeks of the year, I'd like to be able to change the week starting in another cell so the sum only...

Figured it out, changed the 5 to 1

Actually can you help with this, I've copied the formula from D66 to F66, in the hope that it would then do the same for data in M66 onwards, but it's not calculating the correct number. =SUMPRODUCT(--(MOD(COLUMN(K66:QQ66),6)=5),K66:QQ66)...

Thanks for the speedy responses guys. I've gone with option 2, works a treat. thanks again, Paul

Hi, I'm trying to put a formula in cell D66, to sum K66 and every 7th column after (i.e. Q66, W66 etc), need to sum up to 30 cells. I've been playing with INDEX but not quite getting there with it. Cheers Paul