I'm trying to create a new sheet for each day of the year. It needs to contain the day and date but I really don't want to copy and paste 2 years of forms and...

I currently get a new report every month in xls format which I have to spend a few hours to manualy find duplicates from the last report before i can process...

Hi, I have a requirement , I have posted thread but not getting solution and its urgent so I am sending mail... If u can help me then I will be really...

I have the following formula: =SUMPRODUCT((Input!$C$3:$C$48943"")*(Input!$A$3:$A$48943=DATE(2009,3,30)*(Input!$A$3:$A$48943=DATE(2009,4,3)))) I am using...

Hi, i need a formula that retrieve data if one of two criteria is met. I need the formula in "C". If A1 or B1=Sheet2!A1:D25,retrieve content of cell...

Hello, Below VBA works perfectly for non passwords. How can we incorporate Getopenfile with opening the protoecting workbooks ( all workbooks have the same...

Hi, I use Excel 2007 Home and Student. It has a lot of columns (max. number: XFD. you do the math). that means the horizontal scroll bar is very not...

As you may know that T-Bonds price format is xxx-xxx (e.g 110-16 which is equivalent to 110 16/32 or 99-245 which is equivalent to 99 24.5/32) Now I need to...

How can I split one cell in excel 2000 three ways, horizontally, to where I have a name, then an email address and finally a phone number? Perhaps this is...

I have an single column of data (see below) that randomly has numbers inserted at the beginning of the text. The database unfortunately cannot be altered at...

Hi I have an array in my vba code. Values from range from 5 different sheets are saved in these arrays the code is Dim r1 as variant Dim r2 as variant Dim...

I have a list that i need to remove all Duplicates, if I find any, example List 1 1 2 3 3 4

Hi, In Excel 2003, how can I automatically sort a range of cells which hold the computation of other cells? Let's visualize this by means of an...

When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data...

Working with 2 spreadsheets - trying to look up by value A1 (Item number). Many of the rows work correctly...however for item numbers that contain a dash...

I want to know Excel to a higher level, I worked with formulas, small macros etc.. but I want to be able to create more complex macros and more complex...

From the explanation on the subject, I'd like to ask why the system is set up in a way that if users don't write anything in this space (message), answers can...

let's say i have this excel calculation. cell A1 air surface (drop down menu) cell A2 water surface (drop down menu) Cell B1,C1,D1 are all input value to...

How do I go about deleting check boxes (400 + lines with 4 on each line) copies from internet to an excel page, in one fell swoop? Or can't I. -- Ferret Mom

Hi I know i can use a calendar in a sheet but can i use a calendar in a userform ? Maybe by a little icon (image) and when clik a form with a calendar pops...