The discussions

"countif" function for day of the week formatting

Hello there, Please help! I have a column of dates, where the formatting I've set for "Day of the week, month, day, year". How would I run a C...

2 replies Last reply on 8 Aug 2014 by
Jason

Automatically move a row to another sheet

Hello, I have a sheet named SENT SMS with information about clients, the service they got, price, if paid or not. In the column P named PAID , if it...

1 reply Last reply on 7 Aug 2014 by
TrowaD

Excel macro

Hi, I'm doing a project which requires excel macros but I'm not familiar with it. There are 2 worksheets 'AMBS Master' and 'fy2013'. The data betwe...

1 reply Last reply on 7 Aug 2014 by
TrowaD

Transferring selected data from multiple worksheets to one

 Solved

My team uses an excel to track our projects. We have many tabs (8) , but on each tab on Column A, we have a drop down menu that we can select if it's ...

10 replies Last reply on 5 Aug 2014 by
cpogata

Automatically insert multiple pictures in excel under 1 ref

Dear all, I hope to find some help here as I would really like to find an easier way than just insert each picture manually. I am not a pro in VBA...

1 reply Last reply on 5 Aug 2014 by
TrowaD

More than one rule in excle

From the image posted I want to be able to highlight the row when the done column is empty and is not today's date.

1 reply Last reply on 4 Aug 2014 by
Osama_bb11

Locking a range based on a value of a cell

 Solved

Hello, first I would like to thank every one working at kioskea my issue is , I want to lock a set of cells ( A2:M2) if the cell M2="app" and ...

4 replies Last reply on 4 Aug 2014 by
Osama_bb11

Removing duplicate data

A call for urgent help to anyone out there. In capturing data from archived files I saved this both on my laptop as well as on a plugged in memory ...

9 replies Last reply on 4 Aug 2014 by
Mazzaropi

Require help to count number

 Solved

1652 1646 1650 1658 1622 1651 1659 1582 1599 1606 1611 1657 1745 1937 1936 1648 1666 1656 1636 if i type like this in diffrence cel...

2 replies Last reply on 4 Aug 2014 by
ebrahimrta

Grater then , less then with number range multiple

 Solved

if the numbers cell A110 means the cell B1 have to calculate the C1 cell and if A1 20 means the cell D1 have to calculate ...... please let clear...

2 replies Last reply on 3 Aug 2014 by
najustar72

Relative worksheet reference in formula for chart data ranges?

Hello, I am working on a project and was hoping for some help any and all excel wizzes if you have the time. Does anyone know how or if one can re...

7 replies Last reply on 31 Jul 2014 by
TrowaD

Converstion of xls file to xlsx format

Hi I had recovered my lost xls format file and tried to open it with excel 2010 version. how can i view it in the new version. Is it possible to tran...

1 reply Last reply on 31 Jul 2014 by
BunoCS

Excel "if then" formula

 Solved

I am looking to create a "If Then" formula for Excel that can put an "X" in the cell if the date I am reffering to (Cell A6) is 0-5 days, next cell 6-...

6 replies Last reply on 30 Jul 2014 by
jessica2991

Comparing three columns and giving back specified values

I want search for strings I have in source(A) in both source(B) and source(C) and when it finds those documents give them the three revisions I ha...

1 reply Last reply on 29 Jul 2014 by
TrowaD

Search and transfer data between workbooks

Looking at reviews, I know this request will have a simple answer. I am new to Excel, and I need help on this spreadsheet. I have workbook open. On...

1 reply Last reply on 29 Jul 2014 by
TrowaD

Moving data from one spreadsheet to another on excel

I really need to be able to set up a macro & formula so that once I pick an option from a drop down list on my work book, that will automatically plac...

3 replies Last reply on 29 Jul 2014 by
TrowaD

Need help comparing dates...

 Solved

I have dates in one column, I want to enter a $0 value in another column if that date is >= 5 years in the past. Obviously, I'm a relative newbie with...

3 replies Last reply on 28 Jul 2014 by
Mazzaropi

Free office software

Hello, I would appreciate any information on the best free office download available to suit windows 8.1. Thankyou in advance for any assistance. G...

2 replies Last reply on 26 Jul 2014 by
Crusty

Automatic copy on excel

hi sir/mam, i want to automatic copy a data from sheet to another. all those qty on out column in big warehouse sheet must be copy to small warehou...

5 replies Last reply on 26 Jul 2014 by
venkat1926

Step by step help creating a link

Good afternoon all, I would like to create a link in a cell that will create a new worksheet in the same workbook. I am new to VBA and Macros so I ...

1 reply Last reply on 24 Jul 2014 by
TrowaD

Less than/greater than

I need a formula that will allow me to show if any cells in a range have a greater value than 100,if so show "YES". If not, have cell remain blank. I...

1 reply Last reply on 22 Jul 2014 by
Mazzaropi

Automate excel to shift data so the values in two rows match?

 Solved

Hello! Please help me with this quandary for my internship. I would greatly appreciate it :) Here is my problem: I want to match ID numbers in two co...

5 replies Last reply on 22 Jul 2014 by
excellenthelp

Excel auto-data transfer

Hello, 1. How do you transfer a whole row of data into a new tab if an X is put in the first blank column of data 2. How do you move a whole row...

1 reply Last reply on 22 Jul 2014 by
TrowaD

Restart microsoft office

I have this MS Office Professional Plus 2010 and it needs activation key. I entered the activation key and it said the picture here. I don't know ho...

1 reply Last reply on 21 Jul 2014 by
TrowaD

Copy x row n number of times

 Solved

Hi. I need the formula to Copy X Row N No.of Times. For Example Col 1 Col 2 ABC 3 DEF 5 GHI 4 O...

2 replies Last reply on 21 Jul 2014 by
smiller1712

Copying data in excel -only figures but not formulas

I would like to copy data from one worksheet to the other but do not want the formulas and calculations to pass from one worksheet to the other - just...

1 reply Last reply on 21 Jul 2014 by
Mazzaropi

Need help for combination macro

Hi someone, Please help me out the following problem. I have 10 nos. of machine as A, B, C, D, E, F, G, H, I, J and K. Combined to 2, 3, 4, 5, 6,7 ...

1 reply Last reply on 21 Jul 2014 by
venkat1926

Need to total a column with text in it?

Hi I am looking to total a column that has specific text in it. e.g My column has the words Leave, Public Holiday or Sick in it so at the botto...

1 reply Last reply on 20 Jul 2014 by
Mazzaropi

Database format

I kindly needed help on developing a workplace using database format for entering my medical equipment such as specification, model, serial numbering ...

2 replies Last reply on 18 Jul 2014 by
rabtun01

Vba code worksheet with a list of 67 competencies and 3 criteria

Hello, I have a worksheet with a list of 67 competencies and 3 criteria for each competency. A button is created on the same sheet such that upon c...

1 reply Last reply on 18 Jul 2014 by
ac3mark

Who to identify least one in excel

Hi, I have 10 Cells can be filled with between the text "L1" to "L20". In that we want find what is the least LXX text is . Someone can we help me ...

2 replies Last reply on 17 Jul 2014 by
TrowaD

Macro help needed - copy data row(s) from column into new file

Hello and thank you in advance. I was trying to follow along with the answer given here, but I'm not well versed in macros. https://ccm.net/faq/213...

5 replies Last reply on 17 Jul 2014 by
Burt_Macklin

Change date format - dd/mm/yyyy hh:mm:ss to mm/dd/yyyy hh:mm:ss

 Closed

Hello all I have some 1000 cell of date format. which has " 13/05/14 16:53:59 " Excel not recognize as date.. How can I change.. Tried Format...

Last reply on 17 Jul 2014 by
Mazzaropi

Failed to activate

I had a hard drive crash and reloaded all the software on a new disc. When I tried to reactivate Office 2010 it refused the product key in my box wit...

2 replies Last reply on 16 Jul 2014 by
middletown lawyer

Running a macro automatically

Hi Guys, I'm using the below code in VBA to hide and unhide colums in Excel. Sub Hide() If Range("A1") = "Summary" Then Columns("B:Z").Hidde...

1 reply Last reply on 16 Jul 2014 by
ac3mark

Add blank rows based on the value in a cell.

Hello, How to add blank rows based on the value in a cell. Say if value in cell is 9, then 9 number of blank rows to be entered automatically....

3 replies Last reply on 15 Jul 2014 by
mdazgt

Change the text colour based on the value in the cell

Hello, I want to change the text colour if the value is between -10 to 5 to green and the value between 5 to 40 amber and value between 40 a...

2 replies Last reply on 15 Jul 2014 by
TrowaD

Automatic data transfer

Hello, I have two tabs in a work book, Materials and Hire. In materials I have column A - PO Number Column B - Job Number and Column C - Date I am...

1 reply Last reply on 15 Jul 2014 by
TrowaD

Autofill cell with color based on deadline

Hello, I would like to ask for help on a task I need to do dealing with dates and deadlines. I have "C" with the due date of the task and would li...

3 replies Last reply on 15 Jul 2014 by
venkat1926

Microsoft office accounting 2008

Hello, Why do you need product key if Microsoft Office Accounting is a deleted product??? How do you get key? Configuration: Windows 7 / Mozil...

1 reply Last reply on 15 Jul 2014 by
Ambucias

Need to pull data from particular cells and add to another sheet

I've got about as far as I can with my limited knowledge of Excel so am searching for guidance, any and all appreciated. I have a sheet which measu...

1 reply Last reply on 14 Jul 2014 by
TrowaD

Split of row data into different subsequent rows

Dear Sir, I have query relating to split of data of one row into other subsequent rows upto certain number of characters till the width allowed to...

1 reply Last reply on 14 Jul 2014 by
MyHelpster

Using a different "from:" email address

Hello, I have a Hotmail account that I use for my primary email address (myaccount@hotmail.com). I recently began doing parttime work for my ...

2 replies Last reply on 12 Jul 2014 by
Plastic_Cup_of_Stars

Excel returns false sometimes.... why

 Solved/Closed

I'm using this formula to show the persons age based on date of birth. In some cases it works but in others it returns FALSE. If I change the date of ...

Last reply on 11 Jul 2014 by
plato

Date formate issue

Dear Friends i have one column of Date in A1 cell issue is diffrent date formate in Column A1 and i want convert in one formate shap Expample is ...

2 replies Last reply on 11 Jul 2014 by
MyHelpster

Excel issue

Hi, Please help me with this query asap!! I have data in 3 worksheets. have to compare C column of sheet 3 = MATCH ( data in A column...

6 replies Last reply on 10 Jul 2014 by
TrowaD

Transfering data

I have a charts with 2000 lines a colums of first names, a colums of last names, 3 address colums. I have a similar chart on a second sheet. Which...

3 replies Last reply on 9 Jul 2014 by
ac3mark

Help with vba code to copy and paste data needed

I want to create a worksheet and copy and paste rows with a specific value in Column A to a worksheet named for the value. The new sheet should have s...

1 reply Last reply on 9 Jul 2014 by
MyHelpster

How do i down load software

how do i down load software free soft ware from this site.

2 replies Last reply on 9 Jul 2014 by
MyHelpster

Excell automatic filters

Dears kindly i need fourmala to do the following i have a sheet have column A & B& C A have 3 different value (type1 ,Tybe2 & Tybe 3 ) and each on...

3 replies Last reply on 9 Jul 2014 by
venkat1926
Results 3751 - 3800 out of a total of 12,267