Office Software Forum
- Excel (9,843)
- Open Office (114)
- Outlook (647)
- PDF (334)
- PowerPoint (184)
- Word (2,189)
-
Formula to calculate monthly contract value between date Closed
Hi, Would appreciate helps here. I need to calculate monthly contract value based on contract start date and finish date. Contract value: 100,0...
-
request for a formula marks of my students Solved/Closed
Hello, sir, I am a teacher. I entered marks of my students in a column in excel-2007 work sheet. I have to prepare grades from the marks. Marks from ...
-
I cant open my exel .slxs files Solved/Closed
Hello, am not able to open my exel files(office 2007) which are in .slxs formet. when am trying to open that file windows is showing this message: ...
-
Enter Start time and End Time Closed
Hi! I'm trying to make a tracker using excel wherein we can calculate the minutes used in each task that we make. I am planning to have the start time...
-
VBA code for document controll & progress monitoring Closed
Hi... Good day! I am a project control engineer dealing with almost 1500 documents/drawings from my engineering sub contractor. Each documen...
-
Enter Time by clicking on a cell Solved/Closed
Hello, I need help setting a code in Excel. I am new to VBA but have used Excel for awhile. I would like to set Columns D & E up for time. I want...
-
convert excel into pdf Closed
Hi, i want to convert my one excel file into pdf please help
-
conditional formatting with an exception Closed
Hello, Im trying to conditionally format the results in I19:I44 for all duplicates although I want the first one to be an exception. How do I sp...
-
Freezing Panes Closed
Hello friends, I want to freeze more than one row (like 5, 8, 20, etc) and column (like E, K, O, etc) at random location at the same time in excel....
-
Attendance Sheet Closed
Hello friends, Please help me for following issue. I have created an attendance sheet in excel having 12 sheets (for all months like Jan, Feb, ...
-
A macro for a single column until end of data in the column Closed
I need to create a macro that created "Replacement Date" in Column AE and calculates the Replacement Date for the entire column and stops at the end o...
-
I want to customize the Save As dialogue box. Closed
Using Word 2010 (OS Windows 8 ) and when Saving documents, I used to be able to customize the folders in the Save As dialogue box. I think this was f...
-
Selecting dates Closed
I have a worksheet that list property sales from year 2000 to 2012. I'm trying to mark all property sales into different quarters that is all sales fr...
-
Data search and corellation Closed
Hello I have hundreds of pages of data that I am going through for Pie and Pareto analysis and I am trying to speed up the process by using formula...
-
Matching Closed
Working on a large data that I want to match, on one hand is payments by credit cards on the other from checking. The matching is to confirm no double...
-
Excel - Macro help please!!! Closed
Hello, I have a monthly report with multiple clients which varies month to month. I need to figure out how to create a New Work Book from my sorte...
-
Conditionally insert a duplicate row Solved/Closed
I have a table with hundreds of rows but here's a basic example: __a___b_____c____ 1 Color Dates Completed (headings) 2 red Date1 No 3 red Dat...
-
cell contains value from range return value from another column Closed
How can I compare two columns of data and return a value from another column? If the value from column A on Sheet 2 contains a value from Column A ...
-
Inserting rows chronologically while maintaining weekday formula Closed
Hello there, In a sheet named Projects, col C contains weekday dates and col B has numbers of days needed for projects (a project takes at least 1 ...
-
Macro Help Copy Specific Text from One cell into another Solved/Closed
Here is the scenario: I have a large excel spreadsheet and I have a column in which I only need the last ten characters of each line copied or move...
-
How to convert a numeric value into eng. word Closed
Hello, Please solve the question. How to convert a numeric value into eng. word Thanks & regards Rajesh Juneja
-
Capturing time through Excel Macro Closed
Hello, I am trying to capture the timings of my team for various activities like break, meeting, working hours, login & logout timings etc...I hav...
-
Excel - how do I create multiple spreadsheets from one Master Closed
Hello, I have a monthly report with multiple clients which varies month to month. I need to figure out how to create a New Work Book from my sorted...
-
find a column by criteria and display in another worksheet Closed
Hello, I have a worksheet with a several columns (example): PP DR MM SS 5 3 2 7 4 9 2 1 2 9 4 4 ...
-
So many dates Closed
Hello, I have a spreadsheet of about 15000 items. I need to do several things to the pivot table built off the spreadsheet. The things I need to...
-
trying to create a formula Closed
Hello, what I am trying to do is that I have a $ amount in g7;g41 + 20% of the dollar amount in i7;i41 to give total payout in k7;k41 Thanks
-
Enter data in a Workbook worksheet and Save it in a other Worksh Closed
Hi, I Created a excel file requisition and user input details requesting materials I need to have this data go to a other sheet with two section ...
-
Is there a way to make a default option for Autofilter? Closed
Hello, I have an excel sheet that I am trying to display 3 different tables on, but I want to make it so that I can filter the tables down to just ...
-
Macro to add # of rows based on data in the sheet Closed
I am trying to make a guest list that will insert rows automatically and fill in some data. I can get the primary data from one worksheet (i.e. com...
-
EXCEL - Create a bulleted list in a single cell from a list Solved/Closed
Hello, I'd greatly appreciate some help with this: I'm trying to get a list of data in cell "D5" only from cells "A1:A10" that do have informat...
-
Excel Spreadsheet date comparison Closed
Hello, I am trying to compare 2 columns of data to determine if one date is prior to or after another date. (Is date in column A on, before, or aft...
-
return selected characters in an excel cell Closed
I have a alphanumerical number like the following: C297320 I need to return the last 3 digits of this number in a separate cell. Thus, I need...
-
why i cant open my pdf files even though i'm having adobe reader Solved/Closed
hai. i'm having new version of adobe reader, when I try to open my pdf files by double clinking on it it opens in word. when I try to select'open-wit...
-
Have macro select range but exclude empty columns Closed
Hello, I have a worksheet in which a range gets copied and pasted into an email using a RangeToHTML function from Ron de Bruin's website: https:...
-
vba insert new cell to a dynamic range Closed
Hello, Hi, Could anyone plz help me to achieve what I need ? I want a code to insert and autofill a new cell to the range depending on what ...
-
Excel solution Closed
I have one Master Sheet, sheet1 in excel 2007 where I have entries of customer details from mixed cities Code ContactPerson Company Add1 ...
-
Insert Rows according cells value in excel table Closed
Dear All, I need a Module that allowed me when I run it to add Rows down according upper cells Value for Example; Total Names 2 Sami 5 Rami ...
-
If there is value in one column then a $ generates in another Closed
Hi there, I am trying to create an excel formular where in Column G I have a drop down menu with either Long Hire or Single Hire as the options. W...
-
Number to Words Closed
Dear Kioskes, Ex: 45,450.55, Forty five thousand four hundred and fifty & 55/100 only could please replay me
-
Adding 1 to an existing number if criteria is matched? Solved/Closed
In column A I have a set of initials and in column C I want a number that corresponds to the number of times the initials have appeared... Column ...
-
Find the sum of data that has multiple conditions in Excel Solved/Closed
Hello, I have a large data table, and I want to find the sum for certain data that fits a few criteria. Here is a simplified example: __a_____b__...
-
Formula Closed
Hi, I need to create a formula for a whole team. It is based on the number of people in the office for each calendar month. The spreadsheet I have ...
-
pdf to excel convertor Closed
Dear Sir, I want to install pdf to excel convertor to my PC! Help me pls!
-
Formula for change of dates daily for one month of working days Closed
Hello. I am looking for a formula to add one day to a column of working days in a month. I wish to start the first cell in the column to 1/07/2013 an...
-
VB Column Width and Sheet Name Closed
Hi, I am really new to VB, but I work a ton with Excel. I have a spreadsheet that I have to parse out into multiple spreadsheets for some reporting p...
-
Excel 2010; Need help w/If, Then formula Closed
I need a formula that if there are duplicate values in column A, then it will sum the values in column D for the rows with duplicate values in column ...
-
Autofilter range by selecting cell from a column in that range Closed
Hello, I have a 6 column overview with Description rule sets for Titles and Subtitles of Product groups. Each set consists of two rows: The desc...
-
Unable to open word file Closed
Hello, I recover my some deleted ms word 2007 file but it unable to open. it show the file is corrupted . i tried some method and softare but cant...
-
Transfering data from one sheet to another, but not duplicating. Closed
Good day all. Checking to see if anyone could help out, as iam very new to the excel world. I have a sheet that I am transferring data to another s...
-
file convert procedure from pdf to jpg Closed
dear sir, please give step wise procedure for converting pdf file to jpg file by return email at the earliest thanks & Regards Surekha Surve