The discussions
Compare date in cell against dates in range of cells
Hello, I am trying to use conditional formatting to highlight a cell if the date in that cell is the same or earlier than dates in the rest of ...
Copy colum issue
Hello, My name is Lee Diaz I've been trying to organice and control my inventory of movies, For now I've been having to scan with a barcode scaner,...
Excel 2007 resetting cells to date format
Solved/ClosedHello, I have an Excel 2007 spreadsheet that is resetting all the data cells to Date format. Have anyone seen this before? I don't think I have a vir...
Transpose and removing duplicates at same time
Hello, I have a spreadsheet with two columns. The left column is an eight digit house ID. The right column represents miles driven by individual...
Need a macro to sum range of cells
Hello, I am a teacher from Greece and I want your help to gather information and sum from different worksheets in different workbooks to another f...
Product key
Hello, Where do I find the product key to enter for a free version of MS Publisher that I just downloaded?
Worksheet name input to move data from one worksheet to another
I have a worksheet that is identical in all values other than price. All data is collected on worksheet one. Work sheet one has a column where a...
Excel - a macro copy to cell based on a specific criteria
Hello, how to split the data from state wise using macro ex: Location type month year state India email 12 2012 UP India email 12 2012 ka...
Not be able to send more than one mail from outlook
Hello sir, I am not able to send more than one mail from outlook, during mail merge sending please short-out my problem as soon as possible.
Conditional formatting
SolvedHello, I'm using Excel 2010 and need to conditionally format a cell based on various values in different cells. Specifically, if cell A2 states B...
Microsoft project software
ClosedHello, I just downloaded Kioskea's free software program for Microsoft Project 2007. After the download and during the activation process the progra...
Comparing two spreadsheet data
Hello, Please help me out on this issue. If I have an original sheet comprising of 8 columns and a number of other row items with subtotals in be...
Simply cannot find an answer
SolvedHello, I have a spread sheet - column B lists dates for the last time a report for each product was completed. Each report is due every 28 days. ...
Saved excel will not open
Hello, I got a shock when trying to open excel sheets. The message " THERE WAS A PROBLEM SENDING THIS COMMAND TO THE FILE" i can't open any saved exc...
Power point help!
Hello, I can't open a power point presentation i the format PPTX. I have Microsoft Office 2003 what should i do? Configuration: Windows XP / ...
Activity reminder from excel column
Hello, I would like to reserve a column "B" on an excel spreadsheet to put a date in the field for "Next Activity Date". Then put the date in the...
Vb issue with delete rows with specific values
SolvedHello, I am using 2007 excel and have the VB doing 2 things: 1) looking at specific Column for EXACT values and deleting row 2) looking at speci...
Roster with each person getting their own weekly sheet printed
Hello, Ive put together a spreadsheet for work, where we have a main page called roster, the whole weekly roster for all staff members goes onto t...
Macro help: copy data from a range of sheets to a master sheet
SolvedHi, I'm looking for some help developing a macro to collect data from a range of sheets in a workbook, but not all sheets. The macro needs to: ...
Tagalog
SolvedHello, Hi! Is there anyone here knows how to speak Tagalog? If so, please let me know..I just have a few questions regarding in Excel. I cant ex...
Unable to download attachment
Unable to download flash drive, PDF and download attachments. Configuration: Windows 7 / Internet Explorer 9.0
Microsoft publisher 25 character key
ClosedHello, I downloaded microsoft publisher 2010 here. What is the product key? Please. Configuration: Windows 7 / Chrome 24.0.1312.52
How to convert number into text in excel
Solved/ClosedHello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"
How to make foxit reader to read aloud just one paragraph?
Hello, I don't want it to read the entire page, just one paragraph at the time. Is that possible? Thanks Configuration: Windows 7 / Firefo...
Unable to install ms-office
Hello, i have problem when installing the ms office.....it doesnot instal in my system.....please help me.... Configuration: Windows XP / Fir...
Camparing two coloumns in excel and copy another cell value
Hello Sir I have two excel files where I want to match file1 Coloum A with File2 Coloumn A If match found File1 Coloumn C cell value should copy to...
Adding a new entry into a list - excel 2007
Solved/ClosedHi Hope that someone can help me with this problem..... I've created a list in Excel 2007. I've added 3 colours in the list (blue, red, green). I ...
Need help with macro for 2 worksheets
Hello, I've seen examples close to what I need, but I'm not an experienced macro person and I don't know how to tweak them to get what I want. ...
I need help getting info from one worksheet to copy to others
Hello, I have an Accounts Receivable worksheet for each year. I want to log each entry into the main spreadsheet and then into a separate worksheet b...
Hi, need some help - copy pasting and creating coments! thanks
Hello, Getting a little stuck - would anyone know how to copy text/number from one cell and with one function: in a new cell create a comment AND ...
Vlookup range question
SolvedHello, =VLOOKUP(A4,OLD!$A1:$B1404,2,FALSE) I'm using this formula in my spreadsheet and it is working EXCEPT when the new spreadsheet has inse...
Colour column based on dates
Hello, I'm having a hard time to figure out a formula that colour the column with respect to dates. Can anyone help me out on this please..here's...
Microsoft publisher
Hello, I downloaded the Microsoft Office Publisher from this site. But now it's saying I need an activation code. Am I missing something? Activati...
Outlook certificate to send sms
Hello, I am trying to add SMS functionality to Outlook to make a notfication system (e-mail and SMS.) I got an idea from this page http://www.oze...
Macro which can countif on multiple criteria and export result
Hello, I have to create a macro, which can count for me how many of different categories of services we have. there are around 20 main categorie...
Macros
Hello, I'm new to Macro's and now wanted to learn how to run a macro based on the column values. Eg: If in column D has a values and if D3 has ...
New in ms excel
Hello, Morning! Anyone can help me? i dont understand what ive read in wiki about macros. i dont know how it works even in simple excel! Can y...
Macro - concatenated cells until if finds a blank cell
Hello, Please assist. Im trying to concatenated cells with text until it finds a cell with no text then it stops current continate then continues...
How to useing percentage formula in excel
how to useing percentage formula in excel Configuration: Windows 7 / Chrome 24.0.1312.52
Outlook - "unknown error" ox800ccc81
SolvedHello, re https://ccm.net/faq/5929-outlook-unknown-error-ox800ccc81 would you have a fix for this with Outlook Express? thanks Configuration:...
Adding the same action to every second line
Solvedhi guys, i wonder if you could help me with the following: there is a worksheet where column A is full with numbers. I would like to add to ever...
Sum certain cells in a column if corresponding cells of another
Hello, I want to sum certain cells in a column if corresponding cells in another column contain a certain letter. I have amounts in cells G2:G1...
Conditional equation
Hello, I am desperately trying to write a formula for the following: If C23 is less than 2 but greater than zero, then value of E14, and if not,...
Formula to measure percent of checklist complete
Hello, I am trying to build a checklist where if you have completed the task on the list, you put an X in the cell below that task. As tasks...
If, then formula
SolvedHello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had passengers...
Counting between two given dates
Hello, I need help. I need to count on Excel 2007 between two dates including the start date and end date. But the DatedIF fdoes not work. and...
Using character map in windows 7
Hello, i am using Open Office Writer and i have two questions : First : i want to write arabic numbers directly without using menu bar ( in...
Convert date into month name
Solved/ClosedHello, suppose date has mention 1/1/09 and no month name then how to get the month name
Macro to copy data under matching column header
I am trying to write a macro to copy data from multiple spreadsheets and get the data to paste into the proper matching headers. Here is what I have s...
Copy excel 07 sheet to other & keep formulas?
Solved/ClosedHello, Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep t...
