Excel Forum
-
using functions in excel, match, vlockup Closed
Hello, I have two columns with numbers and i need to find the numbers in 1st column that apear in 2nd and vice versa. But my problem is next: when...
-
"">[no.]=true & ""<[no.]=false in excel ???? Closed
Hello, as the title says why excel treats same kind of formula in 2 different ways??? thanx
-
percentage formula for microsoft excel Closed
Hello, Im looking for help regarding a pricing sheet im trying to create on excel.I have my list of costs ok where im adding the totals in the cells ...
-
Identifiying data that does not match inExcel Closed
HI There, I have two columns in excel, I would like to verify that the information in Column A, is the same as in Column B, and if not I would lik to...
-
Format Cells based on a letter in other cells Closed
Hello, Sorry I'm new at Excel, but here is what I'm trying to do: I'm making a work schedule. 3C through 3AG represent the days of the week. ...
-
lookup problem from excel 2007 Closed
Hello, Just want to seek for assistance about my problem for lookup data.Actually i have data as per below. PO Items Qty 0001 a 2 0001 b 10 ...
-
Excel data Extraction issue Closed
Hello, I have the following issue with data extraction with Excel. I have a list of data (barcodes) dynamically populated - which means that ever...
-
how to compare several columns...? Solved/Closed
Hello, could anyone help me with this. I would like to compare two columns: A B C D Peter 4 John 3 John 3 Peter 5 G...
-
Using Macro for conditional formatting Closed
Hello, Im in desperate need of help!!! I have an excel sheet with a list of employee number,rank,primary schedule, and secondary sched, years of e...
-
How to extract info from csv files to excel Solved/Closed
Hello, I have 74,340 .csv files I need to extract information from Col. A-C & Rows 1-143 into an excel workbook, Sheet1. Every .csv file has diffe...
-
EXCEL VBA macro Closed
The situation is: I have a about 15000 lines of data that needs to be cleansed. I need to change the Item description from e.g Uncleansed = OFFSET...
-
Reg: Excel query Closed
Respected Sir/Madam, This is regarding a query that i have in MsEXCEL. I would like to know is there any formula or script so that i can get the...
-
Transfer data to match on Excel Closed
I have two reports. One is from 2010, the other is from 2011. Within each report is the same information...account numbers, member names, credit sco...
-
Paste to all sheets except some with criteria Solved/Closed
Hi, How can I make a macro paste copied data into some sheets of a worksheet but not other sheets. For example, I have 10 sheets in my worksheet ...
-
Formating a column using macro Solved/Closed
Sir A forum member helped me in writing a macro to copy certain data from sheet one to sheet two. I modified basic macro to suit as per my require...
-
Excel VBA User Form Closed
Hello, I am quite new to Excel VBA and I , desperately, need an expert help. am trying to create a user form that generates customer IDs made of 9 ...
-
Call an excel document to another sheet Closed
Hello, Can any one suggest how to call a separate document(or) a Cell from one excel sheet to another excel sheet. For Example Book 1 got he...
-
Automatically copy from one page to excel Closed
Hello, I want to copy information from one sheet to another regarding the categories. For example if I have airline company name, aircraft type, ...
-
Excell Conditional Formatting Closed
Hello, I have been using conditional formatting to make a cell change colors if a)greater than or b)less than, today's date; however, I don't know...
-
office 2010 excel Solved/Closed
Hello, i am trying to show in cell J2 if the sum of cell I2 is more than 10 to show 10 and if the sum is les than 5 to show 0 have found how to show ...
-
Excel 2010 - IF function with dates Closed
Hello, I am trying to show in cell J2 if the date of cell I2 is between 1/1/2011 (MM/DD/YYYY) and 12/31/2011 to show SS12 and if not between those ...
-
create new worksheet with data Closed
Hello, i have created a workbook, that contains my home income and expenditures. it contain for every month, i want, it create a new worksheet for...
-
When data changes in sheet1 delete row in s2 Closed
Ok, I was able to use Macro to copy row from sheet 1 to sheet 2 with a condition. Now i want to either add to the Macro or create another Macro to de...
-
Data transfer between cells Closed
HELPPP meee!!! :( 1. i desperately need to transfer data between cells within a single EXCEL sheet. 2. on top of that, i need to have the data m...
-
copying data from worksheet 1 to worksheet 2 Solved/Closed
Hello, I am using MS Office Excel 2007 and need to know how to copy a row of data from one worksheet to another worksheet using a criteria from colum...
-
Copy rows based on criteria - VBA Closed
Hi I have about 25000 entries of data that I wish to sort, Angle and time. I want to take them from a complete list in Sheet A to breakdown in Shee...
-
Multiple conditions multiple worksheets VBA Closed
Hello, I've a small macro which I cannot get working. I would like the macro to copy from sheet 1 anything that has the country code 'ITA' and is ...
-
Excel - delete info from a cell found in anot Solved/Closed
Hello, Hello, I need a solution for the following situation: See attached screenshot from my Excel spreadsheet. I would like to know if the...
-
Cut &past data from sheet to shhet depending Solved/Closed
Dears, I'm a novice in M* Excel. Still, for day to day followup purpose, I need a macro and/or appropriate solution that does the following: For...
-
need some help comparing rows from 2 tables Closed
Hello, i have 2 tables... table 1 has sequential serial #s (a) and corresponding prices (b). table 2 has the same serial numbers (a) (used multi...
-
Find and Display Match Text between columns Closed
Hello, I have a work sheet listing Client names in column A and IP for each client in column B. Column C has a list of IPs which I need to match ...
-
Excel help? Closed
Hello, I have a pivot table that lists items I sell at auction. After the auction ends I need to produce invoices to all buyers and I want to wri...
-
HOw to do html tagging in excel Closed
Hello, Guys pls do help me i have one sheet with lots of details in it and for eg in row 1 from cell A1 to A100 has different content but i need t...
-
Deleting Rows with Negative Numbers Closed
Hello, I would like to delete spreasheet rows if column H contains a negative number and the line above it in excel. Please help! Configuration...
-
convert multiple rows and columns to one colu Solved/Closed
Hello, I have some data in excel sheet. Here is the example. 480,000 600,000 720,000 520,000 650,000 780,000 300,000 375,...
-
Excel formula Closed
Hello, I want to set up a formula to send information from one sheet to another in the same workbook. The information in the source worksheet is...
-
2010 Excel Cell Color Changing Closed
Hello, I have a spread sheet that has due dates, I want to change color of cells to reflect time due eg: time of due date red 5 days before due...
-
color code excel cells according to scores Solved/Closed
Hello, How do I color code cells in excel ti turn colors according to scores--such as red (0-69%), yellow 70-89%), green 90-100%)? Thank you, E....
-
Match Excel Columns containing names Closed
Hello, Using Excel 2010 and I have 2 lists - 1 from phpmyadmin with a list of names entered by my users and a second list from my courier company ...
-
Updating 1 excel spread sheet usng 2nd sheet? Closed
Hello, I have 2 excell spread sheets, bothare mailing lists. i woould like to match firstand/or last names from the 2 lists inorder to be able to u...
-
Can i delete text up to a character in excel Solved/Closed
Hello, Is there a way of deleting all the text up to a certain character in excel. i im trying to import a CSV file in to exchange and need it tyding...
-
Excel - Fill column in list based on criteria Closed
Hello, I am trying to fill a column in a list, based on criteria. Example: In Table 1, I configure the criteria: If string contais "aaa" ...
-
compare columns Solved/Closed
Hello, I have a situation like below. Column A Column B Column C A1 1 A2 ...
-
Excel: Match data/copy to another worksheet Closed
Hello, Can someone help me with this please? : ) I'm using 2 worksheets: On 'Tab A' I have: Column A Column B Notification Product Even...
-
Excel-macro to group by column & sum value Solved/Closed
I was searching your web site for an example of how to group two columns and sum two different columns. I found an example under the question "Excel ...
-
Excel macro question Closed
Hi, I was wondering if anyone can help with a macro that would search for a value entered in a dialog box within a number of worksheets and then p...
-
compare two excel sheet Closed
Hello, i want to compare two excel sheets if the row in second sheet is not there in the first sheet i need to copy that row from second sheet...
-
Need support VBA stuff on Excel Closed
Hello, I am nani and i have no experince in VBA scripting now i wanna phase out my self to learn Macros VBA with Excel as my most of the day work ...
-
Data Replication using macro Solved/Closed
Hello Experts, I have a requirement as follows: User data Entry: Column1 Column2 Column3 Colulmn4 TIME JAN FEB MAR INDIA Bangal...
-
Excell help needed Closed
Hello, I have next problem in Excell, I have columns A1, B1, and C1 with data like this: A1 B1 C1 ABCDEF 4444 ...