The discussions
Requesting formula in excel on if condition / date function
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
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...
Excel date function dd/mm/yyyy
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....
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?
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
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
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
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....
Excel formula
Hello, I want the answer of this formula =IF(AND(L13
Adding a loop to macro to insert pictures
SolvedHello, 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...
Color coding variable pivot row label interior
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...
Excel assistance
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
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...
How to export data from different tabs in excel
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...
Change calculated to a hard date
SolvedI 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
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...
Macro creation
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
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
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....
If function with date
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
Solvedhad 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
SolvedI try to open deleted item recovery in Outlook 2010 and attempts to recover any message and receives the following error message: "Outlook was unable ...
Macro is not working
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
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/ClosedHow can one open existing ost files in Outlook 2013? I tried but I get a message that it is not an Outlook Data file.
All of my picture files are showing up as word doc's
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
SolvedI 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
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...
Sending email issues
Hello, I can received mail but can't send out mail. Error message Ox800408FC. Could someone please help. I have Outlook2003. Thank you so much! ...
Changing of number into word
Hello, Can you please help me how to change number into word in Excel 2007 Configuration: Windows 8 / Chrome 40.0.2214.115
Transferring numbers to new worksheet automatically
SolvedHello, I'm making a spreadsheet showing weekly costs. I've set it up so that each worksheet is a week, with totals using =SUM. I want to transfer th...
Sending email
Hello, When I try to send email , the email go away but the person don't receive the email, my outlook is version 2007, I tried to figure out what i...
Acrobat always opens in second screen
Hi, I have 2 screens. I don't know why, but Acrobat always opens in my second screen, even if I drop the window in the first screen. It doesn't memor...
Notification
Hello, I was wondering if it is possible to create a popup when a user has a shared excel spreadsheet open preventing others from using it. The popup ...
Downloadpdfplayer
Hello, I want download PDFplayer, please Configuration: Windows 7 / Firefox 35.0
Convert number into words
how i can convert numircal in words
Macro to create tabs and populate from other worksheets
SolvedI already posted this on the programming forum but have not had any responses as yet so I am trying here as it may be more appropriate. Current Set...
How to change the date of weekends in excel?
Hello, how to change the date of weekends in excel? pls help me.. thanks! Configuration: Windows XP / Internet Explorer 7.0
Macro to complete date form
Hello, I've got a spreadsheet with the Month in the top left "A5:B7" merged cells, the numerical days of the week (only Mon-Fri) on the right "L9:...
Calculate the number of days in any given year
Hello, I am trying to determine how many days in each year so I can calculate costs based upon the number of days. I have the following columns ...
How to insert rows in excel, when criteria is met ???
Sir, how to insert rows in excel, when criteria is met ??? Regards
How to transfer lines of txt from one sheet to another sheet?
SolvedHello, I have an excel file that has 2 sheets of relevant information that I need excel to logically determine line up and from there automaticly ...
Vba to auto insert comment (by vlookup list) on cell data entry
I have built an accounting program three columns of which are named Vat Number, Debit, and Credit I need that each time I make an entry into any cel...
Transfer full row based on one column on multiple sheet to one
I am new to this, and never did codes for Excel. But I need help. I have a workbook with 4 tabs: Summary, Project A, Project B, Project C. On Project ...
Computer show me the error message. (.pst file)
SolvedHello, After restore the .pst file back to hard disk, the computer show me the error message. How can i repair this file? Please help Best regards....
How to restore the telephone book from the wab file?
SolvedHow to restore the telephone book from the wab file? There is a file .wab, by the file size can be seen that the contacts are there but when opening ...
Please help me these extremely difficult exercises
ClosedHello, Hello everyone, I have an exercise about if function in excel. Honestly, I did pretty well the previous assignments but this one is much com...
Covert numbers to words
Hello, how do we convert numbers into words in excel Configuration: Windows 7 / Chrome 40.0.2214.115
Convert numbers into word
How do we convert numbers into words format in excel
Outlook express 6.0 losing contacts/error msgs. opening and send
SolvedDuring the last six weeks or so, whenever I install "updates" for my computer (Windows XP), my Outlook Express loses all my contacts, as well as becom...
