The discussions
How to use a single part of a cell's date
SolvedSo that's the scenario, I've a date in a Cell (D4) in the format 02/02/2008. I need to compare only the year of the date (2008) and if it's true re...
Help in merging codes
SolvedHi I need help in the following VBA (Macro Codes) in Excel 2013 Code 1: Private Sub Worksheet_Change(ByVal Target As Range) Dim Inva...
Function has too many arguments...
SolvedWhy is excel telling me that this formula has too many arguments? =IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID")) I am stationed on ...
Search for multiple substrings and return different values
SolvedI have a cell I2 which contains long string. I want to find out the following: If string in I2 contains "month", then return "Monthly", If string ...
Clicking data in one sheet..saving all those clicked in another.
SolvedHello, I'm working on excel which has names(Col A) numbers (Col B). I'm looking to create a sheet, who by clicking on the number, stores the number ...
Same date in column a on mutiple lines in seperate worksheets
SolvedHi, Not using FILL with copy/paste....Is there a way to create a date range in Column A (IE: 9/1/15) from line 1 going downward when entering multi...
Acrobat reader
SolvedHello, I get a prompt that my acrobat browser plugin is missing and need to reinstall. Do I need to download the software again? Configuration...
Please help in getting data clubbed in one cell
SolvedPlease inform how to get the following information clubbed in a row Data as follows Required data in a ...
Master sheet to work sheet,
SolvedI have been getting help at this site and I am not able to get into my messages to respond anymore. I am not sure if it is just a work computer issue ...
Accounts data requires automatic analysis
SolvedFive columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...
Custom sorting & calculating average based position
Solvedplease help me with this. i want to get the position based on average. but when i put all these in a table, all are getting jammed. please can u h...
Search word from list, match it copy values next to it
SolvedI have a list of product part numbers in one excel document. Now I need to pull the description and pricing from another document which is attached in...
Concatonating within commands???
SolvedOk - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet (stored...
Impact font
Solvedhello, is the impact font included in windows 8.1. Configuration: Windows XP / Firefox 40.0
Comparing columns and returning value
SolvedHello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: C...
Word "false" kept on appearing? =if function
Solved=IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data")))) How is it happen that I put "Incomplete Data"...
Sumproduct based on relative cell
SolvedHello, I can use sumproduct based on information contained in the same range of rows of a column adjacent to it, but I can't figure out how to do ...
Stack range of data to next empty row in other sheet
SolvedHello, I have a set of data in Sheet1 Range("D24:D50") and Range("AC24:AC50") would like to be copied and paste special value to Sheet2 Column A a...
Macro that kills a macro when a new workbook is opened.
SolvedHi All, I am still new at excel macros. I am using a command button to copy all work sheets in a workbook then pasting just the values into a new w...
Exchange .edb corrupt
Solved/Closedhi all, Had an exchange server go down, got the exchange .edb files only to find its corrupt, tried to use eseutil.exe to repair the file but when ...
Excel, how to use macros and conditioning.
SolvedHello, I have been looking up how to use excel to help sort data but ran into a few problems. First I have searched how to delete a row with certain...
Using 'rept' inside 'if'
SolvedHello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...
Date formula
SolvedHello, Can someone please create a formula for these numbers to change to a date. 152030355A, the answer should be 7/22/2015. The first two nu...
Outlook 2003 pptx attachment won't open
SolvedHello, I have Outlook 2003 and was emailed a pptx attachment. When I double click it, it always asks to save instead of opening it. Docx files ope...
Fetch data
Solvedfist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift desire s004 Nisha...
Problem with open doc files in ms
SolvedHello, I have several .doc files with .xls files (both 97-2003 versions) embedded. When I open the .doc file in Word 2010 and try to open the .xls...
Stop outlook from transfering emails from my
Solved/ClosedHello, Everytime I open my outlook it transfres all of my comcast emails to outlook. How do I stop this? Thanks, Harri
Need vba code to create loops please
SolvedI have done loops before but it has been a long time. I need to loop through rows of data and the rows of data changes. The value in column "N" is t...
Vba
SolvedI want to append the month name at the end of the tab names in my workbook I have 86 tabs which are named by employee name and every month I want to ...
Formatting cells
SolvedI'm stuck.... I am creating an invoice of sorts for a company who deals in different currencies. Q1. I have created a drop down list of all products ...
The object is corrupt - in word 2003
SolvedWe have a document that has several objects (Excel tables) in it. We update the tables each month and then "save-as" the new month. We have one tabl...
Exchange 2007 corrupt database
Solved/ClosedI'm running Exchange 2007 Enterprise on Windows 2003. I have about 10 databaes that are running. I reboot the server this morning due to some updates ...
Cutting last 10 charecters of a cell and pasting to next cell
SolvedHi Guys - Im back again with another excel macro problem. I can find all sorts of advice when I google this, but none of it quite matches my needs so ...
Microsoft project 2007 corrupting data
SolvedI have a split situation. At work I use MS-Project 2007 and at home 2003. To ensure transportability filers are always saved in 2003 MPP formats. ...
Opening a corrupted illustrator .ai file
SolvedWe have an Illustrator CS2 file, that a co-worker has been working on for the last month, that is now telling us unknown error has occured. We have...
Illustrator file damaged and could not be repaired
Solvedits been coming more and more common for my files to become damaged and not be able to open for me. It started with files that had an insane number of...
How to restore xls?
SolvedWe had a need to factory restore our PC. It is Windows 7 Home Preimum with SP1. We copied all data off ran the factory restore drive, reinstalled Offi...
Excel formula needed to count a list of names
SolvedHi This is probably an easy one for the pro's, basically I have a list of names that will change as reports are generated. The report will inclu...
Publisher 2007
SolvedHello, My computer crashed purchased a new one and am reloading software. I have my Publisher CD but no longer have the key. I called microsoft and th...
Opening pdf files in photoshop
SolvedHello, I am having trouble opening my pdf file that I created using photoshop CS2. I can't seem to open this file anymore, previously I could open i...
Conditional formatting: find text and highlight from other cell
SolvedI have a table with names and number values alternating in a table. I add all the numerical values and highlight based on the total value for each nam...
Ms outlook outlook data file cannot be accessed " while accessin
SolvedI am unable to open my Outlook file due to corruption how to repair database .pst file of MS outlook. I was using Microsoft Outlook 2007 from last 2 y...
Get data present in row1 of sheet1 copied into row1 of sheet2
SolvedHello, I need to get data present in Row1 of Sheet1(Central OPD) to be copied into row1 of Sheet2(Departmental OPD) based on Department Column of Sh...
Outlook 2010 cannot open or access the required pst file
SolvedThi smorning a system has had a problem. When I try to open Outlook, I get the following error: "Cannot expand the folder. The set of folders canno...
Formula - if c2 is not blank, and b2 is blank, then copy c2 to
SolvedHi all - Am looking for help on formula - I want excel to look at cell C2, then if it has anything (text or numbers), then to look at cell b2. If ...
Transfer data and then apply formula
SolvedHello, I have a rather large spreadsheet which records the data from a number of different branches on each separate worksheet (labelled as "branche...
Copy formulas across workbook
Solved/ClosedHello, I want to copy Excel 2007 formulas from one workbook and past to the other workbook without the workbook name in the pasted formulas. Can ...
Macro to copy/paste specific range every 3 rows
SolvedHello, I am beginner in VBA and now have an Excel sheet with about 4000 rows, where I could need a macro. I already recorded a macro for the fi...
Need urgently to find a macro in excel report across sheets
SolvedHi, Anyone a solution? I need a macro that will do the following: 1. Search for a word, a number, ... across all the worksheets in the workbo...
Error trying to populate new worksheet using macro
SolvedHey everyone, I've been working on a macro to create a new worksheet based on the information entered into a column of a "data" worksheet which pop...
