The discussions

Excel user forms

Hello, I have created excel project database using excel Userforms. First request form capture the customer inputs and store in Request_database sh...

1 reply Last reply on 9 Feb 2010 by
rizvisa1

Excel help

Hello, I have two excel files in different path. Every week I have to copy the data from daily excel file to weekly excel file. Is there any formul...

1 reply Last reply on 9 Feb 2010 by
rizvisa1

Excel if & then

Hello, I wanted to know that, in Excel 2007, what is the formulae if Cell B12 has a drop down list of 3 range and if we select a particular range the...

1 reply Last reply on 9 Feb 2010 by
rizvisa1

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

Removing data from a worksheet

Hello, I am wondering if anyone has a code for this problem. It may be simple for someone who knows VB well. I have large datasets collected over...

14 replies Last reply on 8 Feb 2010 by
Pram

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

Excel movement

Hello, I have a workbook that has 10 different sheets in it. In this the first sheet in "total information", then "sheet1",..."sheet9". It has column...

1 reply Last reply on 8 Feb 2010 by
venkat1926

Sheet name not equal to "name" & &qu

Hello, I Need A Macro Formula That If Those Sheets Who's Name Is Not Equals To "Name" & "Letter" Will Be Deleted. If There Is No Sheet Except "Nam...

1 reply Last reply on 7 Feb 2010 by
Game Start Now

Excel is changing my dates

Hello, Why does Excel change my dates when I sort the date column?

2 replies Last reply on 6 Feb 2010 by
tj

Help pls some one hijacked my internet browse

Hello, well my internet works all of my msn/aim is fine but i cannt go on any sites. it just doesnt allow me to visit any sites. i've tried evryt...

1 reply Last reply on 6 Feb 2010 by
ash_perez01

Deleting rows in excel based on condition

Hello, I am in need of assistance in creating an excel macro which will delete rows that do NOT equal a number combination. (The number combination ...

1 reply Last reply on 5 Feb 2010 by
rizvisa1

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

Excel

Hello, I have cells with the time of the emp who have punched the time they have come to the office. I need to find the late comers. The values ...

3 replies Last reply on 5 Feb 2010 by
rizvisa1

Glo browser

Hello, my mail babsyn2002@yahoo.com...............i need to brwse wiyh my glo pls hw can i do it my project is on pls

1 reply Last reply on 5 Feb 2010 by
ash_perez01

Internet browsing

Hello, I am having a LG KP500 mobile which is worth of Rs 8500, I just want to connect my mobile to my PC for browsing.Could u please tell me the pro...

1 reply Last reply on 5 Feb 2010 by
ash_perez01

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

Help with macros in excel

Hi, This is my first my first post and I am hoping that somene can help me. I am very new to macros etc. I have the need to create two macros in ...

4 replies Last reply on 5 Feb 2010 by
rizvisa1

Excel 2007

Hello, I have a list of 8500 names and I want a formula that can identify the cells where the names are the same. I do not have a list of known names ...

11 replies Last reply on 4 Feb 2010 by
rizvisa1

Excel date issue

Hello, I have an Excel report that was created a while ago, inherited and now I am trying to make it easier to get the data. The issue I'm having i...

1 reply Last reply on 4 Feb 2010 by
rizvisa1

Browser not open the webpage.

Hello, I am using hp laptop. In my building wifi is available. My friend's laptop is connecting with the wifi and working properly.My lap is also con...

1 reply Last reply on 3 Feb 2010 by
suff954

How to copy all excel sheets to another excel

Hello, I have production data records for a year i.e 52 weeks I have 52 Excel files containing 5 sheets in each Excel file (5 sheets have diff. ...

1 reply Last reply on 2 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

Excel based contract look up and fill in

Hello, This is probably very easy for an Excel wiz...I have to fill out union contracts - similar to a worksheet - and have an Excel database of info...

3 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

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 - dependant copying / summary sheet

Hello, I want to set up a monthly sheet that records items in a table, first columm of table (A1) is headed completed, B1 is Date, C1 is item then fo...

4 replies Last reply on 2 Feb 2010 by
rizvisa1

Excel

Hello, I need to colour code one cell as a result of many for a risk assessment thus if the multiple cells equate to less than a figure, a certa...

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

Update two different spreadsheets from one ma

Hello, I need to update two completely different spreadsheets from one master spreadsheet in Excel. How do I accomplish this? Please help. Thanx i...

8 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

Sum the values 100s sheet in a sheet

Hello, i want to know to apply the formula to sum 100 sheets in one sheet

1 reply Last reply on 30 Jan 2010 by
deepbreathe

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

Extract top 10 records from a sheet

Hello, actually i have a sheet where no. of records, i want to sort top 10 or 50 records from it on another sheet, if i have changed the original rec...

1 reply Last reply on 29 Jan 2010 by
rizvisa1

Excel question

Hello, I am trying to create a form based on the last row of information on a separate worksheet. I would like for this form to automatically update...

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

Excel formula drag

Hello, ok i need to drag a formula down however i want one value in the formula to change one one not to. for example: c1=a1+b1 c2=a2+b1 c3=a3...

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

Comparing data in two columns for matches

Hello, I am lookin for a formula that can compare two columns of data to see if they match. For example: A B C 1 3 NO 5 5...

1 reply Last reply on 29 Jan 2010 by
rizvisa1

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

Changing default date format in excell

Hello, how to change the default date format. I have year/month/date as default and I want to change this to day/month/year

1 reply Last reply on 28 Jan 2010 by
deepbreathe

Comparesion two two work sheet

Hello, I am trying to find an easy way to compare and extract data from two excel worksheets

1 reply Last reply on 27 Jan 2010 by
venkat1926

Please help mo to solve my problem in excel

Iwant to get the total of this column B-----C ACFT CHECK TVP B777 A B747 B B777 A B777 A B777 A B747 B B747 A i want to get the total of B...

1 reply Last reply on 27 Jan 2010 by
Irfan Khan

Conditional formatting in excel

Hello, I am trying to incorporate a little checker into my spreadsheet. I basically have a table of numbers and I would like them to be coloured...

3 replies Last reply on 26 Jan 2010 by
Trowa

Problem with browsers

Hello, my friends i have problem with my laptop since a week ago i am not able to open some websites and some games in facebook is it the browsers p...

1 reply Last reply on 26 Jan 2010 by
dist.urbd

Excel - if then statements

Hello, I have 8 columns total and want to create a if then statement for the sum of column D IF in column A contain a + for that row. Almost lik...

1 reply Last reply on 25 Jan 2010 by
Trowa
Results 6201 - 6250 out of a total of 7,064