Search results for query: *

OK guys, thanks all of you for your help - I've got the issue resolved now!

Hi, If anyone can help my problem, I'd appreciate: I have a spreadsheet where I insert a new row at the top of the spreadsheet every day. I then have another sheet which anaylses the data from the 1st sheet, counting how many of the data entries fit certain criteria. i.e. =Sumproduct(('sheet...

Hi, I am trying to get the following formula to write to a cell but getting errors due to the quotation marks. I am vaguely aware of the Chr(34) option, but cant seem to get this to work either. Can anyone help me please? Sheets("Data").Range("F4").Value = "=SUMPRODUCT(('All...

Hi, I am using date periods which do not correspond to each month ie 12 Jan - 24 Jan = Period 1; 25 Jan - 27 Feb = Period 2 etc. These are listed in a table. How can I write a lookup statement which will return what period a specific date is in - for example, if the date is 14 Jan, period 1...

Hi, I have read the threads about using sumproduct as a means to do a sumif with multiple conditions. I am still having a problem with my statement - can anybody help?! I want to sum the values in a column (J:J) when the following conditions are met: 1)The date (in column B:B) is greater than...

Can anyone help, I am still quite novice and cant solve this problem: I have writen a VBA where a user inputs data into a form, presses a button, and then the data is inputted into a spreadsheet. I have the code sorted for this with the data being written to a spreadsheet which is part of the...

Great, thanks for your help.

I am trying to write code where the user enters data into 3 text boxes, then presses a button. The data inputted is then written in that worksheet and then another worksheet in the same file. When run, the data is written in the cells of the 1st spreadsheet but then i get a bug on the...