## The discussions

### How to convert dd/mm/yyyy to mm/dd/yyyy

Hi All, Kindly help to convert DD/MM/YYYY to MM/DD/YYYY for the following examples. Thanks in advance, 19/08/2014 13/08/2014 13/08/2014 4/08...

3 replies Last reply on 7 Jan 2015 by
Cathy

### Copy and paste macro

hello, I am new to the vba programming for excel 2010 but what I have been able to ascertain has helped me tremendously at work, however I am having ...

venkat1926

### Converting numbers to alpha

I need a simple way to convert a price to an alpha code, for instance Graystoke = 1,2,3,4,5,6,7,8,9,0 so if a price is \$5.66 it appears as s.tt I n...

RayH

### Percentage work

Solved

Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I at...

6 replies Last reply on 6 Jan 2015 by
RayH

### I need a macro please

Hello, I have 70,000 lines of data. I need to make 1400 files of 50 lines each from the original 70,000. So I'm hoping there is a macro that can p...

3 replies Last reply on 5 Jan 2015 by
RayH

### Recurring weekly date

Hi, I'm wanting to set up a weekly review date for a number of rows on a spreadsheet. Each row has a different start date. I've tried WORKDAY.INTL wit...

5 replies Last reply on 5 Jan 2015 by

### Text label and value if value in other worksheet is > 0

Solved

Hello, can someone please help me with a formula for this. Text label and value, if value in other worksheet from 2 different cells is > 0, label...

5 replies Last reply on 5 Jan 2015 by

### How do i get my old inbox back?

Solved

My computer had some network difficulty. After shutting down I noticed my Outlook Express inbox was empty. When browsing to my OE folder I see two i...

wilkersonbria

### Question with if function

Hello, I was wondering, if I have for example in C2, C3, C4 the next info: "Tableta Onda V989 Allwinner A80 Octa Core 9.7 Inch Sistem Operare A...

vcoolio

### My ipod won't let me use apps

Closed

Hello, I got a brand new iPod touch 2nd generation as a gift for Christmas. I synced it with my mac and every song/video/app downloaded with no probl...

Last reply on 3 Jan 2015 by
Ambucias

### Short cut to caps while typing.

Hi, I would kindly like to inquire whether it is possible to highlight a given group of words or sentences that are in small letters and turn them in...

3 replies Last reply on 2 Jan 2015 by
Kiviangu

### Take reference from previous sheet automatically

Hello, I make a payroll settlement sheet in excel every week. When i make next week sheet i copy previous sheet & start working on it. Sometimes i...

vcoolio

### Allow my outgoing mail

Hello, I have tried 465 and 587 and 25 all do not allow my outgoing mail can some help me with my problem

Ambucias

### Excel - to generate unique id

Solved

Hello, Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Bel...

4 replies Last reply on 1 Jan 2015 by
ferg

### Decrease the value first by 10% and then increase the value by 5

I want to decrease the value first by 10% and then increase the value by 5%. What is the formula in Ms excel.

2 replies Last reply on 1 Jan 2015 by
chandan

### Security code

Hello, Please consider using the below codes in order to have the phone restored to factory settings and hence get the present difficulty expe...

DENDEN

### I need a macro please

Solved

Hello, 1 spreadsheet has 15 columns of data with column A having the unique identifier 2 spreadsheet has 37 columns of data with column B havin...

7 replies Last reply on 31 Dec 2015 by
rjbuer

### Excel using date range and formula on separate sheets

I'm creating a bank register with the dates in column A. Values are in columns C and D. The title of my first page is 'Register' What I'm trying ...

vcoolio

### Copy daily cost entries into the particular ledgers

Solved

Hello, I want to copy the daily cost entires into the particular ledgers, which i put in different sheets. Ex: I have the following data: D...

6 replies Last reply on 31 Dec 2015 by
vcoolio

### Need msexcel 2007 formula

Hello, Masters of Excel. I need formula like H5+I5+J5+K5+L5+M5+N5-O5=P5. I need H5 to N5 add & subrtact O5 in P5. Hope i have detailed this brief. T...

3 replies Last reply on 31 Dec 2015 by
vcoolio

### Excel cell equal another cell only if its a certain percentage

Hello, I'm trying to have a cell equal another cell only if its a certain percentage (percentages are in another cell also, I tried "IFSUM" but its ...

6 replies Last reply on 30 Dec 2015 by
vcoolio

### Date entry

Solved

Hello, i have an Excel sheet which my colleague should enter the date after he finished his job, for example:\today date is 2014/28/12 he shou...

2 replies Last reply on 30 Dec 2015 by
ArashMan

### How to lock or password protected specific cell in excel 2010

Solved

Dear all: Hope you are fine. How can I Lock a specific cell of excel 2010 that any one can not change or input anything in that cell. Pleas...

4 replies Last reply on 30 Dec 2015 by
Biswajit-Shaha

### Checking cell value against a range of numbers

Hello, I want to check a cell's value and if it falls in a particular range then I want to write "OK" in some other cell and if it falls out of sp...

shanthich

### Help with macro in excel

Hi I need some help in writing a macro for the below: 1. In sheet 1, I have column A with a list of items and many of them will be repetitive, ...

venkat1926

### Date change in excel sheet

Hello, in excel sheet date come to 29/12/2014 now i wants date on 29/12/14. so help me how to change date format or use formula to change date fr...

venkat1926

### Compare excel data

Hello, In excel i have say the following coordinate data: 2792691.388 215476.765 423.165 2792691.388 215526.765 423.045 2792691.388 215576.765 ...

venkat1926

### Excel macro to format report

Solved

Hi everyone, I am new to this forum..........so new I've already typed my question, then clicked "ask your question" again instead of submit..........

7 replies Last reply on 29 Dec 2015 by
ramu sanga

### Excel file is corrupt.

I hope one of the experts here will be able to save the files, which are very necessary for my work. My excel file became corrupt for very obvious rea...

2 replies Last reply on 27 Dec 2014 by
NikkiTum

### How to format a cell based on date in another cell.

Hello, i.e. We want to format B1 based on date in A1. ( If date in B1 is 2 or more days higher from the date in A1, then B1 must get colored. This...

Mazzaropi

### Dropdowns in excel

There are multiple ways in which you can create a dropdown list in Excel. Data Validation Form Control (Combo Box) ActiveX Control (Combo Box) But...

### Conditional formatting based on dates

Massive long shot here.....I'm trying to conditionally format certain cells to black out after the end of a certain month. It is for a monthly time...

### Move completed data in sheet 2

Hello, I have raw data in sheet 1. I need to move completed data in sheet 2. I m using column H to update work status as "completed or pending". Pls...

### Excel vba - color code column cells based on values

Hi, Super new to VBA, and need to write code to evaluate the values in Column I, starting with I3 and going down a varying number of rows depending...

### How do i change the format "yy/mm/dd" to show as "mm/dd/yy"?

Hello, I have a spreadsheet that I need to convert the date fields from the format "YY/MM/DD" to read as "MM/DD/YY". For example, if the field c...

2 replies Last reply on 22 Dec 2014 by
Mazzaropi

### Need to write a macro to copy a row of information if true

Solved

Hi, I have a workbook with several tabs and I want to first check if Column F on the first sheet contains 13 as the year (12/16/13 is the format) and...

7 replies Last reply on 22 Dec 2014 by
vcoolio

### Typing master question

is in this application full study can be done.....?

Ambucias

### Vba cut/paste in another tab

Dear all, I'm trying to copy in a different tab all rows that indicate in column [AN] a value less to or equal to 12. However, this column, as i...

### Transfer data from a sheet to another many sheets

Hello, I am trying to transfer data from one sheet to many other sheets . For example , when I write data to a row , I woul...

10 replies Last reply on 22 Dec 2014 by

### Outlook pst fix

Closed

Hello, I have MS Outlook 2007. I recently had a problem with my computer, where when Outlook starts up, a message pops up saying "Cyclic Redundanc...

Last reply on 22 Dec 2014 by
curtis88

### Assistance with excel macros

Greetings all My company uses Excel to track inspections and maintenance of portable fire extinguishers and I'm trying to add some functionality to...

RayH

### Conditional formatting a row from a validation list

Hello, OK, I am trying to apply a conditional format to a worksheet whereas I have a validation list in a column at the end of the row of data. Ba...

Mazzaropi

### Excel-macro to sumup data from multiple workbooks to master xlsx

Hi All, Can you please help me. Scenario: 1. There is a common template which has some tasks listed in columns against which the team members wil...

2 replies Last reply on 19 Dec 2014 by
Unokashi

### Vba help!

Hello, I am absolutely a novice when it comes to macros and VBA and need some help. I have a workbook with 6 worksheets. The first work sheet ("Al...

2 replies Last reply on 18 Dec 2014 by
vcoolio

### Using a macro to copy & paste from one sheet to another.

Solved

Hello, Hi Guy's I hope you can help, I am using two sheets. one is spread across different rows so when I click create list it copies everything ...

8 replies Last reply on 18 Dec 2014 by
vcoolio

### Excel formula numbers to dates

Solved

Hi, I need an excel formula for changing numbers to dates. It is part of the Julian Calendar but backwards and one extra number. Ex. 273143 is 9/...

6 replies Last reply on 18 Dec 2014 by
ah2jh1sh2

### How to use releative refrences in conditional formating??

Solved

the first picture is the formatting rule of C7 cell the second picture is the formatting rule of E7 cell which i copy from C7. as you c...

8 replies Last reply on 18 Dec 2014 by
Mazzaropi

### Transferring data from a excel workbook to another automatically

Hi There, I'm fairly new at macros and I would like to write a code that will help me transfer data from a workbook to another. I update Workbook 1...

2 replies Last reply on 18 Dec 2014 by
Legacy1990

### Conditional formatting based on another cell

Solved

Hello, this is what I want: EXAMPLE: B3= Arash if B6=1 then B3 goes red if B6=2 then B3 Goes yellow and if B6=3 then B3 goes green i want to...

2 replies Last reply on 17 Dec 2014 by
ArashMan

### Conditional formatting based on another cell

Solved

i want to type a name in cell B3. and I want the cell's color change when I type 1,2 or 3 in B6 cell by using conditional formatting. is that possible...

5 replies Last reply on 17 Dec 2014 by
ArashMan
Results 3451 - 3500 out of a total of 12,266