The discussions
Simple macro error help
SolvedHello, I am using Excel 2007 on Windows XP I am trying to write my first macro that will simply place the following formula into a cell. The ...
Deleteing rows in excel
SolvedHello, I work with a lot of files every day and the number of data in column A is different from the rest of the column. The number of data ar...
Display yes where data is present in excel
Hello, In excel, how can I get column W to show "Yes" in red, if there is data is column L. Please share... :) Thanks in advance
Match 2 columns of data and delete duplicates
Hello, I have 2 worksheets with data that needs to be eliminated on sheet 1. Sheet 1 column M contains a random list of numbers Sheet 2 column A...
Copy selected table rows to different table
Hello, I am failing at copying selected rows from sheet1's "ActiveItems" table to sheet2's "HistoryItems" table. The copy works fine if "HistoryI...
Merge 400 cells of data into one.
Hello, I need to know how to combine the data in a column into a single cell, with the results being separated by a semi-colon and a space after t...
Excel comparison of partial or wild card data
SolvedHello, I have two columns in Excel that I want to compare. The data in work sheet 1, column A has values that are tabbed. This data has the adjac...
Sheet-1 + sheet-2
SolvedHello, i have a problem plz solve it and tell me solution i want to count some cells which are Sheet-1 and in Sheet-2. Example: (Sheet-1) A1+A...
Repeating macros
Hello, Does anyone know how to repeat a macros? I have recorded the following command as a macro in Excel (2007), but I would like the task...
Counting in excel
SolvedHello, In the U column shows "Good" and "Bad" answer that resulted from a formual that I used. How can I count the the toal number of Good a...
Excel help with what if
SolvedHello, I have all the states in column A and I need to result to display in column B. I need Column B to show "Yes" if column A has: MT, ID, ...
Conditional formatting (more than 3) in excel
Solved/ClosedHello, i am trying to apply more than three options to excel that changes the background colour of the cell. my range is R7:R1000 i need a VBA ...
Run a macro in multiple selected columns
Hello, i have a macro to fill in blanks. Is it possible to run it for multiple columns at the the same time. Thanks Configuration: Windows X...
Checking cells for data, then ....
Hello, hi i'm having a bit of trouble with something in vba and have tried searching but its complicated and i cant seem to find anything on it. ...
Excel macro help
Hello, I need to Open an .txt file & then copy the contents of .txt file into word Macro and run it. I need to do this for many .txt file C...
Need help with macro 2007
Hello, College_Cost() Dim Tuition As Currency Dim Room_and_Board As Currency Dim Miscellaneous_Expenses As Currency Tuition = InputBox("EnterT...
Extracting excel data into new file
Hello, I have an Excel like below. Project Code, Site, Donor and Partner are the heading. Project Code Site Donor Partner E...
Excel matching formula
Hello, i am not an expert excel user and i figured what im trying to do is pretty basic. I have data in 2 columns and the result column. I wanted ...
Excel formula help
Hello, I'm trying to create an excel formula to say the following, but can't seem to figure out how to write this formula out. IF ((A*B)35000)...
Comparing data in multiple spread sheets...
Hello, Kindly help me with this. Your help is appreciative. I have one column in worksheet1 and two columns in worksheet2, and two columns in ...
Excel: if then question
Hello, I've got 2 questions. First one is I have an if statement look like this but something is wrong: =IF(C31>400), C31*0.8, C31*0.9 And i...
Excel question
SolvedHello, I have one worksheet with with all of my emails (both good and bad) D2:D3843 and another worksheet A2:A1061 with all good emails and I need...
Help so lost with the excel =look up
Hi So i got my Stock codes in cell A2-999 and in cell C2-999 all my new prices(with updated prices) and my old list in A2-999(sheet 2)in decending...
Excel color coding
Hello, I am working on a problem that I can't fix. I want to type in a cell a date like say 12/01/2012. Then 30 days before this date I want it ...
Count the time in excel columns
Hello, I have a requirement, in a column the time is displayed as below, now i need for the date 10/9/2010 i need the count of B2 for every one ho...
Class result in excel
SolvedHello, I have worksheet of class result.In column A there are names of students. In column B i have marks. I want a formula which tell me the name...
Moving column into rows
Hi I'm preparing weekly sales report on category sold per shoping chart. There are 100 categories (Category will be header) and all the data extr...
No browsers working after removal of virus.
SolvedI've tried chrome, Ie, opera, and firefox. I've recently had a virus and it was removed, but I think it damaged some stuff. I used malwarebytes and su...
Excel =if?
Im trying to put a =IF function in one cell to refer to another cell. After that i want it to post the results in yet another cell. If that makes sens...
Comparing colums in multiple spread sheets...
Hello, Kindly help me with this by giving me hint on VBA code. Your help is appreciative. I have one columns in worksheet1 and two column ...
Dividing excel rows into appropriate columns
Hi, I could really use help on the following with my Excel 2007 file-- I have huge excel files that need to be rearranged into proper format. Current...
Excel find a value delete rows until any valu
Hi Can any help me please? I am an Excel Macro virgin and this site seems brilliant! I am trying to: -find a value (PPA Pre-Checkpoint4) in a...
Del first row of text out of two rows in cell
Hello, I am in a great problem and my boss has given me a assignment with lots of worksheets of excel. These worksheets has lots of cells in it. T...
Looking for help in excel
Hello, I am looking for help in excel, A1-A10 has few names and B1-B20 has some names as well, is it possible that A1-A10 looks into B1-B20 and if...
Counting between dates using excel
Hello, How do I count days between two dates with out using networkings which include working days non working days and holidays
Excel2007 advanced copying into blank row
Hello, I used a macro to insert blank rows into my spreadsheet. Now I need to copy the exact same numbers into the blank rows and add the letter A to ...
Rearrange data in excel
Hi, I have a spread sheet of data that's imported from an xml file that I need to re-arrange. Ex: A B C D apple 1 yellow sweet apple 2 red sweet...
Excel - advanced formula help
Hi, I am trying to come up with (find) a formula in Excel 2007 that will allow me to affect either "cell2" or "cell3" depending on the value of "ce...
Copying cells conditionally in excel
hi i was wondering if anybody could help me. i'm making this excel workbook oriented to chemistry students to illustrate surface tension. what i need...
Duplicate emails in two columns
SolvedHello, I have two rows of approximately 2000 email addresses, One from our Accounts package database, another from our website database. Can anyon...
Finding duplicates/triplicates excel
Hello, Please can anyone help?? I have a huge spreadsheet!! I have data in column A, B and C and the data is mad up of multiple spreadsheets brough...
Please help with comparing columns!
Hello, I have an excel worksheet that has two columns of information that I need to compare. For example, If any of the values in column b = a va...
Copy rows from another excel-file
SolvedHello, I have two Excel files, one containing data and one blank. I'm creating a macro in blank Excel to copy certain rows from the data-Excel. I ...
.csv files into multiple sheets in one file
Hello, I have a set of .csv files (reports generated in mainframe) which I want to put into one file, one sheet pr. csv-file (report). Is that po...
Result sheet
ClosedHello, i am having a problem to make a result for student. for example if a student getting 25 marks in a paper he or she is passing in that s...
Excel formula help required.
SolvedHello, I am looking for some kind of formula that can achieve the following. i have a cell which allows a user to enter any number. i want ex...
Creating an excel vba code
Hello, Can you help please, I'm trying to create Excel VBA code to allow me to copy a variable range from sheet "Breakdown", Col B, select sheet "...
Move data from one sheet to another with argu
Hello, What I have is a sheet in excel 07. It's set up to track bags of different fertilizers on my yard, and how many, and cost. sheet1 looks like ...
Single item reporting from multiple sheets
Hello, Good day! I am a newbie in the world of visual basic programming in excel. My problem is my boss wants an automated summary...
