The discussions
Transferring data from one sheet to another
SolvedHello, I have been using Excel for a number of years but fairly new to formula etc. I need a VBA code that can copy data from costing(raw data) to ...
Convert text mixed numbers to spelling
Hello, i want to know how can we convert in excel the mixed numbers such as 1ZXV78 to "one ZXV seven eight".. can some one help on this task, ...
What formula shall i use
Hello, Hi morning! I Have a problem right now. Here's the thing. I' working on an Ms Excel. My data are the following: "Assigned Reg...
Vb script to read data from another sheet
Hello, please provide solution , please find my requirement Sheet1 column name values A 1 B ...
Cell with cal/min
Hello, I want to calculate the (k)Cal/min in excel. I have a cell with start time defined in time and a cell with endtime (from a running session)...
Time calculations on a 24-hr clock
SolvedHello, I need a formula that I can apply to my spreadsheet that will calculate how much time it takes someone to complete a task. Everything is b...
French- english word?
Hello, Im trying to work out how I change the language on my word to English, as I accidently installed it all in French and now I cant work it ...
Auto notify or mail when excel sheet updated.
Solved/ClosedHello, We have a Excel which is saved to a network drive and used by multiple users. What I need is when somebody updates the excel sheet or puts ...
I have a problem with microsoft office starter?
SolvedHello, I would respctfully ask anyone to help me with this problem which is: someday I have open the Microsoft Office starter and then I have been ...
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...
