Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Conditional Fomatting Closed
I am trying to add conditional formatting to a spreadsheet. It is an employee list showing drivers lic and med cards expiration dates. I want to forma...
-
Macro for creating text file and copy paste date Closed
Hello experts, I need an another macro, a keypad shortcut triggered macro (Ctrl+j), which will copy ranges "A10:A45", create a new text file on the...
-
Help with comparing column data Closed
Here is my situation, I have a DB with a column of customer #'s that I want to tie to a status column. Each customer # can have anywhere from 1 - 12 ...
-
paste 10 or more worksheets data in a single worksheet Closed
I want paste 10 or more worksheets data in a single worksheet by using formula, is it possible?? Thanks in advance Mahfuz
-
Creating workbook and copying data Closed
Hello, I have a work book in which the sheet - "Master list". Column D contains the master list of clients. 2nd sheet "Template" contains the maste...
-
Doubts on Sum Mulitple Sheets Closed
Hi All, I have different kind of workbooks having records from A6to BB6 in this we can enter the details on daily basis sales . One more Master...
-
How to use formula for transfering data from Sheet 1 to Sheet 2? Closed
Date & Time JOB NO PENDING 12/23/13 2:14 PM SICD-B00xxx * My question is, there are three cells named- Date & ...
-
Macro for copying cells with format from last sheet to new sheet Closed
Hello, My project requires to maintain a database for all customers. I have already obtained an event macro from experts from this forum, which, I...
-
Excel formula Closed
I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria If 0...
-
Macro for creating a new excel sheet based on certain conditions Closed
Dear Experts, Greetings. My sincere thanks for the support you providing thorugh this forum. Now stuck with some requirements in the microsoft exce...
-
time calculation formula Closed
Hello, what is the formula to calculate time between two different dates and times Thanks
-
date function Solved/Closed
i want to know how to create a date series in an excel.. for eg if i enter the date in A1 as 1.12.2013 how to create automatically in the A2 as 2.12...
-
list dependant drop down menu Closed
Hello everyone, I have a worksheet with two columns (A and B) of data. I'm trying to populate a second worksheet (column A) using a drop down box t...
-
Applying conditional formatting to multiple cells Closed
Hi all, I've actualy already done what I needed to do, but as this is a very sensitive document I would like to know WHY it worked, just to be sure...
-
Formula to highlight cell based on data value over 2 cells Closed
Hi Guys and Girls, I'm am trying to improve a current spreadsheet I'm using where I am collating movement times in and out of a location. I want...
-
Conditional formatting to colour cell based on text in another Closed
Hi, I have a workbook tracking submission of work ideas. In column C I have the date received. In column J I have status (approved, rejected, pendi...
-
Excel Closed
Hello, Function SpellNumber(amt As Variant) As Variant Dim FIGURE As Variant Dim LENFIG As Integer Dim i As Integer Dim WORDs(19) As String ...
-
Conditioning Formatting Closed
HI All, we have mandatory annual training requirements and I have a spreadsheet which records the date training has been completed. we have seve...
-
Formula Closed
i
-
Remove duplicates and merge rows Closed
A B C D E 2000 Mary 123 street1,street2 2000 James 123 street2 2000 Mary 123 street1 2.8...
-
Date formula Closed
HI I want to set the formula for excel for when I insert date in cell ex. 1dec2013 then I will select any empty cell date change in to 31dec2013
-
If command across multiple cells Closed
Hi Guys, I can successfully use if command with text on a single cell, however I want the true or false outcome to be based on multiple cells. T...
-
corrupted office file Solved/Closed
i have a problem that i lost my all data from my computer. then i apply recovery software to get this data , although i recover my data but after reco...
-
Writing a macro that copies data from multiple worksheets to one Closed
I have a workbook that has over 580 different worksheets, and I need to copy a certain section from each worksheet onto a "master" worksheet. The data...
-
Find and Extract text from a cell content Closed
I need to search a cell for content and extract and display a portion of the cells content. How do I do this? Here are more specifics. lets say...
-
Nested If logic is not working Closed
Please tell me what's wrong in below formula: =IF((AND((HLOOKUP(A1,$A$1:$F$2,2,0)="Yes"),(HLOOKUP(G1,G1:L2,2,0)="Green"))),"Compliant",IF((AND(AND((H...
-
Date Function using if_ else statement Closed
My requirement is while writing a function using if statement : In a range of cells in say: P10: P20, containing dates, I want to writ...
-
Require Formula Closed
I want to type only 1 in excel cell but require to come 100 and the same that 2 for 200, 3 for 300, 10for 1000, 50 for 5000, 100 for 10000 and so on. ...
-
ahtisham Closed
12 3456Hello, Configuration: Windows 7 / Chrome 31.0.1650.63
-
VBA for Conditional print Closed
Hi all, I have a word file which includes some check boxes. I need a VBA code that forbid the user to print the active document if he didn't checked...
-
How can I add blank line to the record using macro Closed
Hi There, I am having difficulties with macro, I would like to have macro which checks the records in each row and if they do not match than it add...
-
Cannot Receive or send yahoo mail in Outlook 7 Closed
From yesterday onward I can not send or receive Yahoo mail in my Outlook 7. Since i thought that it is due to the trouble with my ISP I tried 3 diffe...
-
Returning Text from Excel Closed
I have customer names located in Column B Rows 12-56; I have dates that they returned letters to me in column J rows 12-56. My question is what is...
-
Unique records Solved/Closed
Hello, I am very new to excel macros, however, I want to make a macro that will provide unique records from three different excel sheets. I have...
-
convert the date format into general format Solved/Closed
Hello, In excel 2003, how do I convert the date (3/21/2012) from date format into general format and still keep it show as 3/21/2012 instead of 40...
-
how to auto copy/past info from one cell . Closed
Hi , I am trying to create a sheet that when i press a name it will ask me to where i want to copy it in a different sheet. For example If i pre...
-
Transfer data between sheets in excel Closed
I currently have a sheet that sorts my data by customer, such as Part#, Qty ordered, Qty Shipped, Due date and so on. I would like to be able to trans...
-
Script :Scan Excel Sheet for Validity Date & Send Reminder Mails Closed
Hello, I have a training manager in Excel that has different training records of about 100 employees. Each training has a certain validity. The re...
-
Excel IF argument Closed
Dear All, I'm trying to use IF argument in a excel document for a calculation. But it is not working. I'm using more than 8 IF argument. My excel i...
-
How to move data to different sheets Closed
I need to enter data into several different sheets and then would like some of the data to transfer automatic to a log sheet so I can then sort it. C...
-
moving data from rows into columns for every Solved/Closed
Hello, I have data in a single column and would like to transpose it into a row for every three rows with a space delimiter, for example; The colum...
-
Transfer data from one workbook to another. Closed
Hello, I am having a problem with the getting the form to transfer data. The post previously placed on this forum is not resolved. Please help me ...
-
Excel VBA Closed
Hi, I have a VBA data entry user form where in 200 people will be updating it and updating different excel sheets and will be saving it. All the d...
-
Ms office 13 Closed
Hi guys, A source to download Ms office 2013 with activation key please? Thanks in advance
-
copy rows with date as criteria Closed
Hi i have a workbook with 3 sheets. sheet 2 has data that changes constantly and column A has the date entered when the change was made. sheet 3 ne...
-
Macro to sort worksheets by a value in a cell, least to greatest Closed
I need a macro to sort my worksheets by the value in their cell "J65", least to greatest. The formula in cell "J65" is: =Sum(J35-H62). It is a USD...
-
how to check replicated data Closed
Hello, I have a set of data ranging from column A to AW. They are shown in several sheets and there are 289 items in each sheet. Since the data wa...
-
Change Cell Data by Format Conditioning Closed
I need to how to used format conditioning to change a cell's data Example If Cell A1 = "F", then A3 background is Green (this is normal Format Con...
-
Combine Multiple Rows into One Row Closed
Hello, I am in need of major help with a large spreadsheet that have over 500 rows. I need to take multiple rows and combine them into one row. ...
-
resume writing Closed
how a resume can be written .
