The discussions
Conditional formating
SolvedI have a spreadsheet with Excel 2013 that has text drop down lists. I want to use conditional formatting to highlight with a different cell color, dep...
I need to run multiple automatic macros in one sheet
I am developing a worksheet where there are multiple occasions down a list where users will have to select an option from a drop-down box (Y, N & N/A)...
Convert a date field in excel to day of week
Solved/ClosedHello, I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the week so...
Date format
in MS-Excel, When i am sorting the dates in a column of format dd/mm/yyyy, say example 10/06/2007 and 02/10/2007, the sorted column shows 02/10/2007 i...
Conditional formatting of cells with dropdownlist
In column C of my spreadsheet i have created a drop down of a set of 96 locations in US. When i select a certain location from the drop down , i want ...
Comparing columns and returning value
i've following: 1. Drop down values from 1 to 5 in column A. 2. Drop down values from A to E in column B. Ive following matrix (A44:C68): 1 ...
Some help needed about if function with dates
SolvedHello, i m making a sheet with this function =IF(H1
Macro to transfer data from one sheet to another
Hello, I would like to know whether this is possible using macros in excel Sheet 1 Column A Column B Column C Column D Column E C...
Deleting a row
I have an Excel file with rows from 2 to 988. There are two columns B titled Customer and C titled Main Email. I need a macro that will search column ...
Transferring selected rows to another location on anothersheet
I Am trying to Move a selected range of cells to another sheet. As an example "sheet1" Columns C,D,E,F,G,has a data list entered and when i enter th...
Odd situation in excel
Hello, I'm designing a spreadsheet for my work in terms of I've got a set of numbers from 0-99, the evens are one week events and the odds are ano...
Substracting time from date & time to determine the date & time
I have a 'simple' spreadsheet with five columns (warehouse #; part #; departure date & time; transit time and arrival date & time). I have packages...
Help with macros in excel
Hello, I was wondering if anyone could help me in creating a macro file for excel....I am needing to save, print, and close an excel file at a cer...
Pls suggest for excel
Dear all, Pls suggest for my following issue related to Microsoft Excel. I created a Report in Excel having many sheets. In all sheets, Subsc...
Creating pdf from selected cell range
SolvedDear all, greetings. firstly , I would like to thank those who have helped me to get below code (to create pdf file for selected cell range) whic...
Help!! excel 3 year reminder
I have a formula: =TODAY()-$B2>3, this will remind me 3 days before a due date, but I need it to tell me to review after 3 YEARS of the dates I have i...
Please help- conditional formatting
Hello, I want help to solve below described question for excel 2007. CELL A1= 01-JAN-2013, A2= 02-JAN-2013, A3= 05-JAN-2013, A4= 07-JAN-2013, A5...
Sharepoint/excel
Hello, I am trying to create an If function where the Date field must = 2013. I have that =YEAR([column 1])=2013 But when the field is null i...
Please tell me how to change the language used in comments
Hello, Hello, I'm editing a Word document 2007 for which the language is US English but, for some reason, when I try to add a comment, the langu...
Formatting excel
Hello, i got a problem regarding excel formatting. Excel displays every figure higher then 1.0 as a date and anything lower than that as the ac...
I lost data
Hello, i had a file with some data and one of my kids entered this file and changed evrthing and saved the data. and i need the old data. how can ...
Macro to insert a row after 6 rows and 45 rows
Hi all, I'm new here and hope you guys can give me some advice and help to end my problem! I have a large data set containing "control values" a...
Macro insert headers after sorting
Hi All, I have a spreadsheet that would contain a hundreds of thousands of invoices. But to simplify, I am more concerned about the following: H...
Update data records
I have a specific range of cells in a column. For eg In sheet1 from D3 to D12 I keep on entering various alpha numberic code from 3 digit to 8 di...
Copy row paste at the top of each page
I need to copy a row, then paste it on the top row of multiple pages.
Validation warning for repeating a number in a column
Hello, I am using a spreadsheet that compares properties, within different grid squares. The column for grid references has numbers prefixed with t...
Microsoft office
Solvedgood day ! i would like to ask if how can i activate my microsoft office even though i dont have any activation code.. thank you God bless
Excel : if value is in column a, then delete cell in column b
Hello, This is what I want to do : Column A : value1 value2 value3 value4 value5 Column B : value1 value22 value33 value44 valu...
Conditional formatting - based on a formula and named cells
Hello, I have been struggling to get a simple formula to work in Excel 2013. My objective is to compare budget numbers to actual and if we are wit...
Trying to write a code to insert a blank row above a cell value
SolvedI am trying to write a code that will auto insert a blank row above a certain cell value ie: existing: Column G 5 10 20 22 999 2 22 55...
Windows 7 os
Hello, when i am trying to open ms out look in my windows 7 laptop, it is saying" A required installation file SKU011.CAB could not be found. why? ...
Macro for deleting a row with specific criteria in a cell
Hello, I've got a spreadsheet with many rows and columns, and I'd like to delete specific rows based on criteria I pick. For example, if my criteri...
Adding columns containing text
I have a basic sheet and cell a4 is a total of jobs done. I want to add +1 to cell a4 every time I enter any text in b6:b1000 to tally work completed...
Excel reminder
Hello...I need to create a reminder for dates in B2 that is 3 years after the date in B2. To have B3 highlight with REVIEW would be great. I have a fo...
Command button to post data from one sheet to another one
Hello, I would be very grateful if some one van help me! I have excel table with 10 columns (from A-J) in sheet1. I fill data in the table and in...
Excel, automatically transfering data and filtering
How do I transfer a document into another document automatically by filtering specific numbers or words out?
Formula to calculate monthly contract value between date
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
SolvedHello, 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
SolvedHello, 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
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
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
SolvedHello, 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
Hi, i want to convert my one excel file into pdf please help
Conditional formatting with an exception
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
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
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
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.
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
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...