excel2007

Hi I am using excel 2007 and i am having problem on what formula to use on my third sheet... my first sheet is my Main Sheet where I input data and a button for encoding. Excel WorkbookABCDEF12poducts34date delivered5monthDateYear6location of delivery78delivered by910sales1112Encode13Main...

Hi I am using excel 2007 and i am having problem on what formula to use on my third sheet... my first sheet is my Main Sheet where I input data then, a button for encoding. Excel WorkbookABCDEF1******2*poducts**3******4*date delivered****5**monthDateYear*6*location of...

I am using Excel2007, i'm doing database as my project and i am having a problem on how to do this... I have have three sheets first is the input sheet... Excel WorkbookABCDEF1******2*poducts**3******4*date delivered****5**monthDateYear*6*location of delivery**7******8*delivered...

Hi I am using excel 2007 and I am trying to put code inside a button that if i push the button and can search by its keyword from the list. The code I'm generating is this when i record macros ActiveSheet.Range("$D$1:$D$6").AutoFilter Field:=1, Criteria1:="=*Wayde*", _ Operator:=xlAnd...

Hi, I'm using Excel 2007 and having problem with date, plese help me... I have 3 rows for the Month, Date, Year respectively and i want it to be converted in a single cell so that i can manipulate and compared it with the today date and add days, week or month on the next cell. For example...

I'm using Excel2007 and I'm doing a database, i have a lots of concerns and questions, let me start with this. I have two sheets, the first sheet is the search sheet, then the second is the masterlist. I want to have a search button than can actually search for its key word and filtering the...

I'm using Excel2007 and I'm doing a database, i have a lots of concerns and questions, let me start with this. I have two sheets, the first sheet is the search sheet, then the second is the masterlist. I want to have a search button than can actually search for its key word and filtering the...

I am a newbie to posting queries on this forum but please accept my thanks for many past postings to MrExcel which have enabled me to deal with VBA issues. I have developed an Excel membership database model for a charity. VBA is used to produce various reports. Many of the reports require a...

Hello all, First of all a big thank you for all the help this board has given me as a lurker :-) Now I've small issue and I thought I could finally register and ask for help directly. I searched for an answer already but I couldn't find anything, probably 'cause the terms I searched for are too...

I have a large, (78 sheets and a high level of vba automation), well established Excel2003 spreadsheet that iI am now trying to run in Excel2007. I have a problem with one sheet where there are 8 additional rows displayed below the ribbon but above the standard column headings! Three of these...

I have problem with one function..i dont know how to do it and whether that is possible to do with formulas or macro. I have column Name, where can be one name many times, next column state, subject which are useless this time and columns points and totals I want to make function that do this...

I need to select 2 items (months that are chosen by a user) in a pivot table. I can either put the Months as PageItems (Select Multiple) or FieldItems, either way I will get the results I need (when selected manually). When choosing one item, no problem. I use the code...

I am using excel 2007. I have a formula in cell J12 that produces a number from a list depending on what the value is in C8. But, I need that number to be negative (formatted red with parentheses) if cell J11=0 and L11<0. I know I can do the RED part through conditional formatting, but how do...

I'm using excel 2007. I need to insert a text box on a worksheet that will allow me to type in comments for the client to read when we send out a report. A simple text box I can do. What I would like is to have a text box that "remembers" previous entries so I don't have to type out the whole...

I am using excel 2007: I have created the following formula (with some help from this forum), but I am getting an error message saying I am missing a left or right parentheses. Can someone help me? I can't figure it out. =IF(ISBLANK(B17),"",IF(AND($I$8="AIRBORNE...

I need help writing a formula for this scenario for Excel 2007: <link rel="File-List" href="file:///C:%5CUsers%5CSam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData"...

Hi, I have two excel workbooks, one created in excel 2003 and the other using excel 2007. When i link a cell from the excel 2007 workbook to a cell in excel 2003 workbook (that has some text in it), it shows a "#N/A" message. However if i then open the excel 2003 workbook using excel 2007...

How can I create a button hyper linked macro that will apply conditional formatting? The cells are positioned vertically in the same column, but not consecutive.