The discussions

Copying a row to another sheet with a trigger

Hi All, I was preparing an excel workbook, based on the sales pipeline. To simpify, The first sheet has company name and contact column. Titled "...

1 reply Last reply on 22 Jan 2015 by
TrowaD

Format based on another cell with a letter.

Hello, I would like to know if there is a way to apply a format formula to a cell but to use a letter as criteria instead of a number? Example:...

1 reply Last reply on 22 Jan 2015 by
ac3mark

Regarding pivot

 Solved

Hi I am doing Pivot for multplie data . In the Value field ( bottom right ) , I need SUM as default instead of count . I have to drag multiple ...

2 replies Last reply on 22 Jan 2015 by
Karthikeyan1207

Paste at end of data

Hello, I'm trying to write something that will copy and paste cells AC10:AQ15 from a sheet called "Format" to the end of column AC on the sheet ca...

4 replies Last reply on 22 Jan 2015 by
LV

Counting words, names as number values

Hi, Ive been searching for a way to count a list of names as a number. I currently have to place a 1 in a column next to the list of names. And have ...

3 replies Last reply on 21 Jan 2015 by
RayH

Find the first available (empty) cell on a worksheet.

 Solved

As a newbee to VBA, my boss has given me an impossible task ... Basically I need to be able to enter one cell worth of data from one sheet of a wor...

19 replies Last reply on 21 Jan 2015 by
BrianGreen

Trying to see if i can even create a macro! please help!

I want to know if its even possible to create a Macro whenever I copy/paste information that is provided to me weekly, which in this case is in th...

3 replies Last reply on 21 Jan 2015 by
RayH

Lookup problem.

 Solved

I have a column of 20 dates in col. B spaced by 2 or 3 weeks, and a number beside each one in col. C. In cell C24 I need a formula that returns the v...

5 replies Last reply on 21 Jan 2015 by
Babu546

Copy paste data in same column for multiple time

 Solved/Closed

Hello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After copy p...

Last reply on 21 Jan 2015 by
sree

How to change text color dep.on the value of another cell.

Hello, I have 2 questions: 1. I'd like to change one's name color to red if that is in debt. 2. want to count a. all names (number of all people); b...

1 reply Last reply on 20 Jan 2015 by
ArashMan

Multiple if functions with dates

Hello, I am rather new to creating Excel formula I want to create the following rule working with dates: IF date in A1date in A2, then date ...

1 reply Last reply on 20 Jan 2015 by
ArashMan

Compare a cell whit itself (conditional formating)

Hello, i want to know is that possible to compare a value of a cell with itself. for example i enter "10" in cell B2 tomorrow i want to change it...

1 reply Last reply on 20 Jan 2015 by
ArashMan

Putting a password on memory card

Hello, I want to put a password on my memory card that has an audio file, but i want to let it play on a mp3 player without typing the password. ...

1 reply Last reply on 20 Jan 2015 by
nathanwirth

Due date reminder ahead of one month and mail that to customers?

dear sir/madam Here there are 6 columns with 'n' number of rows. Column 'E' represents DUE DATE of particular 'Sol ID' and this date is common...

1 reply Last reply on 20 Jan 2015 by
xpcman

Replacing duplicates

 Solved/Closed

My Excel spreadsheet is set out as follows: A B C D E F 1 2 14 0 14 14 2 1 13 0 13 13 3 4 4 1 4 4 4 3 3 1 3 17 ...

Last reply on 20 Jan 2015 by
TrowaD

Compare and copy in column

I want to copy data in column 'B' when column 'A' is not blank. 'A' column has some blank rows. please give me solution!

3 replies Last reply on 20 Jan 2015 by
vcoolio

Excel - macro to highlight rows with duplicate values in a cell

 Solved/Closed

Geetings, Kindly help us in creating a macro that highlight rows based on duplicate values in a cell [this cell may contain Alphabets, Numbers or ...

Last reply on 19 Jan 2015 by
TrowaD

Key board shortcuts to navigate along an excel sheet

Hi all, I would like to know if there is a keyboard shortcut to navigate from, for example sheet 1 to sheet 2 on the same excel file without using th...

1 reply Last reply on 19 Jan 2015 by
BunoCS

If function with date in excel

 Solved

Hi, hope someone can assit. I need to create a sheet where I must take the current date and add a fulle week or two weeks to the date by selecting an ...

2 replies Last reply on 19 Jan 2015 by
ace-82

How can i create worksheet as date from 1 jan 15 to 31 dec 15

Hello, I would like to create 365 worksheets with sheet name as date. Could anyone help me. Many thanks in advance. :))

1 reply Last reply on 19 Jan 2015 by
vcoolio

Corrupt word file - says to use text converter

 Solved

Hello, I have been reading some posts about you to repair a file and it says to use the text converter. I dont see how to use it though. I want to ...

1 reply Last reply on 16 Jan 2015 by
josephcols81

Macro for copying data from different sheets

 Solved/Closed

Hello, I am trying to copy data from different sheets to master sheet under the following criteria 1. Master sheet should be generated when ev...

Last reply on 16 Jan 2015 by
NK

If / and function and date range

I am trying to create a spreadsheet that tracks when jobs commence and complete. I have been working with the IF and AND functions but can't quite see...

3 replies Last reply on 15 Jan 2015 by
Magoo2015

Excel 2007 : conditional formatting issue concerning colors

Dears, I've successfully put a conditional format in my document, but I would like to have the whole row in color in stead of only 1 cell. Does ...

1 reply Last reply on 15 Jan 2015 by
RayH

Useing (='sheet'!cell) if the sheet name is depending on cell

Hello, how to use (='sheetname'!targetcell) if the sheetname is in cell A2(sheet1) and the target is C3 ='sheet1'!C3 is working, but the sheet ...

1 reply Last reply on 15 Jan 2015 by
RayH

Trying to sum a column that contains various text

 Solved

I'm a novice when it comes to excel and I'm hoping someone can help me with a formula. I'm trying to give a value to various text in columns and then ...

3 replies Last reply on 15 Jan 2015 by
chris82675

Trying to add a value if a test result is positive or negative

Hello, I have been asked to build a spreadsheet to calculate patients follow up depending on their blood test result. I will only know if the ...

1 reply Last reply on 15 Jan 2015 by
vcoolio

Excel query urgent please.

 Solved

Hello, I have the below data in sheet 1, where as in column A its the activity and column b its the name of person who has done it. and the names ...

11 replies Last reply on 15 Jan 2015 by
wasey

Is there a formula for this issue? thank you in advance

Hello, Please help, the issue goes like this, I want to find a NAME within a RANGE of CELLS and the result would be the LATEST DATE they have i...

1 reply Last reply on 14 Jan 2015 by
RayH

Excel list item automatically generates a new list

Hi! Hoping someone can help ;D In Cell A1 there is a list called "clothing" (a drop down box). In the list you can choose "T-shirt" or "Sweats...

1 reply Last reply on 14 Jan 2015 by
RayH

Conditional formatting comparing dates

I have two columns, that each have dates in them. I want to take Column A, subtract 100 days, then compare it to Column B. If Column B is less than C...

1 reply Last reply on 14 Jan 2015 by
RayH

Auto filter based on cell value

Hello, I have a huge database and ever growing. I need to filter based on a cell value Summary!C2 this value is selected from a drop down list....

3 replies Last reply on 13 Jan 2015 by
IzakG

Calculation of number of months

Hello, number of months between 1/7/2013 and 26/1/2015 Configuration: Mac OS X Lion (10.7.5) / Chrome 39.0.2171.95

1 reply Last reply on 13 Jan 2015 by
RayH

Excel file do not open normally.

I have Office 2010 and Windows 7. I have one Excel file which has very abnormal behavior. First I opened it, drafted it a little, then closed. Next da...

1 reply Last reply on 13 Jan 2015 by
kieferschild

Trying to set up a payroll system for 1 or 2 casual employees

I'm trying to set up a payroll system for 1 or 2 casual employees. Most forums recommend a manual system. Can excel add up a year to date column acros...

1 reply Last reply on 13 Jan 2015 by
vcoolio

Copy select columns from a row given a criteria was met

I have been working for quite a while on a spread sheet for a productivity tracker. I have tried to copy and past several codes and editing them, but ...

1 reply Last reply on 13 Jan 2015 by
vcoolio

2 list matching

i have 2 lists: LIST 1 A1 B1 sku1 4.50 sku2 5.00 sku3 6.50 sku4 2.25 sku5 1.25 need to enter/match these B1 values into a similar, but n...

1 reply Last reply on 13 Jan 2015 by
venkat1926

Want cells to show e.g. £100.00 when there is a value

Hello, I'm using Excel 2007 and I want cells to show e.g. £100.00 when there is a value but when there is no value I want the cell to show nothing...

1 reply Last reply on 12 Jan 2015 by
RayH

Time differentials

HELP!!! I have 4 columns and need to figure out the hour differentials Column A has a Date (1/3/15) Column B has a Time (9:00am) then Column...

5 replies Last reply on 12 Jan 2015 by
RayH

Vba to copy/paste rows by client name to different spreadsheet

Afternoon, I am new at VBA programming. I have tried sub copyrange and if/then with limited success. I have a master worksheet and individual work...

1 reply Last reply on 11 Jan 2015 by
vcoolio

Data transffering

Good Morning. I am new to the forum thing so any help would be great. I am not sure if this is possible but I am looking to see if I can automatical...

2 replies Last reply on 10 Jan 2015 by
vcoolio

Copy values from a table to another tab

Hello, I have an excel spreadsheet. How can I copy values from a table to another tab by placing an "x" in the right column. I only want th...

1 reply Last reply on 10 Jan 2015 by
vcoolio

Get max value

Col A Col B Col C Row 1 A A 110 Row 2 A A 200 Row 3 C C 199 Row 4 A A 92 Row 5 C C 85 Row 6 D D 172 Row 7 D D 150 Row 8 E E 177 Row 9 E E 199...

5 replies Last reply on 9 Jan 2015 by
RayH

Copying unlimited data from on excel to another excel..

Hi All, I want to copy all the data from one excel sheet to another excel on load event (when I open) of destination excel. could you please hel...

5 replies Last reply on 9 Jan 2015 by
vcoolio

Setting due dates

I already have half of the formula needed.. d2=text, leave it blank =if(istext(D2),"","") I need a formula for this: d2=date, then add 14 day...

4 replies Last reply on 8 Jan 2015 by
jirinetmelissa

Looking at one cell if contains number returning text...

Hello, I am trying to figure out a way to streamline a huge excel spreadsheet we have at work. I am trying to return text in a cell if there is...

1 reply Last reply on 8 Jan 2015 by
ac3mark

Copy across conditional formats

Hello All ok I have 20 colomns of data the first 2 rows contain the upper and lower limits(all of which are different) the following 3 rows ...

1 reply Last reply on 8 Jan 2015 by
TrowaD

Compare two sheets based on a common id in both sheets in col a

 Solved

Greetings Kioskea team, First of all, my heartiest congratulations and thank you to the great Kioskea team that who have a mine of excellent solut...

8 replies Last reply on 8 Jan 2015 by
Ajay Dwivedi

Vlookup for mutiple shel

Hi , I have requirement as below There is excel sheet 1 with column A with some text say xxx, yyy , xyz and coresponding numeric values in colum...

4 replies Last reply on 8 Jan 2015 by
Karthikeyan1207

Vba to assign a counter to a constant

Can somebody provide me the VBA code for the following samples Before VBA code A B B A C A C A After VBA code 1A 1B 2B 2A 1C 3A 2C 4...

1 reply Last reply on 7 Jan 2015 by
RayH
Results 3401 - 3450 out of a total of 12,266