The discussions
Transfer data from multiple sheets to sheet 1 based on criteria
Hello, I am creating an estimating workbook where I have multiple product sheets that list qty, part#, description, volume, lbs, list price & disc...
How to open hidden & locked file?
Hello, Good Morning, I was about to click the print option for my Microsoft Word File but I clicked the exactly below option which was "Hide and ...
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...
Why the type mismatch error?
My question is in the comment in the code: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target.Cells.Count > 1...
Format row based on text length
Hello guys, Can you pls help me? I am beginner in VBA and I need to sort out one macro. I have table and need to have highlited row with color, bu...
Using if condition with date function
Hello, Sir, i am using if condition with date function. my question is that I have two date in two column. dates are different. if 1st date col...
Step by step instructions
Hi everyone: Following policies is a difficult thing because it is open to interpretation. I was wondering if it is possible to create a prompt in...
Get month name and year from date
Hello, how do I can convert the date in to month name and year ex. 01/05/2015 , I want to get month name as May and year 2015 pls help me, b...
Change date automatically on the sheets
Hello, I have a document in Excel, and has 5 different pages; all of them have the date on top. I need to know, how I can set up the formula or th...
Impact font
Solvedhello, is the impact font included in windows 8.1. Configuration: Windows XP / Firefox 40.0
Help msb (microsoft visual basic) code for an excel macro button
Hello, I am trying to create a macro to help the input in a complex excel file. I have created several dropdown menues to choose from a list: ...
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"...
Conditional formatting
Hello, I'm trying to write a conditional format formula populating one cell (column of cells) based on the text content of cells in 2 other column...
Date range to division
Hello, we capture birth date as date and we would like to convert to division Month/Year 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006...
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 ...
Using word to pdf converter in application
i am looking to add a functionality in my online app, such as a button which can convert a word or doc to pdf. I see many freeware such as foxit reade...
Macro to autogenerate sheets based on unique values of a list
Hello! I would greatly appreciate if anyone could help me with a macro. I have a number of populated rows in one sheet (Sheet A) and one of the co...
Copies and saved in a different column
Hello, can you guys help me with this. I want to input a data in cell A1, then it automatically copied into cell B1. then if I input again anoth...
Copy row from sheet 1 to sheet 2 with formula
Hello, i need to copy a row from one sheet to another with formula and keep updating the data in sheet 2 every time i change the data in sheet 1 ...
Vba for copy from sheet 1(form) then paste to sheet 2(database)
Hello, newbie here. Please help me by giving a vba that could automatically make a database. I have a form(sheet1) detailed with various inf...
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...
How to open ost files?
ClosedHi, my Exchange Server not work. I need to open my ost file. Is it possible to do this using the Outlook? Files are larger than, which stores a lot of...
Corrupt pptx files. need to repair them. please help!
ClosedHey guys, there is big mess over here. Here I quote: I made some presentation files for promoting our new business. I showed them to my boss. She wa...
Exchange 2007 restore mailbox data deleting
ClosedHello, Summary: Trying to restore an old Exchange 2007 Mailbox, the restore seems to work as I see data in Outlook however as soon as the restore ...
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 ...
Nested if statement...
Hello, Can anyone find any errors with this formula. I know it will never return a "N" because the vlookup will terminate anything that doesn't m...
Auto fill
Hello, im looking for a formula when i add a"XXXX" word to a cell K7 it takes the value of another F7 and auto populates to another H7. so "WOR...
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...
Microsoft excel conditional formatting
Hi, I'm trying to make a cell display a number based whether or not another cell contains the words, "Sentinel", "Ramsden", "Goulding", or "Riverda...
Input mask
Dear Sir/Maddom. Hope to be fine and doing well. first of all i am thanks from your services in the filed of IT. I am working in Telecom Comp...
Transfer comments
Hello, Is it possible to transfer comments from one cell to another on a different sheet or workbook? I am able to transfer the contents of the ce...
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...
How to enter a row when an "if condition" is met
Hello, Would like to know how to add a row in a different sheet when an "if condition" is met. To illustrate, I have the following columsn in s...
Compare worksheets return third result
I Have two worksheets a) Warehouses Combined - this list all codes a to z b) Suppliers - list all suppliers with discount per supplier. Warehouse...
Populating companies sheets from mastersheet
Hello, Could someone help please. I have a excel file with a master sheet which contains invoice companies. The are alphabetical ordered. Bu...
Assigning values to a row
Hello, I have a row with descriptions in the adjacent cell for example a1 sam b1 happy a2 Jessica b2 sad a3 max b3 angry then in row c it...
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...
Comparing 3 columns
Hello, Please help me get the correct formula for this: RETURN RED IF D1 lower than D2 and lower than D3 ...
Problem in comparing rows
Hello, I want to compare two adjacent rows and highlight the difference; then I want to apply this to entire worksheet so that all adjacent rows (...
Multiple if and functoions
Hello, I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell ...
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
Recover paper term 2 year 4 english
Hello, i edited my paper on email and click on to save but when i log out and try to open it again i found that it was lost. please help me to find...
Find text and add two different texts next to cell
Hello, I have a sheet with contractor names(sheet1) on A1 and I have a separate sheet (sheet2) with contractor names (A1), personnel assigned to t...
Percentage
Hello, I have Rs. 1.3 million divided to 35 peoples. Sô you can help me, i mean 1st prize is high, 2nd low prize, 3rd is more low. Please guide me f...
Conditional format restrictions
Hi. Need a little help with conditional formatting. Basically need to build in a excel spreadsheet a rule where conditoinal formatting will pick up...
