The discussions

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

Cell to populate if other column has any text

Hello, I'm struggling to find a formula to populate one column's cell based on another column's cell having at least one character of text. e.g. A1...

1 reply Last reply on 16 Mar 2017 by
Mazzaropi

Change cell text based on another cell's color

Hello, I need to prompt a cell to write text based on another's cell color in excel but not using VB. Can you help? System Configuration: Windows /...

1 reply Last reply on 16 Mar 2017 by
Mazzaropi

Insert picture in excel macro which takes the file name refrence

Hello Friends, Kindly help me! I am trying to insert a picture in excel macro which takes the file name reference from the D5 cell and insert th...

23 replies Last reply on 14 Mar 2017 by
TrowaD

Formula for text in a cell and then total the amount on text

Hello im trying to total the shfit allowance on timesheets eg: In cell k7 they will leave blank if not claim shift allowance, but if they are then ce...

1 reply Last reply on 14 Mar 2017 by
Mazzaropi

Change value of subsequent cells once a condition is met

The simplified story: I have a user input "Start Month" that is between 1-12. I have Columns A:M labeled accordingly 1-12. The question: If the us...

1 reply Last reply on 13 Mar 2017 by
ac3mark

Vba to automatically insert subtotals in multiple worksheets

Good Day, I hope somebody can help me, I have an workbook with a main sheet ""2017 Sales" and 10 worksheets with the name of each individual sales Age...

1 reply Last reply on 12 Mar 2017 by
vics1000

Open workbook using following code

Private Sub CommandButton1_Click() Workbooks("Patch.xlsm").Activate Sheets("Site Name").Select S = Range("A1:A2") D = Range("B1:B2") E = Range("B...

1 reply Last reply on 10 Mar 2017 by
x

Database copy only certain information

Hello, I currently have a table with data containing peoples information for a sports program, I would like it if I put "Yes" in the coloumn for the...

3 replies Last reply on 9 Mar 2017 by
vcoolio
Results 1401 - 1450 out of a total of 12,259