Office Software Forum
- Excel (9,851)
- Open Office (117)
- Outlook (652)
- PDF (334)
- PowerPoint (185)
- Word (2,189)
-
Compare Common names Closed
Hello, I have a excel sheet in which I want to highlight any time there is a common name between the two columns. the problem is naming is differe...
-
how to convert number in word in excel Closed
how to convert number in word in Excel
-
excel formula Closed
Hello, I'm looking for a simple formula to convert numbers in to words in Excel 2007. with example. Configuration: Windows 7 / Internet Explo...
-
Sheet One Items Transferred to Sheet Two. Closed
I have few items in sheet one and want to transfer to sheet two. Please help me.. Sheet 1 consist of:- S.no Tanker Date Voucher ...
-
scroll lock Closed
Hello, Don't have a scroll lock key and no F14 key. I unlocked scroll on Excel Sheet and arrows are still scrolling and do not navigate side to s...
-
Ops Mgr Closed
im trying have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to automatically up...
-
Copying Data from One Excel Workbook To Another Closed
Hello, Newbie here, on my organization my reportees are sending me a report on a daily basis, the pain is to collate each of these sheets onto 1...
-
I cannot edit or delete the progress bar? Closed
Hello, I follow the link https://ccm.net/faq/937-insert-progress-bar-into-powerpoint-presentation to insert a progress bar in my presentation. I...
-
requesting Formula in excel on if condition / date function Closed
Hello, I need the Formula in Excel sheet If A2 is having a date. I need the date on C2 After 2 days. If the second day is Saturday it should b...
-
compare data in two different excel files Closed
Hi, How to write a macro to compare data in one excel file with data in other excel file i.e., cell wise for ex: I have one file with two columns...
-
Drop down list treated as a selection variable Closed
Hello, I am trying to see if this is possible and if so how: Problem: Make the same "selection variable" ,i.e. word or number chosen from the dro...
-
Microsoft office professional 2003 Closed
Trying to load Microsoft office professional 2003. Can not find file ys561401.cab.
-
Excel Date Function dd/mm/yyyy Closed
I have a column in excel as dd/mm/yyyy with my date function set as English (US) however excel is sometimes picking up some dates as mm/dd/yyyy and ot...
-
I can receive emails but can't send emails out.... Closed
Hello, I have the same issue. I can receive emails but can't send emails out.... I use Charter as my internet provider and use Outlook 2010. ...
-
Excel 2011 not recognizing keyboard shortcuts? Closed
Hello, I have been given an assignment which gives me quite specific instruction on Excel however while things like command+C works the more complic...
-
For AND condition Closed
Hello, ANd condition on two different columns - what is the solution please Configuration: Windows 7 / Chrome 41.0.2272.76
-
Copy data to new sheet.. more tricky than I imagined Closed
Hi all, Could someone please help me out with this? I've tried looking at other similar questions and solutions but as an Excel beginner I couldn'...
-
Compare on a condition and Highlight the Difference Closed
Hello, I have a requirement to compare two different tabs on same sheet and display the difference either by highlighting the rows or add a comment....
-
I want to label specific cells with numbers in a sequence Closed
Hello, I am new to VB and trying to write a script that has the below functionality, could anyone help me get started or point me in the right dir...
-
Excel formula Closed
Hello, I want the answer of this formula =IF(AND(L13
-
adding a loop to macro to insert pictures Solved/Closed
Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...
-
I want to label specific cells with numbers in a sequence Closed
Hello, I am trying to write a script that has the below functionality: - From top of sheet, check cells with a value in a specific row - Replac...
-
Color Coding variable Pivot Row Label Interior Closed
Hello All I have a coding problem I have tried numerous ways to solve with no success. I have a macro generating a pivot table for weekly data tha...
-
Problem with adding and updating comments from value in VBA Closed
Hello and Greetings, Thank you for taking the time to read my post; I do appreciate it. I have been struggling with a trying to write a specific VB...
-
Entering a range of data in an IF formula Closed
Hello, I am trying to write a formula where: if any of the values in colum B are equal to the values in column M, then an email address in N1 will po...
-
using if condition in excel sheet. Closed
Hello, I need the Formula in Excel sheet If A2 is having a date. I need the date on C2 After 2 days. If the second day is Saturday it should b...
-
excel assistance Closed
Hello, Can i PLEASE get some help with this problem? 5KM or more and less than 15km, the cost will be 5... Thanks to everyone in advance
-
transfer 5000 records to a new spreadsheets with 50 records in e Closed
I have a excel file which contains 5000 recores, i want to transfer 5000 records to a new spreadsheets with 50 records in each new spreadsheets i.e to...
-
Help in Duplicating Row Info based on adjoining Cell Response Closed
Hello, I am seeking assistance in determining the best way to complete a worksheet wherein I need to create a new row which duplicates some inform...
-
A Macro to repopulate a row into a new row based on the response Closed
Hello, I would like a macro that would repopulate a new row based on the results of a cell within that row. Example: Project A Complete...
-
How to export data from different tabs in Excel Closed
Hi, I need help with a spreadsheet that has 4 tabs. My tabs are: Manager, Analyst_1, Analyst_2 and Analyst_3. I need a formula that can t...
-
VBA code to update excel comments when the cell value changes Closed
I have a workbook with several worksheet tabs. One of the worksheet tab contains a column of percentages (that are composed of a VLookup formula from ...
-
Change calculated to a hard date Solved/Closed
I used a +1 formula to create dates in column A. Now I want to make these "hard" dates so they don't keep changing every time I add a row. Thank you...
-
VBA : Copy "Pivot like layout" to "data dump layout" data Closed
Hello, I am looking for a solution to my challenge. I have a spreadsheet that looks like this. Name - Column Name 1 - Column Name 2 Column...
-
Create a search box and then copy to new worksheet. Please help Closed
Hello, this is what I have so far by searching online and it is not working :( It keeps sending me a message " Variable not defined " Please help me ...
-
Macro creation Closed
I need to combine data in two different Excel worksheets. 1. list with user names and their ids and groups and to input this data to the list with j...
-
Excel-Changing calculated dates to "hard" dates Closed
Hello, I used a simple +1 formula to create dates in column A. Now that I have the dates, I want to make them "hard" dates so they don't change eve...
-
Changing cell color with either conditional formatting or macro Closed
Excel 2003 or 2007, 3 preferred. I have a column 'E' that contains either 2 or 4 digit text codes (MR, SP, BA SC, EU WO, etc), up to 50 unique codes....
-
Auto Fill Form? Closed
Hello, I have a spreadsheet on which I have formulas for all my recipes. I have a column that I enter the amount of each recipe I want to mix. I h...
-
If function with date Closed
Hello, The concept is "If the days exceeds 30, the entire cell should be applied with some color or highlighted". Please respond Configurati...
-
recovering missing emails by restoring outlook identity from tim Solved/Closed
had a problem with Outlook 2011 client - emails went missing and not in deleted / purged folders if i restore outlook identity from a date i know h...
-
Problem recovering deleted item in Outlook 2010 Solved/Closed
I try to open deleted item recovery in Outlook 2010 and attempts to recover any message and receives the following error message: "Outlook was unable ...
-
VBA code to copy "Pivot like layout" to "data dump layout" d Closed
Hello, I have a spreadsheet that looks like this. Name - Column Name 1 - Column Name 2 Column Name 3 - Column Name 4 Johnny - 5 - 0 - 0 - 4 ...
-
Macro is not working Closed
Hello, The first time the macro worked, I was so happy! (I used it once) Now is not working anymore, no idea why. Can someone help me? I rea...
-
Filter according to 'typed' value Closed
Hello, I need an autofilter to change according to a 'typed' value on another worksheet. I have found this code, which works when the typed val...
-
Opening ost files with Outlook 2013 Solved/Closed
How can one open existing ost files in Outlook 2013? I tried but I get a message that it is not an Outlook Data file.
-
conditional replication of cell data Closed
I am using Excel 2013 I am using a spreadsheet for a TO DO list. The column headings are: "Item" (with rows numbered from 1, 2....) "Task Descri...
-
All of my picture files are showing up as Word doc's Closed
AllHello, This was a previous question that was answered. My problem is the same, but ALL of my pictures are showing up as a word file. Can I fi...
-
WINXP OUTLOOK EXPRESS LOST INBOX Solved/Closed
I STILL HAVE ALL MY SENT ITEMS BUT ONLY SOME ITEMS FROM 2006 LEFT IN MY INBOX' PLEASE HELP.
-
move data from one wrksheet to another using submit button Closed
hello im working on a project and ive create a workbook in which I place data into a worksheet known as "processing" which serves as a main page in w...
