Search results

Sub NEWSNAPSHOT() ' ' SNAPSHOT Macro ' ' Dim DATETEXT As String DATETEXT = Range("DATETEXT") Sheets("Board").Select Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False...

I've tried but can only see things about removing the password set on VBA, if you could offer some clues as to what to type in to find it that would be much appreciated

I have a Macro that takes a Password Protected workbook and does certain things to it then saves it in another area, I would like to remove both read and modify passwords on the newly saved version, I tried to record the action of me doing Save as - tools - general options and deleting the...

I have one cell that has an EOMONTH formula in, returning the number 3 (for March) I have an offset formula that needs to use this number as the width, but because it is an EOMONTH formula, the Offset returns a #REF!, if I was to hard code the 3, my Offset formula works, how can I get this to...

Success! Luke, I think I love you!

Scrap that Luke, worked it out, now to test!

Right! Debraj, for some reason that formula doesnt work on my workbook, I just get 0 for all lines Hui, Unfortunately this doesnt tell me the amount of days that fall in the period overlap Srinidhi, First of all, in the period range specified its bringing back 4 when it should be 5 and for...

Unfortunately oldchippy that produces negative numbers, Luke, that formula does not give me a 1 where the start date of the first period is the same as the end date of the second period, it returns a 0 ??

I have a period of 01/02/13 - 30/03/13 I have another period of 01/02/13 - 05/02/13 I need to know how many days of the first period (01/02/13-30/03/13) appear in the second period (01/02/13-05/02/13) Answer = 5 Please help, this is driving me mad!

Perfect, thank you!!!!

Im not sure how that relates to my question?

My mind is going blank on this, Im sure it must be easy! I have a period ie. 04/01/2013 - 02/02/2013 elsewhere in the spreadsheet I have; WK 1 01/01/13 08/01/13 WK 2 09/01/13 16/01/13 I need a formula that looks at the period and puts a "1" in every week that the period covers, what...

Just worked out that its only when there is a live connection to our accounts system that uses an Excel Add in, looks like its a problem for them to resolve then! Thanks anyway for your help

Has anybody else had a problem when clicking Save as to change the file type? I have encountered this problem a few times now using Excel 2010, the first time was a csv file that I made some changes to I then wanted to save as a xlsx but when I clicked the drop down menu to select Excel...

Im not entirely sure what you mean, but I need a formula that works on closed workbooks, is this going to do that? the orginal formula that Hui gave me works fine but you need to have the linked workbook open at the same time which I dont want, if your formula should defintely do what I need...

Im not entirely sure what you mean, but I need a formula that works on closed workbooks, is this going to do that? the orginal formula that Hui gave me works fine but you need to have the linked workbook open at the same time which I dont want, if your formula should defintely do what I need...

This is the actual formula that I have put in as per the SUMPRODUCT suggested above; A88 = 101 AB86 = May =SUMPRODUCT(('[Summary budget 2013 v7.xlsx]Switzerland'!$Z$7:$Z$62=$A88)*(MATCH($AB$86,'[Summary budget 2013 v7.xlsx]Switzerland'!$J$3:$U$3)>=COLUMN('[Summary budget 2013...

I cant seem to get that one to work Im afraid :-(

Anyone got any suggestions please?

I cant get this to work on closed workbooks, is there a way round it please?

Also, I'd rather not have to change the formulas, if there's a registry fix, that will be better

I've got a problem with linked spreadsheets having to be open for my formulas to work, I'm clicking no to "Do you want to update" but it seems that it still needs the source workbook open as its just coming up with #VALUES, I've never had this problem with older versions of Excel is this a known...

Thats brilliant thank you, I also need to get a year to date figure, what might you suggest for that please ie. the result to be 128473 ?

Hi, I've gone a bit mad and can't seem to get this SUMIFS to work. Code, Jan, Feb, Mar, Apr, May, Jun 101, 54564, 55, 212, 154, 454, 98 214, 78214, 65, 784, 986, 487, 475 101, 71234, 87, 871, 369, 473, 247 I'm writing my SUMIFS as so; SUMIFS(B2:G4,A:A,"101",B1:G1,"May") To get a a...

I need a formula that says; If A does not equal B, and A does not equal C return the result in D whats the best way of doing this please?