Excel Forum
-
Excell Solved/Closed
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...
-
Linking Excel Data to Excel-Based Calendar Closed
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 Closed
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 Closed
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 Closed
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 Solved/Closed
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...
-
Excel: use if to find & change text in column Solved/Closed
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...
-
Removing Data from a worksheet Closed
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 Solved/Closed
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 ...
-
Excel Movement Closed
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 Closed
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 Closed
Hello, Why does Excel change my dates when I sort the date column?
-
help pls some one hijacked my internet browse Closed
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 Closed
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 Solved/Closed
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 ...
-
excel Closed
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 Closed
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 Closed
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 Solved/Closed
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...
-
Help with Macros in Excel Closed
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 Closed
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 Closed
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. Closed
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 Closed
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 Solved/Closed
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...
-
Excel Based Contract look up and fill in Closed
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 Solved/Closed
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...
-
EXCEL 97 if then Solved/Closed
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...
-
Excel / after print +1 Solved/Closed
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...
-
Excel - dependant copying / summary sheet Closed
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 Closed
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 Solved/Closed
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...
-
comparing cells and in multiple columns Solved/Closed
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...
-
Update two different spreadsheets from one ma Closed
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 Solved/Closed
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...
-
sum the values 100s sheet in a sheet Closed
Hello, i want to know to apply the formula to sum 100 sheets in one sheet
-
Excel "IF" formula problem Solved/Closed
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...
-
Figuring percentages in Excel Solved/Closed
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...
-
extract top 10 records from a sheet Closed
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 Closed
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 Solved/Closed
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 - ...
-
excel formula drag Closed
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 Solved/Closed
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...
-
update dates in excel spreadsheet each year Solved/Closed
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...
-
Comparing data in two columns for matches Closed
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 Solved/Closed
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...
-
changing default date format in excell Closed
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 Closed
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 Closed
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 Closed
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...