The discussions
Copying simple form data into new databse
Hello, I'd like to create a simple form that I can then copy into a spreadsheet and will update another workbook for data. My form is very straight...
Compare and return the oldest date
I have a shared workbook comprised of a full report sheet and sheets for individual employees that is being used as a weekly report. Employees enter ...
Excel if help
Hello, I am looking for a function I think an IF statement for some accounts. I want to say IF ( The value in column B="Tom") THEN (Add the v...
Comparision of excel sheets
I just want to ask for your help by providing me codes / references to compare the data in two worksheet, which it means to compare the data in sheet ...
Changing cell color dependent on date in a different cell
Please help. I created an spreadsheet in Excel 2010 for new hires form tracking. I now would like to have cells change colors to remind me that certai...
Code to move a row based on fix values and paste it
SolvedHello Gurus, This is my 1st question and I m a beginner in macros .I wanted a code to move a row based on a fix values and paste it in the same shee...
Forgot password to one of my data bases (ms access 2007)
does anyone know of a free password recovery tool?
Simple macro
SolvedI am trying to create a Macro to filling in a series of columns starting with the current cell. simply if cell A1 is selected and you hit the ...
Fill amount from a cell if date is before end of month
SolvedCan someone please help. I'm trying to track outstanding bills due by the end of month as in the following example: If date in cell B5 (due date) i...
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
