The discussions
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...
Data search and corellation
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
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!!!
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
SolvedI 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
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
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
SolvedHere 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
Hello, Please solve the question. How to convert a numeric value into eng. word Thanks & regards Rajesh Juneja
Capturing time through excel macro
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
ClosedHello, 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
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 ...
Trying to create a formula
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
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?
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
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
SolvedHello, 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
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...
