The discussions

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...

Last reply on 12 Nov 2012 by
venkat1926

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...

Last reply on 11 Nov 2012 by
aspperasp

File conversion message

 Solved/Closed

Hello, 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...

Last reply on 11 Nov 2012 by
rod

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....

Last reply on 10 Nov 2012 by
Ambucias

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...

Last reply on 8 Nov 2012 by
Zohaib R

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...

Last reply on 8 Nov 2012 by
Zohaib R

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:...

Last reply on 8 Nov 2012 by
TrowaD

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...

Last reply on 8 Nov 2012 by
TrowaD

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 ...

Last reply on 7 Nov 2012 by
Zohaib R

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...

Last reply on 7 Nov 2012 by
diestra123

Multiple data in one stacked column

 Solved

Hello, 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...

Last reply on 7 Nov 2012 by
Zohaib R

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...

Last reply on 5 Nov 2012 by
TrowaD

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...

Last reply on 2 Nov 2012 by
asif

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...

Last reply on 2 Nov 2012 by
Zohaib R

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...

Last reply on 2 Nov 2012 by
Zohaib R

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...

Last reply on 1 Nov 2012 by
TrowaD

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...

Last reply on 31 Oct 2012 by
rizvisa1

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...

Last reply on 31 Oct 2012 by
Zohaib R

Vba for deleting data in row but not formulas

 Solved

Hello, 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...

Last reply on 31 Oct 2012 by
Debs269

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

Last reply on 31 Oct 2012 by
sathya1999

Automation of running excel macros

 Solved

Hello, 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...

Last reply on 31 Oct 2012 by
Aurorian

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...

Last reply on 30 Oct 2012 by
TrowaD

Comparing two cell in different spreadsheets

 Solved

Hello, I'm currently struggling to do the following: Spreadsheet A Sheet1 Name Expenses Date ...

Last reply on 29 Oct 2012 by
narley7

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...

Last reply on 28 Oct 2012 by
rizvisa1

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...

Last reply on 28 Oct 2012 by
rizvisa1

Comparing two lists of id numbers in excel

 Solved

Hello, 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...

Last reply on 28 Oct 2012 by
rizvisa1

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 / ...

Last reply on 28 Oct 2012 by
rizvisa1

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...

Last reply on 26 Oct 2012 by
rizvisa1

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...

Last reply on 23 Oct 2012 by
rizvisa1

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...

Last reply on 23 Oct 2012 by
TrowaD

Excel i want to sum only numeric values except alphabetic values

 Solved

Hello, 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 ...

Last reply on 22 Oct 2012 by
soni17177

Change cell color based on input in a range of cells

 Solved

Hello 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...

Last reply on 22 Oct 2012 by
diestra123

Nested if's

 Solved

Hello, 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 ...

Last reply on 21 Oct 2012 by
rizvisa1

Excel date format won't change

 Solved/Closed

If 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...

Last reply on 19 Oct 2012 by
Peaches

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...

Last reply on 19 Oct 2012 by
leuroyz

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...

Last reply on 18 Oct 2012 by
TrowaD

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...

Last reply on 17 Oct 2012 by
rizvisa1

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...

Last reply on 17 Oct 2012 by
rizvisa1

Office publisher

 Closed

Hello, Just downloaded Office Publisher. Download said free but it is asking for a produst key which I don't have. Any suggestions? Please Help! ...

Last reply on 17 Oct 2012 by
Ambucias

Product key code

 Closed

Hello, 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 ...

Last reply on 17 Oct 2012 by
Ambucias

Excel,problem with if function

 Solved

Hello, 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"...

Last reply on 17 Oct 2012 by
soni17177

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...

Last reply on 17 Oct 2012 by
darthchester

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...

Last reply on 16 Oct 2012 by
aquarelle

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...

Last reply on 12 Oct 2012 by
rizvisa1

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...

Last reply on 12 Oct 2012 by
Zohaib R

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...

Last reply on 11 Oct 2012 by
rizvisa1

Copy linked fields in excel spreadsheets

Hello, I have two excel spreadsheets, that have invoice number as a common field. In sheet A, the the invoice number might repeat in 5-10 rows, on...

Last reply on 11 Oct 2012 by
rizvisa1

Vba code: copying rows from multiple sheets

Hello, I'm trying to use VBA to copy rows that satisfy a certain 'If-Then' statement from multiple sheets in Excel onto one sheet. All of the sheets...

Last reply on 11 Oct 2012 by
rizvisa1

Excel.i want to count the number of persons in given 3 condition

Hello, 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 differe...

Last reply on 10 Oct 2012 by
rizvisa1

Forgot password

 Solved/Closed

Hello, I am alin i have been using kaksoft folder lock protect the folder...but i could not use the folder so that i forgot the password so how wi...

Last reply on 10 Oct 2012 by
Ambucias
Results 5051 - 5100 out of a total of 12,264