Office Software Forum
- Excel (9,746)
- Open Office (113)
- Outlook (639)
- PDF (334)
- PowerPoint (174)
- Word (2,185)
-
compare dates in excel Closed
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 Closed
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 Closed
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 Solved/Closed
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...
-
Matching columns in one spreadsheet Closed
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 Closed
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 Closed
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 Closed
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 Closed
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...
-
macro to create new workbook for each column Closed
Hi All, I would like to ask for your very kind help to the below query. I have a big excel files say containing 100 + 1 extra columns. I wan...
-
Creating a Macro Closed
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 Closed
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 Solved/Closed
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...
-
drag the mouse Closed
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 Solved/Closed
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...
-
Help in Writing VBA Macro excel Closed
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 Solved/Closed
Hello, 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 Closed
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) Closed
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 Solved/Closed
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...
-
Saving word documents Closed
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 Closed
Hello, I am getting following error in my eclipse Tomcat server. Could anyone able resolve this issue.? "Starting tomcatv6.0 server at local...
-
loops Closed
Hello, I have a spreadsheet that was converted from pdf, but the info is not in rows like a normal database. The headings are repeated throughout...
-
Update cell value by Command button Closed
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 Closed
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 Solved/Closed
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 ...
-
change cell color based on input in a range of cells Solved/Closed
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...
-
Nested if's Solved/Closed
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 ...
-
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...
-
ActiveChart.SeriesCollection Closed
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 Closed
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 Closed
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 Closed
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 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! ...
-
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 ...
-
excel,problem with if function Solved/Closed
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"...
-
Excel Drop Down / Formula Help Closed
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? Closed
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 Closed
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 Closed
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 Closed
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...
-
copy linked fields in excel spreadsheets Closed
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...
-
VBA Code: Copying rows from multiple sheets Closed
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...
-
excel.i want to count the number of persons in given 3 condition Closed
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...
-
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...
-
how to copy/paste a file from external file into a worksheet.. Closed
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...
-
Comparing two columns of names in Excel Closed
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...
-
07 Wb opened w/ 03 and it Reopens after Close Closed
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. ...
-
Mirroring data from multiple sheets into one summary sheet Closed
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...
-
Highlight Cells Based on Drop Down List Selection Solved/Closed
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...
