The discussions

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...

3 replies 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...

7 replies 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 ...

5 replies 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...

1 reply 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...

1 reply 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...

7 replies 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

1 reply 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...

3 replies 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...

2 replies 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 ...

1 reply 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...

12 replies 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...

4 replies 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...

3 replies 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...

1 reply 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 ...

1 reply 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...

3 replies 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...

1 reply 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 ...

3 replies 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...

1 reply 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...

5 replies 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 ...

17 replies 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...

3 replies 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...

6 replies 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...

2 replies 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...

7 replies 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)...

2 replies 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...

1 reply 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...

2 replies 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...

1 reply 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...

11 replies 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...

1 reply 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...

9 replies 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...

1 reply 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 - ...

1 reply 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...

1 reply 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...

4 replies 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...

1 reply 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...

5 replies 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...

1 reply 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 ...

1 reply 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

3 replies 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 ...

1 reply 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...

3 replies 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...

1 reply 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...

2 replies 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 ...

3 replies 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...

21 replies 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...

1 reply 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...

2 replies Last reply on 12 Jan 2010 by
Omoor

Vba code that will find, copy and transpose

 Solved

Hello, I'm looking all around for a VBA code that will: 1 - Search down one column for the word "ADDRESS" 2 - Once "ADDRESS" is found, I need t...

1 reply Last reply on 11 Jan 2010 by
venkat1926
Results 2451 - 2500 out of a total of 2,608