Office Software Forum
- Excel (9,843)
- Open Office (114)
- Outlook (647)
- PDF (334)
- PowerPoint (184)
- Word (2,189)
-
Lost product key Closed
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 Solved/Closed
Hi, 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 Closed
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 Closed
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 ...
-
presenting data from one worksheet to another by dropdown menu Closed
HI All, I have a worksheet with two colums of data. On another sheet I plan to present the data in an easier to read format. What I want to do i...
-
map column names to their short names Closed
hi all, i am trying to copy and paste columns like application id,application name,number in a worksheet in workbook1 to another worksheet in workboo...
-
Conditional formatting with "contain". Solved/Closed
Hello...I am using Excel 2007. I can't get beyond the following: =ISNUMBER(SEARCH("campaign",A2))=TRUE This is what I'm trying to do...If cell A2...
-
Look to find a formul that will make an item rec Closed
Hello I am looking to track items received... I would like to build a box were we enter the NSN and the amount of the items... Date auto populate. ...
-
MS Excel Number format error Solved/Closed
Hello, I use Ms Execl in that I have a error it like this..... 1. when I type a number 400 in the cell an give Enter. It is not showing the exa...
-
Date format problem (5.8.14) Solved/Closed
Hi. I'm using excel 2013 on Win7 Ultimate SP1. My problem is that I often type the dates with the help of decimals/periods. But I've learned thru goog...
-
Create new sheet and copy data from input page to the new page Closed
Hello Every One, I am a basic excel user. I am trying to create an excel data base that will keep a record of employee duty hours, dates and types...
-
add "x" based on "Y" lines and copy Closed
Help! I have a spread sheet that is over 8,000 lines and I need to insert and copy lines based on a value in "y". Also then add a blank line under the...
-
I am a computer opertor but i still need Excel! Closed
Hello, need your help please!!! Configuration: / Opera 9.80
-
ages and difference between them in years:months Closed
Hi, I would like to enter data in the form 12:06 meaning 12 years and 6 months and then work out the difference between two such cells with the an...
-
Insert Data from one sheet to another Closed
Hi Guys am new to Macro and looking for some help. i was trying to create a sheet to be entry data and the data to be saved in another tab without ...
-
pc Closed
how i can compress my pic . and how i can see my pc hidden file ,
-
Excel Date Format Solved/Closed
Hello, when users enter a date in excel using this format 12.1.2008, I need the cell to automatically change the format to 12-Jan-08 thanks, mo...
-
i wanna download word Closed
I have recently formatted and loaded window 7 home basic through the original cd available with my dell i 5 since then ppt and word is not there. henc...
-
losing the plot with vba Closed
hello and huge thanks in advance, the following is a macro i have adapted to try and get a centralised team sheet auto sort and copy the relevant ...
-
conditional Formatting date issues Closed
Hello, Please help Conditional formatting will not work on columns displaying dd/mm/yyyy hh:mm:ss, (formatting highlights colour if todays date.) ...
-
Conditional Formatting Closed
Hi, I use excel to plot my production planning and would like to format so the ship date cell turns red once the ready date is greater then the shi...
-
Trying to aggregate data by different date across worksheets Closed
Hi, I am attempting to consolidate data across different worksheets in a workbook, that having different dates. For example, worksheet "Cert1" has...
-
how to delete 19 row after the cell which has certain value Closed
i have done a code to delete the row which has "Trip" in any cell in this row as below Sub DeleteRows() Dim c As Range Dim SrchRng ...
-
if condition to calculate incentives slabs Closed
IF(E162>=50,IF(F162>=50000,IF(F162=75,IF(F162>=75000,IF(F162
-
copy data from sheet1 to sheet2 Closed
Hello, I want to copy data from sheet 1 to sheet 2. I have data in 4 columns and 100 row in sheet1. I want to copy each row of sheet 1 in sheet 2 ...
-
Formula To ADD values from different columns Closed
Hi I am new to excel and need help in adding values in my sheet. the contents are as follows: NAME -------- TAG ---- ...
-
Help with Time, and Alert Formula Closed
Hey all.. New to the forum, so please be gentle.. hehe I working in a busy office/communications orientated job, and I am wanting some help with ...
-
How to transfer data from all the sheets and pasting it in Closed
Hi All, I need one help, I am having excel workbook, I need to copy the data which is there in each sheet and i need to paste that in a master work...
-
link information in entered in worksheet 1 to another worksheet Closed
Hi All, I am really hoping someone to help me with this. I have an Excel workbook The first workbook is the form we fill out for new employees Th...
-
how to import/copy contents from one cell with many rows Closed
please help me on how to import/copy contents from one cell with many rows to another sheet.
-
i can't open my PDF attachment in my eamil Solved/Closed
Hello, plz help me,i tried to open PDF attachment in my eamil but I could'nt .Configuration: Windows XP Internet Explorer 6.0
-
Last ID # Entered Closed
I have a very long list of ID #'s that all start with the either BIL_ADMIN_ and then the number or with BIL_RECEIPT_ and then the number. Is there a ...
-
Column totals using macro Closed
need help , how do I add sum totals at the bottom of columns of varying lengths using macros. eg I have data in columns a to f, I want columns c to f ...
-
A Macros to Pull Data from an automated Excel Sheet Closed
Hello, I have a running spreadsheet where the data is automatically updated. On a separate sheet I am trying to pull information off the main sprea...
-
Help with text & number rule! Solved/Closed
I wonder if anyone would know how to create the following rule in Excel: IF I enter a specific "text" in cell A, then Excel would insert a correspo...
-
Auto populating entire list based on DDL Closed
Hi everyone! I've stumped myself once again in Excel and am desperate for help. I'm attempting to auto populate an entire list based on a drop dow...
-
Applying my macro to a range of cells... Solved/Closed
I found this macro and it works perfectly....inserts an "x" on a single mouse click into cells, but I only want it active on a certain range of cells....
-
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...