The discussions

Macro to create email, and pick which email account to send from

 Solved

I already have this set up how I want... Sub MakeMsg() Dim msg As Outlook.MailItem Today = Format(Now(), "mm-dd-yy") Set msg = Application.CreateIt...

2 replies Last reply on 4 Feb 2014 by
TomTom111

Find highest value and state its cell name

 Solved

Hello, I have the following issue: in A and B: Marche 160,994 Puglia 463,251 Lombardia 405,626 Emilia- 542,009 Lombardia 451,468 ...

2 replies Last reply on 30 Jan 2014 by
Fessi

Search for a string and if found, select that row?

 Solved

I know this is a very simple question but I can't find the answer I need. I am using Excel 2007 but I can get to a computer with Excel 2010 if necessa...

2 replies Last reply on 29 Jan 2014 by
maybedog

How to add times in hour and minutes format

 Solved

Hello In the first column I have start time, in the second finish time and the third column the time elapsed ie A minus B = C But if I add colum...

19 replies Last reply on 27 Jan 2014 by
Ambucias

Formula:if e18 = 1, 2, 3, 4 or 5 then end result = g18, g19 etc.

 Solved

Trying to create a formula where I have a merged cell (E18) that if 1, 2, 3, 4 or 5 is entered I want the end result to equal the contents of G18, G19...

2 replies Last reply on 22 Jan 2014 by
wreidmetals

How do i add text to a drop down list

 Solved

Good day how do i add text to a drop down list i created in excel Configuration: Windows XP / Chrome 24.0.1312.57

2 replies Last reply on 21 Jan 2014 by
Maxi84

Excel help

 Solved

I am tracking shipments of our product. When I enter the amount that shipped, I would like for that days date to appear in a separate cell and never c...

1 reply Last reply on 20 Jan 2014 by
TrowaD

Conditional formatting help

 Solved

Hi, I have a spreadsheet with a column for employee hours. Anything over 9 hours is considered overtime and we are tracking how many employees are ...

2 replies Last reply on 16 Jan 2014 by
tinayat

Conditional formatting with "contain".

 Solved

Hello...I am using Excel 2007. I can't get beyond the following: =ISNUMBER(SEARCH("campaign",A2))=TRUE This is what I'm trying to do...If cell A2...

3 replies Last reply on 15 Jan 2014 by
ac3mark

Ms excel number format error

 Solved

Hello, I use Ms Execl in that I have a error it like this..... 1. when I type a number 400 in the cell an give Enter. It is not showing the exa...

5 replies Last reply on 15 Jan 2014 by
Akoh

Date format problem (5.8.14)

 Solved

Hi. I'm using excel 2013 on Win7 Ultimate SP1. My problem is that I often type the dates with the help of decimals/periods. But I've learned thru goog...

4 replies Last reply on 14 Jan 2014 by
zopfan

Excel date format

 Solved

Hello, when users enter a date in excel using this format 12.1.2008, I need the cell to automatically change the format to 12-Jan-08 thanks, mo...

7 replies Last reply on 13 Jan 2014 by
zopfan

I can't open my pdf attachment in my eamil

 Solved/Closed

Hello, plz help me,i tried to open PDF attachment in my eamil but I could'nt .Configuration: Windows XP Internet Explorer 6.0

11 replies Last reply on 4 Jan 2014 by
max

Help with text & number rule!

 Solved

I wonder if anyone would know how to create the following rule in Excel: IF I enter a specific "text" in cell A, then Excel would insert a correspo...

7 replies Last reply on 3 Jan 2014 by
Alulus

Applying my macro to a range of cells...

 Solved

I found this macro and it works perfectly....inserts an "x" on a single mouse click into cells, but I only want it active on a certain range of cells....

5 replies Last reply on 3 Jan 2014 by
ac3mark

Date function

 Solved

i want to know how to create a date series in an excel.. for eg if i enter the date in A1 as 1.12.2013 how to create automatically in the A2 as 2.12...

1 reply Last reply on 24 Dec 2013 by
venkat1926

Corrupted office file

 Solved

i have a problem that i lost my all data from my computer. then i apply recovery software to get this data , although i recover my data but after reco...

2 replies Last reply on 17 Dec 2013 by
julupapa

Unique records

 Solved

Hello, I am very new to excel macros, however, I want to make a macro that will provide unique records from three different excel sheets. I have...

41 replies Last reply on 12 Dec 2013 by
TrowaD

Convert the date format into general format

 Solved

Hello, In excel 2003, how do I convert the date (3/21/2012) from date format into general format and still keep it show as 3/21/2012 instead of 40...

4 replies Last reply on 12 Dec 2013 by
Bharath

Moving data from rows into columns for every

 Solved

Hello, I have data in a single column and would like to transpose it into a row for every three rows with a space delimiter, for example; The colum...

20 replies Last reply on 10 Dec 2013 by
Glitchdata

Excel macro: combine selected rows

 Solved

Hello, I have source data in Excel looking like this: CustomerID SalesMonth SalesAmount 12345 Jan 15...

6 replies Last reply on 5 Dec 2013 by
iietntech

Sum ifs function in excel

 Solved

Is it possible to have a criteria range for a range of dates and have it add for a date less that the specified criteria? 11/1/...

4 replies Last reply on 28 Nov 2013 by
rtcorpuz

Invoice no

 Solved

Hello, After Long period i came here to ask some thing to my friends that is i want to raise the invoice as per the cell value i have given some e...

6 replies Last reply on 27 Nov 2013 by
sgmpatnaik

Bank reconciliation

 Solved

Hi Am trying to automate bank reconciliation Any ideas as what the code is. In the work book i have 12 worksheets for receipts and 12 worksheets ...

32 replies Last reply on 26 Nov 2013 by
TrowaD

Macro for linking two workbooks, comparing one document id with

 Solved

Hello, I need help in creating a macro for linking two workbooks, comparing document ID's in one workbook with the status of that Document ID's in ...

2 replies Last reply on 22 Nov 2013 by
Hyundai123

How to delete a line from excel cell

 Solved

Dear all How to delete a line from every cell in a column??

4 replies Last reply on 20 Nov 2013 by
mahfuz19

2010 if function help

 Solved

I'm looking to combine a IF function for one cell with a date function in another. The aim is to have something like this: =IF(A1=2099,"James Jones...

3 replies Last reply on 18 Nov 2013 by
ac3mark

Iam trying a lot to make the formula succes, but its not helping

 Solved

Hello Ther!! Iam trying a lot to make the formula succes, but its not helping all people ther Kindly help me on the below formula it gives resu...

3 replies Last reply on 17 Nov 2013 by
Kevin@Radstock

Will i lose my apps if i reset my ipod touch?

 Solved

Hello, My sound does not work at all on my touch, ppl told me to reset my ipod, but im scared to lose all my apps. is there another way to get t...

3 replies Last reply on 16 Nov 2013 by
idk

Can't access open office or documents

 Solved

I can't get the Open Office o4, to open. I have Vista, home ed. And I can't view the documents that are in the Open Office file. What if I dleted O...

1 reply Last reply on 11 Nov 2013 by
Ambucias

Dating problem!

 Solved

Hi Can you help? I need a cell to only input if a lead cell is blank but if the lead cell has a date format i.e 24/11/13 then to input that sam...

6 replies Last reply on 8 Nov 2013 by
rbmastertitan

Hide/unhide an autoshape or picture in excel

 Solved

Hi All, Could anyone tell me the method to Hide/Unhide an Autoshape or Picture in Excel Spreadsheet? I know it is possible through Macro Codes, an...

6 replies Last reply on 7 Nov 2013 by
jerangkung

Nested and/if statments

 Solved

Hello and good day. I am in the process of putting together an annual bonus/vacation accural sheet and need some assistance with building a comple...

3 replies Last reply on 4 Nov 2013 by
nelsojm

Excel worksheet auto generator

 Solved

Hello, i have a workbook with a names sheet that has all the info I need put onto timecard and a master sheet with the timecard that the employee wil...

10 replies Last reply on 1 Nov 2013 by
rizvisa1

Need help with lookup? or if? command

 Solved

Hi Everyone, Can someone help me with a command or macro that will look up the price of a product in a country from a reference worksheet and then fi...

3 replies Last reply on 31 Oct 2013 by
nycm

Compare cells of two columns excel 2007

 Solved

Hello, I have two columns with identical cells and I need to find those that are not the same. For example: Column1 Cell1 = "a", Column2 Cell1 = "...

5 replies Last reply on 31 Oct 2013 by
Rajen

Conditional formatting

 Solved

I need a formula stating that if cell R7 is blank, then Q7 is yellow. So if anything is entered in R7 then the cell Q7 is no color

6 replies Last reply on 31 Oct 2013 by
KGRIFFITH

Need macro- copy row and insert 10 times

 Solved

Hello, I have a similar question as this previous thread: https://ccm.net/forum/affich-107673-copy-row-and-insert-n-times but I'm not sure which ...

2 replies Last reply on 29 Oct 2013 by
nycm

Excel vba

 Solved

Hi all, Greetings, could I get help, I am trying to write data into cells in a spread sheet, using an initial value, then adding a specific increme...

5 replies Last reply on 24 Oct 2013 by
ugo234

Yes or no...if so....

 Solved

Hi I need to ask a cell to do two functions. So if a cell (drop down list) has yes/no...then another cell will.....when yes is selected then d...

2 replies Last reply on 24 Oct 2013 by
Tim

Converting rows of data into columns

 Solved

Hi everyone, I hope you all can help. I have a file in with 17,000 lines of data in rows that I need converted into columns. I don't work with Ex...

3 replies Last reply on 22 Oct 2013 by
chuaf24

Macro to traspose data

 Solved

Hi I need a help I need to transpose my data following way for a longitudinal analysis; ID Day1 Day2 Day3 Day4 Day5 Day...

5 replies Last reply on 21 Oct 2013 by
TrowaD

Want one cell to be highlighted if i type something in next one

 Solved

Hello, I want B1 to be highlighted as green if i type any text in C1. Please help me. Regards Saurabh

2 replies Last reply on 20 Oct 2013 by
Saurabhmitra07

Conditional formatting a single cell based on another range

 Solved

I have been trawling around looking for a solution to my problem. I need to highlight/colour a single cell when its value appears in a row elsewher...

2 replies Last reply on 20 Oct 2013 by
hussar

Conditional formatting a cell if a certain word is met

 Solved

Hi I am trying to conditionally format cell B3 if the criteria in cell C3 = NAT I am able to do it if it was a number but not if its a word, If the ...

2 replies Last reply on 15 Oct 2013 by
scarey3

If formula showing date

 Solved

Hi all, I created a spreadsheet that has a date in and a date out columns, the dormula I use on the date column is: =if(d2,TODAY(),""). Formula is in ...

2 replies Last reply on 9 Oct 2013 by
simeonmein

Excel vba: application.filesearch error

 Solved

Hello everyone, I encountered error "Object doesn't support this action." when the program the line "With Application.FileSearch". Here is my codes...

2 replies Last reply on 8 Oct 2013 by
wliang

Conditional formatting

 Solved

Hello, Does anyone know if you can set conditional formatting to highlight an entire row if the date in a specific cell is less than a week from t...

3 replies Last reply on 7 Oct 2013 by
Mazzaropi

If data matches in one column, check 2nd column matches

 Solved

I've been trying to figure this out for days, I'm sure it's possible but can't get it to work. I have a set of data - in one column there are refer...

2 replies Last reply on 7 Oct 2013 by
vickylouise

Help to convert a date to julian date fromat yyyyddd in excel

 Solved

hi, i have thousands of dates in format dd-mm-yy that needs to be converted to julian date format yyyyddd. dates that needs to be converted are fro...

6 replies Last reply on 30 Sep 2013 by
Calixte DORVIL
Results 1151 - 1200 out of a total of 2,603