The discussions

How do i calculate vat inclusive

Hello, how do i calculate VAT inclusiev? for example, TZS 849235 is vat inclusive, how do I take out the VAT? Taking VAT as 18% System Configur...

1 reply Last reply on 13 Apr 2017 by
Mazzaropi

How can i get my cvs out of my old office

Hello, how can I get my cvs out of my old office System Configuration: Windows / Edge 14.14393

1 reply Last reply on 12 Apr 2017 by
kieferschild

Change of date

Hello, I Want to change date format mm/dd/yyyy to dd-mm-yyyy in MS Excel 2003 Please solve my problem urgently System Configuration: Windows ...

1 reply Last reply on 12 Apr 2017 by
BunoCS

Import .pdf ...?

 Solved

Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...

2 replies Last reply on 12 Apr 2017 by
RickRoll

Highlight date range if cell containing date falls within that range

Good day! I have a list of static date ranges and would like to highlight a range if a date occuring in that range populates in a different cell....

5 replies Last reply on 10 Apr 2017 by
Zohaib R

Freezing column and row

Hello, how do you freeze first column and top row in excel?

1 reply Last reply on 10 Apr 2017 by
vcoolio

Lotus sympony to word

FILE FROM LOTUS SYMPONY COULD NOT BE OPENED IN MICROSOFT WORD WHAT TO DO

1 reply Last reply on 9 Apr 2017 by
ac3mark

Change a cell content according with the color of another cell

Hello, I´m using Excel and need to change the VALUE of a cell (need to appear "-") if the COLOR of another cell is PURPLE. After digging around wit...

1 reply Last reply on 9 Apr 2017 by
ac3mark

Pasting and deleting macro

Hello, I need to create a macro that paste macro buttons from one spread sheet to another spread sheet, but when I try to do this and assign the mac...

3 replies Last reply on 9 Apr 2017 by
ac3mark

Nestle fomula nightmare!!

Sorry - fixing mini typo Hello - any help!! Going bald ripping hair out trying to resolve! I want to return a value "Q1" if a date falls between...

4 replies Last reply on 8 Apr 2017 by
Zaps11

Need help on excel macro

I need help to create a macro which helps me to get data from 'Sheet1' and paste that number of counts in 'Sheet2' for example, i have a table in s...

1 reply Last reply on 8 Apr 2017 by
Zohaib R

Edate in excel help

Hello... I have a training for log for a large number of staff for various different courses which have all been completed at various different dates ...

1 reply Last reply on 8 Apr 2017 by
Zohaib R

Excel for mac date formatting

Hello, I have two columns one for the month/day and one for the year. When I formatted the month/day column it automatically adds the year in whi...

1 reply Last reply on 8 Apr 2017 by
Zohaib R

Format excel data

Hello, i need to modify the data in my excel. Right now the data looks something like this: case A start 51 stop 55 ...

1 reply Last reply on 7 Apr 2017 by
Zohaib R

Copy rows from one tab to another - if specific criteria in col

Hello, In a file, I am trying to copy data from one row of a worksheet if specific criteria are met in one column to another worksheet. Ex: ...

1 reply Last reply on 7 Apr 2017 by
vcoolio

Formula

 Solved

I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...

2 replies Last reply on 6 Apr 2017 by
ehmetcalf

Help for time reminder in excel

Hello, I entered some date in excel and I need to be reminded one day before that expected date !! How do I code it so that I will get a reminder ...

3 replies Last reply on 6 Apr 2017 by
Jerrychan38

Graduate number in a cell

Hello, I have this database on Excel that I want to create. One of the columns will have the date of birth (DOB) and another column will have the...

1 reply Last reply on 6 Apr 2017 by
Mazzaropi

Software for finanicial

how can i get a software for account system tally ,quickbook

1 reply Last reply on 5 Apr 2017 by
ac3mark

Countif coloring of cells that were used.

Hello, I would like to color cells (or a row) that were used for "countif" values. for example, at my work, i have to indicate private calls f...

3 replies Last reply on 5 Apr 2017 by
ac3mark

I cant get rid of the false function

Hello, I don't know whats wrong with this formula =IF(C4="Single",K4*1, IF(C4="Twin",K4*2, IF(C4="Quad",K4*4))) It keeps saying false in the ce...

1 reply Last reply on 5 Apr 2017 by
vcoolio

Microsoft word icon changed to unknown program

My Microsoft word (program) icon changed from the classic picture to the unknown programs icon. I am using windows 7 enterprise. Please help me how to...

5 replies Last reply on 5 Apr 2017 by
Ambucias

Automatically copy contents from multiple shts to a summary sht.

Hello, I've an appointment sheet for each client of mine with their details. lets say like 50 sheets. I'd like to create a summary sheet from all ...

1 reply Last reply on 5 Apr 2017 by
vcoolio

Excel codes

Hello, I would like to be able to set up a spread sheet so when I type March on sheet1 in column A it copies the entire row onto sheet 2

1 reply Last reply on 3 Apr 2017 by
TrowaD

Vba code

Hello, sir , i am trying to copy data from one row and paste that data into column of another sheet. this process is continuous till all row no...

1 reply Last reply on 3 Apr 2017 by
TrowaD

Cell color count with a condition

Hello, I need a help. I need to count cells in a range having a specific color (In one column) & cells in a range having a text (In another co...

1 reply Last reply on 3 Apr 2017 by
TrowaD

Conditional formatting based on two cell values

 Solved

Hi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...

3 replies Last reply on 3 Apr 2017 by
Mazzaropi

Copying cond. format for entire row based on 1 cell to other row

 Solved

I have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value

3 replies Last reply on 3 Apr 2017 by
Mazzaropi

Create separate worksheets/excel files

Hello, I need to create an excel file with the following I have a base file and a summary sheet I need to create separate sheets and rename them...

1 reply Last reply on 3 Apr 2017 by
Brooke_Harper

Macro to compare two excel file

Hi Team, I need excel macro to compare two excel file and highlight the difference in the respective cell with both the values in file 1 and 2 .

1 reply Last reply on 31 Mar 2017 by
ac3mark

Drop down lists

 Solved

Hi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...

3 replies Last reply on 31 Mar 2017 by
Mazzaropi

Excel combine worksheets into one

Newbie here, I have a question on how to do this in excel. I have lots of worksheets, 200+, each with different names, and I was wondering if its p...

1 reply Last reply on 30 Mar 2017 by
ac3mark

Removing false value

 Solved

Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...

5 replies Last reply on 30 Mar 2017 by
ac3mark

Copy rows to other sheets based on value in column

 Solved

All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...

6 replies Last reply on 30 Mar 2017 by
vcoolio

Automatically save data to another excel sheet.

Hello, System Configuration: Windows / Chrome 57.0.2987.110 Please give me suggesstion & Advice to my query, Whenever I enter date in Ex...

1 reply Last reply on 30 Mar 2017 by
vcoolio

Pdf file alwasy opening in word

 Solved

Hello, What to do to disable my attachment file in pdf to open in Word application?

5 replies Last reply on 28 Mar 2017 by
blkdolphin

How to calculate values using countif

I have 2 sheets sheet1 is a Summary sheet and sheet2 is data sheet sheet 2 has columns from A TO R, in that column G is Severity (heading) wit...

1 reply Last reply on 28 Mar 2017 by
ibrahim

Trying to create a multi-column formula.

 Solved

Hello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...

9 replies Last reply on 28 Mar 2017 by
TrowaD

Two excel sheets copy new data input on one sheet to new row on

Hello, I have an excel spreadsheet that I have to update periodically overwriting old data. I have another sheet where I need to update the same inf...

1 reply Last reply on 22 Mar 2017 by
maheshmahi

Need to extract data from a column to another worksheet.

Hello, I need code to extract all data containing a name from a column on sheet1 and copy it to Sheet2 and remove all blanks. The name is pulled fo...

3 replies Last reply on 22 Mar 2017 by
vcoolio

Excel problem

 Solved

Hello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...

3 replies Last reply on 22 Mar 2017 by
Mazzaropi

Recover user id of irctc

 Solved

Hello, recover irctc user id , i forgot it , so help me Configuration: Windows / Chrome 53.0.2785.101

2 replies Last reply on 22 Mar 2017 by
rishabhj2019

Help with index match or vlookup

Hello, I have a worksheet with about 2000 rows. In column C and Column J i have a common Key. In Column K I have data that i want to write to Colu...

1 reply Last reply on 21 Mar 2017 by
Mazzaropi

Password detail

how can i get the password of ms word installed in my system it keeps telling requesting for password dont know how to go about it can someone please ...

1 reply Last reply on 21 Mar 2017 by
Ambucias

Excel find word in series of cells and add

 Solved

Hello, My colleague wants to has a spreadsheet with many columns and rows. The spreadsheet setup is something like this: Cells under column A ha...

3 replies Last reply on 17 Mar 2017 by
matt

Highlight one value in a dropdown menu of three responses

 Solved

Hello, I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yell...

2 replies Last reply on 17 Mar 2017 by
MeganNolf

Create new excel files based on the data in a column

Hello, I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding. I have a spreadshee...

1 reply Last reply on 17 Mar 2017 by
vcoolio

Code to move rows into another sheet based on certain values

 Solved

I'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be...

1 reply Last reply on 17 Mar 2017 by
vcoolio

Count only cells containing 2 given words

Dear friends, I simply get mad trying and trying again to find the right function that may help me to count out of an array only the cells that conta...

4 replies Last reply on 17 Mar 2017 by
BruNL_2017

My document was in pdf when i was trying to convert to word it b

Hello, my document was in pdf when i was trying to convert to word it became unreadable what can i do ? in Windows 7 System Configuration: Windows ...

1 reply Last reply on 16 Mar 2017 by
Ambucias
Results 1401 - 1450 out of a total of 12,266