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...

1 reply Last reply on 23 Aug 2015 by
vcoolio

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 ...

1 reply Last reply on 22 Aug 2015 by
Ambucias

Concatonating within commands???

 Solved

Ok - 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...

4 replies Last reply on 21 Aug 2015 by
BrianGreen

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...

1 reply Last reply on 21 Aug 2015 by
xpcman

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...

3 replies Last reply on 21 Aug 2015 by
vcoolio

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...

3 replies Last reply on 21 Aug 2015 by
vcoolio

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...

7 replies Last reply on 21 Aug 2015 by
nnavarro

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...

1 reply Last reply on 21 Aug 2015 by
vcoolio

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...

3 replies Last reply on 20 Aug 2015 by
Mazzaropi

Impact font

 Solved

hello, is the impact font included in windows 8.1. Configuration: Windows XP / Firefox 40.0

1 reply Last reply on 20 Aug 2015 by
xpcman

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: ...

5 replies Last reply on 20 Aug 2015 by
RayH

Comparing columns and returning value

 Solved

Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: C...

14 replies Last reply on 20 Aug 2015 by
TrowaD

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"...

2 replies Last reply on 19 Aug 2015 by
InfoTech04

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...

1 reply Last reply on 19 Aug 2015 by
ac3mark

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...

1 reply Last reply on 19 Aug 2015 by
ac3mark

Sumproduct based on relative cell

 Solved

Hello, 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 ...

2 replies Last reply on 19 Aug 2015 by
BrianP

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...

1 reply Last reply on 18 Aug 2015 by
ac3mark

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...

1 reply Last reply on 18 Aug 2015 by
TrowaD

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...

1 reply Last reply on 18 Aug 2015 by
TrowaD

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 ...

4 replies Last reply on 18 Aug 2015 by
Mazzaropi

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...

1 reply Last reply on 18 Aug 2015 by
vcoolio

Stack range of data to next empty row in other sheet

 Solved

Hello, 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...

4 replies Last reply on 18 Aug 2015 by
Milli

Macro that kills a macro when a new workbook is opened.

 Solved

Hi 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...

5 replies Last reply on 17 Aug 2015 by
ac3mark

How to open ost files?

 Closed

Hi, 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...

Last reply on 16 Aug 2015 by
Ambucias

Corrupt pptx files. need to repair them. please help!

 Closed

Hey 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...

Last reply on 16 Aug 2015 by
Ambucias

Exchange 2007 restore mailbox data deleting

 Closed

Hello, 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 ...

Last reply on 16 Aug 2015 by
joshuareeves

Exchange .edb corrupt

 Solved/Closed

hi 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 ...

Last reply on 14 Aug 2015 by
FrancisHancock

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...

2 replies Last reply on 14 Aug 2015 by
M.Hanzla

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...

1 reply Last reply on 13 Aug 2015 by
Mazzaropi

Excel, how to use macros and conditioning.

 Solved

Hello, 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...

2 replies Last reply on 13 Aug 2015 by
Matt

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...

3 replies Last reply on 13 Aug 2015 by
Mazzaropi

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...

1 reply Last reply on 13 Aug 2015 by
TrowaD

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...

1 reply Last reply on 13 Aug 2015 by
TrowaD

Using 'rept' inside 'if'

 Solved

Hello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...

2 replies Last reply on 13 Aug 2015 by
dinu

Date formula

 Solved

Hello, 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...

9 replies Last reply on 12 Aug 2015 by
Judy

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...

1 reply Last reply on 12 Aug 2015 by
vcoolio

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...

1 reply Last reply on 11 Aug 2015 by
xpcman

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...

1 reply Last reply on 11 Aug 2015 by
TrowaD

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...

1 reply Last reply on 10 Aug 2015 by
Mazzaropi

Outlook 2003 pptx attachment won't open

 Solved

Hello, 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...

3 replies Last reply on 10 Aug 2015 by
van_veen

Fetch data

 Solved

fist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift desire s004 Nisha...

3 replies Last reply on 10 Aug 2015 by
vcoolio

Problem with open doc files in ms

 Solved

Hello, 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...

2 replies Last reply on 9 Aug 2015 by
baruraf2015

Comparing 3 columns

Hello, Please help me get the correct formula for this: RETURN RED IF D1 lower than D2 and lower than D3 ...

3 replies Last reply on 8 Aug 2015 by
Mazzaropi

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 (...

1 reply Last reply on 8 Aug 2015 by
venkat1926

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 ...

1 reply Last reply on 7 Aug 2015 by
Mazzaropi

Stop outlook from transfering emails from my

 Solved/Closed

Hello, Everytime I open my outlook it transfres all of my comcast emails to outlook. How do I stop this? Thanks, Harri

Last reply on 7 Aug 2015 by
Bugs bunny

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...

1 reply Last reply on 6 Aug 2015 by
Ambucias

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...

1 reply Last reply on 6 Aug 2015 by
TrowaD

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...

1 reply Last reply on 6 Aug 2015 by
TrowaD

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...

3 replies Last reply on 6 Aug 2015 by
TrowaD
Results 2851 - 2900 out of a total of 12,266