The discussions

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1 reply 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! ...

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

2 replies 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"...

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

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

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

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

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

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

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

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

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

1 reply Last reply on 10 Oct 2012 by
Ambucias

How to copy/paste a file from external file into a worksheet..

I have a problem of copying excel into new file. I have a browser which takes an excel file and puts it into a text-box. Then I have a second but...

1 reply Last reply on 10 Oct 2012 by
rizvisa1

Comparing two columns of names in excel

Hello, I need some help with an Excel formula. I have a column of user names and a column of usernames intermixed with non-user names. I would lik...

2 replies Last reply on 9 Oct 2012 by
rizvisa1

07 wb opened w/ 03 and it reopens after close

Hello, Well, I am back after my short-lived exhuberance with my other solution. I now have a problem with some of the users that have Excel 2003. ...

12 replies Last reply on 9 Oct 2012 by
rizvisa1

Mirroring data from multiple sheets into one summary sheet

Hello, I have as sheets with data in them, I would like to create a summary sheet in the same workbook such that whenever any of the sheets are upda...

1 reply Last reply on 9 Oct 2012 by
rizvisa1

Highlight cells based on drop down list selection

 Solved

Good day, I would like to have a row highlighted in color based on the drop down list selection. I have inserted the following in Worksheet but I e...

4 replies Last reply on 8 Oct 2012 by
wliang

Saving papers

 Solved

Hello Everyone, I hope someone could help... I have list of Check Numbers on Column A and Their Amount on Column B and it runs on almost a ...

3 replies Last reply on 8 Oct 2012 by
ehlblackstar
Results 5051 - 5100 out of a total of 12,259