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

1 reply Last reply on 7 Jan 2015 by
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...

1 reply Last reply on 6 Jan 2015 by
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
TrowaD

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
TrowaD

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

1 reply Last reply on 5 Jan 2015 by
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...

1 reply Last reply on 4 Jan 2015 by
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...

1 reply Last reply on 2 Jan 2015 by
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

1 reply Last reply on 2 Jan 2015 by
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...

1 reply Last reply on 1 Jan 2015 by
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 ...

1 reply Last reply on 31 Dec 2015 by
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...

1 reply Last reply on 29 Dec 2015 by
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, ...

1 reply Last reply on 29 Dec 2015 by
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...

1 reply Last reply on 29 Dec 2015 by
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 ...

1 reply Last reply on 29 Dec 2015 by
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...

1 reply Last reply on 26 Dec 2014 by
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...

1 reply Last reply on 23 Dec 2014 by
TrowaD

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

1 reply Last reply on 23 Dec 2014 by
TrowaD

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

1 reply Last reply on 23 Dec 2014 by
TrowaD

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

1 reply Last reply on 23 Dec 2014 by
TrowaD

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

1 reply Last reply on 22 Dec 2014 by
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...

1 reply Last reply on 22 Dec 2014 by
TrowaD

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
TrowaD

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

1 reply Last reply on 19 Dec 2014 by
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...

1 reply Last reply on 19 Dec 2014 by
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