The discussions
Excell
SolvedHello, 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...
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...
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...
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...
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...
Help with interface/msgbox in vba
SolvedHi, 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...
Excel: use if to find & change text in column
SolvedHello, 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...
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...
Excel macro programming
SolvedHello, 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 ...
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...
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...
Excel is changing my dates
Hello, Why does Excel change my dates when I sort the date column?
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...
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 ...
Macros excel 2004 problem
SolvedHello, 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 ...
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 ...
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
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...
Macros to sort data with respect to the colum
SolvedHello, 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...
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 ...
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 ...
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...
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...
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. ...
Excel macro to scan document and combine rows
SolvedHello, 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...
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...
Values lookup in excel
SolvedHello, 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...
Excel 97 if then
SolvedHello, 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...
Excel / after print +1
SolvedHello, 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...
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...
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...
Excel 2007 no value= no color
SolvedHello, 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...
Comparing cells and in multiple columns
SolvedHello, 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...
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...
Excel macro-highlight if difference > or < 2
SolvedHello, 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...
Sum the values 100s sheet in a sheet
Hello, i want to know to apply the formula to sum 100 sheets in one sheet
Excel "if" formula problem
SolvedHello, 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...
Figuring percentages in excel
SolvedHello, 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...
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...
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...
Marco help! one macro for multiple row tasks
SolvedHello, 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 - ...
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...
Unique text formula question in excel
SolvedHello, 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...
Update dates in excel spreadsheet each year
SolvedHello, 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...
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...
To add row after 24 rows and get the sum
SolvedHello, 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...
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
Comparesion two two work sheet
Hello, I am trying to find an easy way to compare and extract data from two excel worksheets
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...
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...
