Excel Forum
-
Referencing cells in Excel with functions [Closed]
Hello I am trying to write my own Lottery Program in Excel. On the first worksheet I have all of the numbers (1 through 59) in a column and to the...
-
EXCELL [Closed]
Hello, i have 14 names i want to assign a number value to, like 1 thru 14 and when i input a number in a colum row the name appears in that cell. say...
-
excel formula help [Closed]
Hello, I want to add a column of numbers (only cells that contain data, there will be some that will be blank and then I want to get the percentage o...
-
Macro Code [Closed]
Hello, I want to write such a macro that if i click the button. if their are 50 sheet in work book and i want to copy paste all the sheets into one ...
-
comparison between two excel sheet [Solved/Closed]
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...
-
need excell hel[p [Closed]
Hello, i have an excell book open with multipule sheets. the 1st sheet has all the master info, the other sheets are cells for production. on the ma...
-
help! new to excell [Closed]
Hello, i have an excell spread sheet with multipule sheets open. i need to select certain rows of information, copy the info and tell that informatio...
-
How to have Mixed References in Macros [Closed]
Hi - Newbie here.. (can hear the groans already :-) I am trying to use a macro to copy a set of cells. I have successfuly created a macro - the...
-
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...
