The discussions

Linking spreadsheets

 Solved

Hello, I'm trying to set up a cell that will draw information from another spreadsheet using excel 2007 The spreadsheet I'm pulling the info fro...

Last reply on 13 Feb 2010 by
rizvisa1

Copy rows to total page

 Solved

Hello, I have an Excel spreadsheet with 13 worksheets. The first 12 worksheets are January through December. The 13th worksheet is a total. Each...

Last reply on 12 Feb 2010 by
rizvisa1

Creating a directional macro

 Solved

Hello, I am not familiar with writing macros at all. I created a form and I need a macro so that when I input data in a cell the cursor will automat...

Last reply on 12 Feb 2010 by
Teene12

Conditional formatting or if using dates

 Solved

Hello, I am trying to change the colour of an entire row to 3 different states depending on the result. The row needs to stay clear if the date ...

Last reply on 12 Feb 2010 by
rizvisa1

Formate date to term or warranty period

 Solved

Hello, I have Purchase date and expiration date in a format of yyyy/mm/dd. I want to get the term of how long will it take from purchase date to e...

Last reply on 12 Feb 2010 by
aquarelle

Excel - delete rows when alike

 Solved

Hello, I am in need of a formula to solve this problem. I want it to find similiar cells and delete those cells from the worksheet. Here is a sa...

Last reply on 11 Feb 2010 by
rizvisa1

Network days

 Solved

Hello, I am trying to run the network formula days using the below formate as teh date, clearly this doesnt work anyway I can adapt this suit or anyw...

Last reply on 11 Feb 2010 by
jay

Subtract a date/time

 Solved

Hello, Can anyone help me with a formula in excel 2007 to subtract eg 11/01/2010 5:12 AM from 15/01/2010 7:30 PM. Thanks

Last reply on 11 Feb 2010 by
rizvisa1

How to create macro to search, copy, & paste

 Solved

Hello, Here's what I want to do. I have a worksheet with customer data by row and I also have a worksheet with an invoice I want to auto populate w...

Last reply on 10 Feb 2010 by
rizvisa1

Comparison between two excel sheet

 Solved

Hello, i have two excel sheet with same value which i need to compare every day .with in same excel sheet i can compare easyly using conditional form...

Last reply on 10 Feb 2010 by
tiffy

Compare two lists and change row colour

 Solved

Hello, I have two different workbooks, lets say workbook 1 and workbook2. In both workbooks i have a column with barcodes. I need a vba to check ...

Last reply on 9 Feb 2010 by
venkat1926

Excell

 Solved

Hello, I need a formula that will take the sum of a group of cells from a worksheet and apply them to a specific place on another worksheet. All i...

Last reply on 9 Feb 2010 by
rizvisa1

Ms frontpage

 Solved

Hello, I can not find ms frontpage, I have clicked form start menu ==> all program ==> ms frontpage is nothing. How to add this ms frontpage & whe...

Last reply on 9 Feb 2010 by
tw

Help with interface/msgbox in vba

 Solved

Hi, I'm in a VBA course and I'm having a lot of trouble with one of the problems: The settling velocity of a particle of liquid can be estimated us...

Last reply on 9 Feb 2010 by
venkat1926

Excel: use if to find & change text in column

 Solved

Hello, i want to search column "a" with numbers as text as follows: #305 #777 #78 #82 #884 i need a formula that will search column A an...

Last reply on 9 Feb 2010 by
venkat1926

Excel macro programming

 Solved

Hello, It's been a while since I last wrote my own macro and I can't remember how to do this one up. I have a pull down list in excel, using data ...

Last reply on 8 Feb 2010 by
venkat1926

Date formating in letters using mailmerg

 Solved

Hello, I use mailmerg in Microsoftword to format various letters. data is imported from an excel sheet and letters are formatted in Microsoftword. No...

Last reply on 8 Feb 2010 by
seekermay

Ranking on exel

 Solved

Hello, In exel i know its possible to rank data, but im stuck on how to do this: Say i have the following data: Activities: 16...

Last reply on 7 Feb 2010 by
venkat1926

Macros excel 2004 problem

 Solved

Hello, guys i please need help with this problem...i have macros that i use daily, i recently got a mac and i have mac office 2004, i try to copy and ...

Last reply on 5 Feb 2010 by
rizvisa1

Macros to sort data with respect to the colum

 Solved

Hello, I am facing a problem in sorting the data w.r.t to column header. I have 25 columns in which i need to sort the sata w.r.t to two of the col...

Last reply on 5 Feb 2010 by
rizvisa1

Exel how to find max

 Solved

Hello, On exel i know its possible to get the computer to find the MAX value from a set of numbers, but in my case i want it to find the max value but...

Last reply on 5 Feb 2010 by
LJS

Extract a specific data from a cell

 Solved

Hello, I have a column of data in text format in excel, that has a persons name, date and time. I am only interested in one person's name, date and ...

Last reply on 5 Feb 2010 by
picachoo

Return zero in cell that contains a function

 Solved

Hello, need to return zero within a cell when the cell contains a function already: I have this function already, but cannot paste the function...

Last reply on 3 Feb 2010 by
rizvisa1

Excel macro to scan document and combine rows

 Solved

Hello, I'm trying to write a Macro that will combine text from several rows in a given column (column B in the example below) into one cell as long...

Last reply on 2 Feb 2010 by
rizvisa1

Values lookup in excel

 Solved

Hello, i want to match sheet2 with sheet1 WHERE sheet1 is the master sheet and has all columns. sheet2 has only two columns as in below demonstrat...

Last reply on 2 Feb 2010 by
seekermay

Excel 97 if then

 Solved

Hello, I would like a Cell "1" to look at two Cells, Cell "2" and Cell "3" and depending on the answer enter a positive or negative vaue of Cell "4...

Last reply on 2 Feb 2010 by
rizvisa1

Splitting values of cell

 Solved

Hello, My question relates to trying to place a value of one cell separately elsewhere in the speadsheet but broken down into two cells (if needed)...

Last reply on 2 Feb 2010 by
Meltom

Excel / after print +1

 Solved

Hello, My name is David (form Slovakia)! I would like to ask you for help with the folowing situation to solve: I need to prepear one document wh...

Last reply on 2 Feb 2010 by
rizvisa1

Excel 2007 no value= no color

 Solved

Hello, I've conditionally formated multiple cells to highlight green when the inputted date is within a 2 year period and red if it exceeds 2 years...

Last reply on 1 Feb 2010 by
out o' ideas

Comparing cells and in multiple columns

 Solved

Hello, I have two columns A and B A has items that have been priced B has items price (no dollar sign) Is it possible to have a macro go down co...

Last reply on 1 Feb 2010 by
rizvisa1

Comparing value to master coloumn

 Solved

Hello, I am basic excel user. I have issue where i need to compare value from master table and show in the sheet. Below is the actual example. The Sh...

Last reply on 1 Feb 2010 by
rizvisa1

Excel macro-highlight if difference > or < 2

 Solved

Hello, I need help writing an Accounting excel macro I am working on. It appears that everything is working fine, except for one part I need some h...

Last reply on 30 Jan 2010 by
venkat1926

Excel "if" formula problem

 Solved

Hello, I have a row of 4 cells each containing an "if formula" to get information from another worksheet. An example of the formula in these cells i...

Last reply on 29 Jan 2010 by
rizvisa1

Figuring percentages in excel

 Solved

Hello, we are doing a weight loss contest and trying to figure out a formula to do the math. We need a formula that will figure the cumulative pounds...

Last reply on 29 Jan 2010 by
rizvisa1

Marco help! one macro for multiple row tasks

 Solved

Hello, I have two separate workbooks that I need to compare. Task at hand is I have to find specific text in workbook 2 (col A) and once found - ...

Last reply on 29 Jan 2010 by
rizvisa1

Unique text formula question in excel

 Solved

Hello, I have 2 columns of names in columns a & b and a list of dates in column c. Column A has a unique name in each cell. Column B had the same 5 o...

Last reply on 29 Jan 2010 by
RIZVISA1

Update dates in excel spreadsheet each year

 Solved

Hello, i have 4 spreadsheets linked together which i use to keep track of my accounts. all 4 spreadsheets are in one folder. On each spreadshee...

Last reply on 29 Jan 2010 by
oclaf

To add row after 24 rows and get the sum

 Solved

Hello, I have hourly data of one year in rows without any break. I want to add row after 24 hrs and get the sum of all the coumns in that row. In oth...

Last reply on 29 Jan 2010 by
RIZVISA1

Greater than 0 & less than 30

 Solved

Hello, i need the formula of this quotation: B2 Is Input Value Cell D2 Is Formula Cell If Cell B2 Is Greater Than 0 & Less Than 31, Than For...

Last reply on 29 Jan 2010 by
Game Start Now

Count number of days between two entries?

 Solved

I have an Excel workbook with daily entries of my lunch and dinner meals. On a separate sheet, I'm counting the total number of occurrences of each me...

Last reply on 28 Jan 2010 by
venkat1926

Find and return a specific number

 Solved

Hello, I am trying to find out how to display a specific number. I have 3 columns, each showing a results from a test as follows: 3 =fail ...

Last reply on 27 Jan 2010 by
venkat1926

Connecting outlook with gmail

 Solved

Hello, plz suggest a way to synchronize my gmail account with outlook thanku

Last reply on 27 Jan 2010 by
alexi

Sum column if date (year) is greater than 09

 Solved

Hello, Hi I'm trying to calculate 2 column if the date is greater than 2009 in Column A Column B Column C 5/31/2009 ...

Last reply on 26 Jan 2010 by
joanie

Cell reference

 Solved

Hello, I need a formula that can check a specific value in a range of values and show the cell location for each time the value is find Suppose we...

Last reply on 25 Jan 2010 by
venkat1926

Format nard drive

 Solved

Hello, i want to clear my hard drive and then relaod win xp, i have no real idea where to start and what i should save first ect ??? can anyone advi...

Last reply on 23 Jan 2010 by
dancedhall

Delete all rows except first and last row

 Solved

Hello, I have an excel file, I need to delete all rows in this file except for the first and second row. First Row = header row last row = contai...

Last reply on 18 Jan 2010 by
fairbud

Formula or else ???

 Solved

Hello, I have a range of cells B5:AC5 containing each a letter from a name, ex: DAVID THOMAS SMITH So B5=D, C5=A, D5=V, E5=I, F5=D..and so on up to ...

Last reply on 14 Jan 2010 by
tompols

Need to sum coumn f only when b & c identical

 Solved

Hello, I am trying to set up a formula that will allow me to get the average of values in F, but only for the rows where both Coumn B & C are identic...

Last reply on 14 Jan 2010 by
tompols

If x is between a and b, then c

 Solved

Hello, Worksheet 1 Jan 10 Jan 12 Jan 12 10am Jan 13 Jan 15 Jan 16 9am Worksheet 2 Jan 11 I'm having trouble coming up wi...

Last reply on 13 Jan 2010 by
tompols

Excel help

 Solved

Dear All, I really need your support with my issue: I have around 70 tasks in Sheet1 some of them done with 100% (according to other numbers in th...

Last reply on 12 Jan 2010 by
Omoor
Results 2451 - 2500 out of a total of 2,609