The discussions
Dynamic range and named ranges
SolvedHi, I have a list of students in Sheet 1,2,3 where being updated regularly. They are named ranges "Boys" & "Girls" in Column A & B respectively. In...
Excel 2003
Hello, Can you help me, I am trying to write a conditonal formula in Excel 2003 that goes something like: If current date is 6mths from date o...
Complete payroll computation
Hello, i would like to learn how to do payroll transactions. can you help me? thanks Configuration: Windows 7 / Chrome 23.0.1271.64
Compare 2 cells in different worksheet and place the value
Hello, I am not expert in excel, and i need help to use a formula to compare 2 cells in other worksheet and fill the value in a blank cell if it is t...
Delete certain data from excel
Hello, Im playing with big numbers of data in Excel. I want to do data cleansing process. How I want to delete certain rows that unnecessary anymore...
Info transfer based on entered value
Hello, I have data in n excel database called inventory. The first column of data represents a unique box number. I need to enter a box number, do...
File conversion message
Solved/ClosedHello, I use Microsoft Outlook 2003 for my emails. I cannot open any attachment that comes as a Microsoft Word document. I get the message "File Con...
In outllook 2003 message format is hidden
Hello, i m using outlook 2003 whenever i create new mail i have to always select the option of HTML text. i found the setting how to set default....
Excel dates
Hello, I have two excel sheets. In sheet one i have certain dates associated with certain IDs. In sheet two i have certain dates associa...
Calculate sales
Hello, I want to keep track of my sales.I have four columns.Below is excel data. Show only one day at a time. Date X Y Z 08-11-1...
Macro - add row, auto fill text and formulas with relative offss
Hello, I have very big problem and I can't find answer for it. Maybe You can halp me. 1. In Sheet "Intro" I have row (5), in wich are formulas:...
Compare dates in excel
Hello, Hello, I have two excel sheets. In sheet one i have certain dates associated with certain IDs. In sheet two i have certain da...
If row in column contain word, insert text next column
Hello, I have an excel files, and in column B I have a file path, but if it contains a specific word like "proprietary" I need to insert into the ...
Multiple data in one column
Hello, How do I plot multiple data in one column? Example: I submitted 10 for today. So my column chart will show a column with a value of 10...
Multiple data in one stacked column
SolvedHello, i am trying to plot a column chart and I want multiple data to appear in one column. example: I am plotting all the submitted inspections...
Matching columns in one spreadsheet
Hello, I have a spreadsheet that has last names in column A and first names in column B. Somehow they no longer match. For instance -Mary Smith...
Office 7 outlook configure with rediffmail ac
Hello, i am sudip, I have a problem that I want to configure my rediffmail account on office 1007 outlook express but outgoing and incoming mail se...
Environ$ variable library required
Hello, i need to know about Environ$ , getting error that no library for this function.Please tell me about the library required for it. Config...
Formula 3 books open in excel
I have 3 books open in excel (Book 1) I would like to make my template. (Book 2) is a spreadsheet of stores. (Book 3) is a spreadsheet of opera...
Array example to remove duplicates entry
Hi there, I have three column for lookup and i used combination of all there as a primary key to look into master sheet. want to remove the dupl...
Creating a macro
Hello, I am trying to remember how to create a macro that will allow me to compare values in column A from sheet 1 to column A on sheet2 and if th...
Matching similar data in 2 columns
Can any super Excel guru help me please? I am trying to find out the same item from 2 different database: I have 2 columns of product code, for exa...
Vba for deleting data in row but not formulas
SolvedHello, I am working on a spreadsheet where I have to copy data over to a new sheet, once the data is copied I want to delete the data in the row f...
Drag the mouse
Hello, i could not drag the mouse. how to do drag the mouse to down, what are the settings ? Configuration: Windows XP / Firefox 16.0
Automation of running excel macros
SolvedHello, I have a macro in excel which needs to be run twice a day and I dont even want to open the excel sheet. How can I make this process automati...
Help in writing vba macro excel
Hello, I wish to write a macro for following: 1. Delete entire rows if column L or column M contain DATE. 2. Move deleted entire rows to other...
Comparing two cell in different spreadsheets
SolvedHello, I'm currently struggling to do the following: Spreadsheet A Sheet1 Name Expenses Date ...
Insert x number of rows below based on value of x
Hello, I have in Cell (B,3) a count indicating number of rows to be inserted below without deleting values in subsequent cells, in cell (B,4) anot...
Search & copy function (macro)
Hello, First of all, i will thank all who reads this question. And such a good forum. I have a question regarding a Macro. Basically i have...
Comparing two lists of id numbers in excel
SolvedHello, thanks in advance for reading this. I have a list of student ID numbers which I would like to use as a student check-in. Column A is the num...
Saving word documents
Hello, I am having trouble saving word documents and I am told it's got to do with the template. What is it anyway? Configuration: Windows 7 / ...
Tomcat server errror in eclipse
Hello, I am getting following error in my eclipse Tomcat server. Could anyone able resolve this issue.? "Starting tomcatv6.0 server at local...
Update cell value by command button
Hello, I would be very grateful if someone can help me in the following issue. I have excel sheet with almost 300 rows. One of the columns I fil...
Reminder in ms excel 2003
Hello, I would like to add reminder which displays reminder message once it opens. Onething I dont know the VB or something extra programming soft...
Excel i want to sum only numeric values except alphabetic values
SolvedHello, in a school resultsheet where each student having numeric values of their marks in 5 subjects.i am using formula =D6+F6+H6+L6+P6 for total ...
Change cell color based on input in a range of cells
SolvedHello everyone, I have formatted a cell based on a specific text entered in one cell. Example, A1 will turn green if I write "yes" on B2, using cond...
Nested if's
SolvedHello, I would appreciate if somebody could help me in solving this problem. I am trying to make exel decide in an scheduled soccer games which team ...
Excel date format won't change
Solved/ClosedIf I enter a date into a cell in my Excel spreadsheet using the shortcut (CTRL+;), I can no longer change the formatting (right-click, format cell). T...
Activechart.seriescollection
Hi, Guys! Can anyone help me with this code below. I want to make the range of the ActiveChart.SeriesCollection to be from $C$3 to my last cell wit...
Pop up reminder
Hello, 5 day Pop up reminder for excel in vba that runs in excel 2007 I'm new to this hope you can help Thanks djandpj Configuration: Windo...
Macro to merge rows but keep column data
Hello, I am new to this and I have seen there a number of questins regarding merging rows in Excel. I hope someone can help with this one: I h...
Macro - predefine column id
Hi There, in order to add more flexiblity, I want to predefine the column criteria/search column ID at frontend ie in excel sheet and use it at ba...
Office publisher
ClosedHello, Just downloaded Office Publisher. Download said free but it is asking for a produst key which I don't have. Any suggestions? Please Help! ...
Product key code
ClosedHello, MY SON NEEDED MICROSOFT PUBLISHER TO DO SOME HOMEWORK. I'VE download the free version from your site, as i won't use it again but i need ...
Excel,problem with if function
SolvedHello, i am working with excell with follwing formula- =IF(H33>=75,"A",IF(H33>=60,"B",IF(H33>=45,"C",IF(H33>=33,"D",IF(H33>=0,"E",IF(H33=AB,"E"...
Excel drop down / formula help
Hey Everyone, I am looking for some help with this formula. I have a spread sheet that has 11 categories, all are sorted into a dropdown menu in...
Looking for a product key?
Hello, I have downloaded the microsoft publisher 2010 but need a product key to use it where do i find this? Thankyou Configuration: Windows...
Word 2007 options
Hello, I am not an expert with Word 2007. Any assistance would be appreciated. I am trying to create a document that will change based on a dr...
Convert rupees to spell value as text
Hello, I want to convert rupees to spell value as text.please tel me what is the programs. like e.g 2*2=4.then i need the 4=four.or 2020= two t...
Excel i want to count number of persons in given3diff.conditions
I am making result sheet where 60 students obtained different marks out of 500 marks now i want to count the number of students in 3 different cells w...
