The discussions
Change date format dd.mm.yyyy to dd/mm/yyyy
Solved/ClosedHello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2003 Please solve my problem urgently Shatrughna System Configuratio...
Excel partial match
SolvedHello, Hello, I have a small query related to Excel Search function. Suppose I need to search the below data in target cell which has some ...
Convert number to spelling
Solved/ClosedHello, I Can change the Number into Spell but the problem is it does not convert in Indian Rupees. Present Situation =SpellNumber(58.20) = Fifty ...
Transfer data from 1 sheet to another with cond.
SolvedHi, I am having trouble working out how I would code this using VBA: In Sheet 1 I have 2 rows. The first row is the title and then the second ro...
Macro to manipulate lines of text
SolvedI have data that is arranged as this in four columns x emailx nameofx 123 x emailx nameofx 4456 x emailx nameofx 67 y emaily nameofy 12 z email...
Find and replace from a dropdown
Solvedhi Guys, second and hopefully last question for now. Is there a way to the following: I have a dropdown list with names of tabs of the excel file...
How to easily cummulate data
SolvedHi there, I was wondering if you guys know how to do this: got 13 weeks, each week has a figure underneath it. Let's say week 1 has 1 under it, wee...
How to add 200 working days to a given date.
SolvedHello, Please I want to know how I can add 200 working days to a specific date to get a new date
Auto populate data between excel sheets
SolvedHave project management data that should be automated to populate from two Excel sheets to the desired Excel sheet. I was thinking that it could be A...
Cannot change the date format in excel 2007
Solved/ClosedHello, I have tried everything mentioned in this forum and they still do not work. I have a sheet with the date appearing dd/mm/yyyy, I have ...
Excel lookup 2 cells to match in 2 rows.
SolvedHello, I am using Excel to makes archives of PC issues we have in our compagny I have Info that i have to write in two cells that are standard...
Row conditional formating in excel
SolvedHi All, I'm trying to play around with the conditional formatting in excel to highlight a row in excel if a cell in that row contains certain text....
Highlight help
SolvedHello, I am needing help with being able to highlight a cell based on another cell's value. Example: I am dealing with cells J2 and J3. I am needi...
Counting sites visits within a year
SolvedHi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits ...
How to apply conditional formatting
SolvedI would like to apply conditional formatting so that Cell A4 is highlighted (filled) if Cell B4 has Text (date in the format 22-DEC-17) and unhighligh...
How to copy data to a different worksheet?
SolvedHello, I would like to copy data from a specific cell of a worksheet and paste into a specific cell in a different worksheet Eg from cell b2 of a l...
Conditional formatting - dates
SolvedHello, On a spreadsheet, the cells in column N contain a date. I need any date that is 6 weeks ago or longer to be highlighted. How do I do ...
Rearrange multiple columns in four columns, vba
SolvedHello guys, An excel rookie needs the help of more experienced users of Excel and VBA. I have a data set that looks the following way: There ...
Matchpoint score
Solvedhello I hope that someone can help me. I have an excel sheet in which I record scores of teams and I would like a formula to calculate the points acc...
Can't reinstall office 2010
SolvedCan't reinstall Office 2010. Always get a notice that an error has happened and it will not install !
Yahoo id and password hacked
Solved/ClosedHello, My Yahoo ID and password has been hacked by someone, coz of that I could I m unable 2 log in. Plz help me out and dont send a mail to t...
How to use conditional format based on text?
SolvedHello, I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "Fi...
Copy and convert data
SolvedHi, in advance I would like to thank everyone for reading my post and providing any assistance. I have an exported worksheet with 50 rows of data (30...
Vlookup, if? question assigning value to text options
SolvedHello, I need to make an spreadsheet that corresponds different text values and gives them a score. I have several tables set up, that I was tryin...
Data showing who pays a doesnt after manually input receipts
SolvedHello, Hope im clear on this. Im a bit lost. I have sheet one. This is a spredsheet where we input a secuential number with the name of the ...
English version of frontpage express
SolvedHello, Hi how do I download MS FrontPage the English version. Im only getting the French version
Filter the data in excel through formula
SolvedHello, I need a formula of the following quotation: Column A Belongs To Customer Name Column B Belongs The Date Column C Belongs To Item ...
Insert rows on change of value in excel table
Solved/ClosedHello, I have an excell spreadsheet that contains a table. I want a macro of vb to insert a row into the table when the values in a particular colum...
Pdf attachment unreadable and opens with word
Solved/ClosedHello, ever since I tried to open a Memo.4ma attachment emailed to me, my pdf files open with Word and are unreadable...they apear in encoding format,...
If function in excel error
SolvedHello, anyone can tell me where the error Is. =IF(G:G>="0:05", 0:30Min, IF(G:G>="0:20",1:30hrs, IF(G:G="0:00",0:00hrs , 4:00hrs))) * * ...
Product key of office 2010
SolvedI don't K now product key of office 2010 please send me this key Regards Pardeep Gur
Conditional formatting with multiple rules and blank text cells
SolvedHi, I wonder if someone would be able to help me with this. This is probably really simple, but I can't get it to work. I need excel to change a c...
Setting up excel formula
SolvedHello, I need some help with the excel formulas I have new taxation laws that apply my organization from January. The current taxes are 10%...
Post it digital notes
SolvedEverytime I try to download Post it Digital Notes I get the 404 error. What do I need to do?
Where can i download a free word document to pdf converter
Solvedlooking to download a free word to PDF converter
Comparing data between two excel sheets
Solved/ClosedHello, I have two excel sheets with the same columns. Essentially Name, Email, Phone. One sheet is the 'original" data and the other is the "upd...
Corrupt powerpoint file, the file extension does not match the i
Solved/ClosedHello, I have several PowerPoint presentations that I can't open them now it says " file may be corrupted when use PowerPoint or expansion file ma...
How to create serial numbers
Solved/ClosedHello, I have an excel format shows different values of schedule of correspondence and some of the mails are gone to different addresses and the ma...
Formatting cell
SolvedHello, I want to highlight the coloumn B, if the coloumn A is greater than 0, In column A having numbers and the column B having texts. here so...
Drop down look up
SolvedHello all, I have a 40 sheet workbook. I want to hide 39 of the tabs and use one sheet as the "master" to pull all of the data. I have the tabs in ...
Automatically update master worksheet from other worksheets
SolvedOkay, first I should mention that I'm a complete amateur when it comes to excel. No VBA or macro experience, so if you're not sure whether I know some...
Help- conditional cell formatting
SolvedHello, I am trying to do some conditional formatting and having a little trouble. Here is what Im looking to get. I have a column A (estimated ...
Make a macro run when data entered in a cell
Solved/ClosedHello, I have a macro that runs when the user clicks on a button. Instead, I want the macro to run when Cell D10 is populated. The data for D10 c...
Word 2010 showing dots instead of spaces
Solved/ClosedHello, when I press space tab in the keyboard, a dot is printed in the Microsoft word 2010. How can I fix this problem? faithfully you Con...
Worksheet_selectionchange event not working
SolvedHello, I wanted to execute a Worksheet_SelectionChange event code. But its not working. I searched on net to find that if I change (General) to Wo...
Working out the difference in times between two columns
SolvedI have various times in Column B (Departure time), and another set of times in Column C (arrival time). If the time in B is between 07.00 and 00.59...
Sku011.cab
Solved/Closedwhen I go to open ms word or ms excel computer ask for sku011.cab file. I have no cd of office 2003. please help
How to copy columns to a specific column header and repeat?
SolvedHello all, am new to using macros in excel. i have data and i want to be able to columns and paste it under some specific columns repeatedly. Examp...
Changing format of date in excel
Solved/ClosedHello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/...
Outlook 2010 configure for gmail
SolvedI have created an account and tried configuring through Outlook 2010. Though the test message is successful for sending and receiving, outlook is able...
