The discussions

Linking excel data to excel-based calendar

Hello, Okay, here I go. I have a workbook which contains a tab (CalendarData) with information as follows: Column A - Name Column B - Apt # C...

Last reply on 9 Feb 2010 by
rizvisa1

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Sum the values 100s sheet in a sheet

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Last reply on 26 Jan 2010 by
dist.urbd
Results 6201 - 6250 out of a total of 7,065