Hello, Im trying to get a formula for the following statment: A1 is Within 20% of net sales, then give it a score of 5 A1 bt. 21-25% of net sale...
Hello, a problematic case, when comparing values in multiple cells (rows) in Excel. In a single cell , "A1" I would need an answer depending on...
Hello, I need help here. Have tried everything I can think of and still not getting the results I need. I need a formula that will list the na...
Hello, My daughter downloaded Lockdown Browser from her school website. Now everytime we try and open anything, including iexplorer, ms word opens. ...
Hello, I am having problems writing a macro which will search for a date that is inputted at cell C1. IF the same date is mentioned in row 3 then co...
Hello, there is a two sheet in excel one is data & second blank how to i creat a perfect database in second sheet which is not repeat in first s...
Hello, Dear sir, I requeire answer for the below. Persone name Product name---Quantity sold RAJA LUX ...
Configuration: Windows XP / Internet Explorer 6.0 When I use the following code in an excel vba module: PDFFile = "c:\test.pdf" Active...
Hi, I want to download details from my outlook to excel. Can this be done using macros? Please assist.
Hi rizviza1, Maybe you remember me , a few days ago you help me with this code: Sub ComboBox_Change() Dim Target as String Target =...
Hi, I have the table having 8 Coloumns and abt 800 rows. I want to highlight the duplicate rows based on 4 columns. I gone through remove du...
Hello, I hope someone can help with an easy way to do this! I have a list of customer numbers in column A and I need to create a table showing ...
Hello, I need to compare two columns of text data by row. All I want to identify is where C4 (last months rating of B), is not the same as D4 t...
Hello, I've come close to making this work, but I can't quite get it right. I have a spreadsheet with customer acct # in column B-- we receive th...
Hello, I am having diffficulty writing a formula to calculate a percentage. I need to calculate 25% of $ 3,100 - I thought I had it figured ...
Hello, I have invoices that have all employees listed. I am looking for the easiest way to delete the employees that have "0" entered in column E. ...
Hello, Is there a way to write a script to copy a sheet and email it when someone closed excel? I am trying to get a sheet called "Daily Closures...
Hello, I'm trying to sort and filter a file with 167 rows. When I do the filter, it will only go up to row 150. I looks like it will not do anythi...
Hello, I am need to have a script run each time a cell changes to a date in column O, line 12 and after. I have a spreadsheet that has one tab ca...
Hello, I'm trying to create an Excel spreadsheet that if a cell is greater than 4, the whole row changes color to red automatically (without setting...
Hello, is it possible to connect excel with ACCESS database,so that changes made in excel or access should get updated on the other......please help...
Hello, I'm trying to add exact percentages like 99.54%, 84.23% in six cells then calculate the average. I've tried =AVERAGE(A1:B1:C1) but it only ...
Hello, I want to use a nested function to locate and flag data in a separate cell. I currently use a complex formula such as in G6 and down (...
Hi, I have multiple comma delimited text files that are generated from an analytical instrument. What I want to do is be: (1) Able to select ...
Hello, Am having a problem when it comes on browsing the internet using my NDKLA n97, am unable to to access hotmail and other useful sites to me,ac...
Hello, I searched a lot and found quite some useful results about searching Partial Cell matches. But if the cells belong to different sheets how ...
Hello, I'm working on an excel worksheet where I have 2 spreadsheets running. On one of them I have a list transactions with different categories ...
Hello, I have tried so many times but could not do. So give me some tips to record new macro and it does play all actions slowly when click on run m...
Hello, i need a vb script code to compare two excel files, eg. file1.xls and file2.xls has to be compared using vb script....please help me...
Hello, I need to find the department number on sheet2 based on the list on sheet1 and then once that is matched bring the total cost that will be ...
trying to delete all rows that are the same leaving in the excel only the rows that are unique ex: heading 1 heading 2 heading 3...
Hello, I have a tough macro to figure out! There are 3 parts to it. Here is what I have: I have an excel worksheet that is currently filtered...
Hello, I need a macro that will flip a positive to a negative and vice verse. I had the following but it stopped working all of a sudden... Di...
Hello, In Excell, I want to copy the same line several times within the document making slight changes after pasting each line. A change made in th...
Hello, If someone could tell me how to run a macro upon switching worksheets, that would be extremely helpful. If this is not possible, perhaps ru...
Hello, If I accidentally run a macro, can I (edit undo) to retrieve the information back to how it was? Configuration: Windows XP / Internet Ex...
Hello, I have a worksheet that is filtered by a number. I would like to blank out columns M, N, S and T. (Only the filtered information) Can yo...
Hello, if date in cell A1 appears anywhere from B1:B30 then apply format. Configuration: Windows XP / Internet Explorer 7.0
Hello, I hope somebody can assist me with this. I wanted a macro which identifies the colour of the cell and displays the colour in a notepad for...
Hello, If I have list of the dates, how I can count the dates that pass today? Configuration: Windows XP / Safari 533.4
Hello Guys, Maybe you can help me with this one, I am trying to run a macro when a cell changes value, the code im using is the following: Priva...
Hello, I'm looking for a code, i can put in a combo box to show up different tabs located in my spreasheet. example: I have four tabs called tab1,...
Hello, Configuration: Mac OS X / Safari 531.22.7 I need to transfer (copy and paste) certain information from Column A of one tab (Tab 2) t...
Hello, I have an excel spreadsheet which I used to keep track of some records. A sample as below: ColumnA ColumnB Row1 07/09/09 ...
Hello, If i have a list of one thing in column A and list of another in column B, Can i get a full list of any column in another sheet with some f...
Hello, I was working to have the week numbers in excel and i step into a question when i entered in cell "B1" the date 05/1/2010 and i changed the...
Hi. I have a formula that relies on a series of monthly updates all being populated before it will produce an outcome. What this means is that even if...
how to delete web script in my excel sheet. i select the web script picture, and press delete & Cut options is not working.
Hello, My computer was running kinda slow so I decided to run an antispyware program. It's called "SUPERantispyware" and I ran a scan and it claimed m...
Hello, I am using Excel 2003. I am trying to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. It...