Office Software Forum
- Excel (9,733)
- Open Office (113)
- Outlook (635)
- PDF (334)
- PowerPoint (174)
- Word (2,183)
-
VBA create Listbox and populate with Hyperlinks [Closed]
Hello all, I am working on a project to create a data pull from the internet to obtain a news feed for a given stock. I currently ran into a proble...
-
i need help with excel formula [Closed]
Hello, I have a database of people requesting their points to be transferred from one account to another, frequency of transfers is a combination ...
-
date format [Closed]
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 [Closed]
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 [Closed]
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 [Solved/Closed]
Hello, i m making a sheet with this function =IF(H1
-
Macro to transfer data from one sheet to another [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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...
-
Need Macro for Generate report table based on some critera [Closed]
Hi, I have a Table with 10 columns and 21 Rows. Last column has %allocation that is 'I' Cell of each Row divided by 8.75 and multiplied by 100. Exa...
-
Pls suggest for Excel [Closed]
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 [Solved/Closed]
Dear 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...
-
how to compare two coloumns in excel [Solved/Closed]
Hello,
-
HELP!! Excel 3 year reminder [Closed]
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 [Closed]
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 [Closed]
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...
-
Linking Word 2007 with Powerpoint 2007 [Closed]
I have word document that link to Powerpoint presentation. when I click the link from Powerpoint back to Word it always take me to page one of the doc...
-
Please tell me how to change the language used in comments [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Solved/Closed]
good 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 [Closed]
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 [Closed]
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 [Solved/Closed]
I 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 [Closed]
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 [Closed]
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...
-
highlight dates with conditional formating [Closed]
CELL A1= 01-JAN-2013, A2= 02-JAN-2013, A3= 05-JAN-2013, A4= 07-JAN-2013, A5= 09-JAN-2013, A6= 10-JAN-2013 Here a1 and a2 has difference of 1 day so...
-
Exporting selected cells to another workbook selected cells [Closed]
Hello, I am a College Student and in my down time I've been messing around with vba coding. I am thinking about making a macro that will automatica...
-
Adding columns containing text [Closed]
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 [Closed]
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 [Closed]
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...
-
VBA code to update master excel sheet from source excel sheet [Closed]
Please help me with a vba code to update redhighlighted cells in master file for all documents from source file please find links for the files ...
-
Excel, Automatically transfering data and filtering [Closed]
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 [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....
