The discussions
Excel referencing
Hi Experts, I am having the following columns in the excel AA BB CC REQ_3.1_1 REQ_4.1.1_2 ...
Macro to create email, and pick which email account to send from
SolvedI already have this set up how I want... Sub MakeMsg() Dim msg As Outlook.MailItem Today = Format(Now(), "mm-dd-yy") Set msg = Application.CreateIt...
Convert number to words in excel
----------------------------------------------------------------------------------- there is some problem while we convert number to words ............
Macro to copy the same values between 2 sheets to a new one
Hello all, I'm not very familiar with macros in Excel and I hope to find a solution. I need a macro that works with 5 sheets (sheet1,2,3,4 and 5)...
Word and excell didn't opened
Could you please to tell me, "how to repair my Word and My Excell File"? I always wait your answers as soon as pisible. Thank you very much.
Run time error 424
Hello, I'm new to VBA. I've tried everything I can think of to avoid receiving run time error 424 when I try to run the following. Any help is much ...
If sheet 1 column 4 says hol then it fills in columns a1,b1 and
Hello, I have 2 sheets in excel 1st sheet has: 1st column has employee Team A1 2nd column has employee number B1 3rd Column has Employee name C1...
Excel- how to sum specific data
Hello, how can I sum only specific cells together? Column A - Regions Marche Puglia Lombardia Emilia-Romagna Lombardia Puglia Trentino-...
Nested if function with minute and time function
hey guys. so i have this problem which is to write a formula to calculate the cost of minutes used in a computer shop. here are the conditions: ...
Calculate date and format without showing both number and date
Hello, I am trying to enter a line item in an invoice that states the Week ending date like this "HOURS WE" then states the date on the invoice (F2 w...
Outlook.pst not found
Hello Friends, Following file deleted accidently... C:\Users\AppData\Local\Microsoft\Outlook\Outlook.pst I am unable to open Microsoft Outl...
Ms office and student 2013
Dear Sir I had purchased 5 keeys by paying the amount thru credit card and not able to download the software. Is there any one who can advise on...
Find highest value and state its cell name
SolvedHello, I have the following issue: in A and B: Marche 160,994 Puglia 463,251 Lombardia 405,626 Emilia- 542,009 Lombardia 451,468 ...
Copy the data in filter
Hi, I want to know that how can we copy the certain data in filter? Help me someone Please..........
How to extract date in a string
Dear Friends, I need your help in extracting data in a string. Example : Student name , Class, section, DOB, Address, email ID. Sachin...
How to free use quick office in nokia n97 mini.
Hi, This is to inform you that, I unable to use Quick Office massage showing purchase. So pls solved with free. Regards, Deepak Mishra
Excel vlookup ... problem
Hi,i have 3 columns(Ticket Number, Site ID and Date), i need to copy Site ID and Time according to the Ticket Number from 1st Excel sheet to 2nd exc...
Changing the day in date by default
Hi, I want to know that how can we change the day in date default by dragging down? Best Regards, Drakshayini
How to register after intalling the excel to pdf converter
How to register after intalling the excel to pdf converter
Moving data from column to row
Hi All, Please help me with the macro code for pasting the column data(which is shown below) to row. Data is have like this A Cell B Cel...
Search for a string and if found, select that row?
SolvedI know this is a very simple question but I can't find the answer I need. I am using Excel 2007 but I can get to a computer with Excel 2010 if necessa...
Re: financial modelling
Will appreciate any advise on the best approach to doing financial models for established companies and start-ups trying to raise venture capital fund...
Ms xl formulah
how to show conditional result in another cell in ms xl? for example, if A2 is >5% then the result would be 20 in B2
How to add times in hour and minutes format
SolvedHello In the first column I have start time, in the second finish time and the third column the time elapsed ie A minus B = C But if I add colum...
I want to find the student grade
I want to find the student Grade My formual is : =IF(OR(C12
Copying text from sheet 1 to sheet 2 in same workbook
Hello, Greetings everyone, I am a new user here. I wondered if anyone could please help me with copying text data from sheet 1 of a workbook to...
Reinstallation of office 2013
My hard disk crashed and all programs were lost. Disc now replaced under warranty and most programs successfully reinstalled but I am unable to reinst...
Install office 2010 and 2013
Hello world, I want to install office 2010 and 2013 on my laptop. How do i it without conflict or upgrading. Thanks...waiting for reply
~$ file problem
Guys, when every i open a Microsoft office file or foxit pdf files exact another file is automatically created with ~$ infront of it. Eg- i have a f...
Geob22
Can I update ms office home and student 2010 and get the format tab. For removing the background in a picture. If not can I buy the format soft...
Office 2014 software for downloads
I need some help to give me the link in other to download office 2014
Getting multiple values out of one cell
I trying to copy into another cell data from 1 cell that has multiple values that are seperated by blanks. Example a1 has 123 456 789. I used the ...
Publisher product key
where is the product key on the trial microsoft publisher
Extracting name from column
I would just like to extract the name from a column: 224. Can someone help me do that?
Conditional format based on cell containing function
Hello, In column J3:J32 i have functions that determinates grades (=IF(I3>=90;"10";IF(I3>=80;"9";IF(I3>=70;"8";IF(I3>=60;"7";IF(I3>=50;"6";"5"))))))...
Changing date format in excel
I have imported dates in an excel spreadsheet from WinQs.sql and opened the file in excel. the date format is 07/11/2009 but I want to change the dat...
Macro
Greetings, I use peachtree accounting software and we have no option to export reports in excel. can i record macro to pull data from application? ...
Formula:if e18 = 1, 2, 3, 4 or 5 then end result = g18, g19 etc.
SolvedTrying to create a formula where I have a merged cell (E18) that if 1, 2, 3, 4 or 5 is entered I want the end result to equal the contents of G18, G19...
Conditional formatting with values
Need some spreadsheet help. I need the value ($'s) in Cell A to become RED if Cell B is greater than Cell C. Make sense? So... If my actuals are...
Store the values in next sheet
Dear All, I have doubt in xl sheet, I have two xl sheet , i show the first sheet parameter as below, CABLE NO -1 LOAD -18.5 VOLTAGE -415 CURRENT...
How do i add text to a drop down list
SolvedGood day how do i add text to a drop down list i created in excel Configuration: Windows XP / Chrome 24.0.1312.57
Generate payslip
Hi, can any one help me to generate payslip? I have a master sheet with all the details including (basic, da, OT and other things). I do have t...
Partial match issue
Hello, I was searching for a formula for the partial match of the cells (for companies;for let's say 20 characters) and highligt them for 2 column...
Excel help
SolvedI am tracking shipments of our product. When I enter the amount that shipped, I would like for that days date to appear in a separate cell and never c...
Vb, how to copy values & repeat to next 50 cells
Hello, Need help writing code @ step C & D I am: A) copying values in E1-E4 & transposing values B) to Col. A next available empty row (obviousl...
Office is taking hours to restore
I had to do a reinstall on my husbands computer and went throught the whole process without a problem until Microsoft Office began reinstalling - that...
Lost product key
Hello, I have misplaced the product key of my purchase of Office 2010 which is installed on this Laptop / device. How do I recover the Activation...
Conditional formatting help
SolvedHi, I have a spreadsheet with a column for employee hours. Anything over 9 hours is considered overtime and we are tracking how many employees are ...
Macro hyperlinks
hello i already have this code in my macro that works fine s ub New_Personal_Profile() Dim MyCell As Range, MyRange As Range Set ...
Clearing a single cell without deleting the contained formula
Hello, this is my very first try at using a formula for help (so please be patient with me if I make a mistake:) I have a growing knowledge of Excel ...
