Excel Forum
-
Excel Data - Matching and Sorting [Closed]
Hello, I have 2 spreadsheets, Spreadsheet 1 with names and contact information, and SS 2 with contact information and an ID number. Names are in C...
-
Comparing columns and returning value [Closed]
Hello, I have an spreadsheet where I want to compare values between two columns and return the value from the relating row in a third column. If A...
-
Macro to find and copy cells [Closed]
Hello, I have never wrote a macro using VB I normally just do simple ones step by step, could you please tell me how to do one that finds the cells ...
-
excel 2010 absolute reference [Closed]
Hello, Hi, I'm trying to copy a forumula using the $ absolute referencing. My column is as follows: Jan =$c46 Feb =$D46 Mar =$E46 etc ...
-
Copy a row to another sheet with conditions [Closed]
Hello, I am very new with coding in excel. I have a sheet called AFF with rows containing different information. If a cell in column Q is not e...
-
Excel macro selecting column [Closed]
Hello, I need to select a specific column relative to the active cell in a macro. Specifically, regardless of the Active cell on a given row, I want...
-
one column multiple rows (data in sets) [Closed]
Hello, I'd be grateful for any suggestions... So what I have is gene A 1 2 3 4 gene B 1 2 3 4 and what I would like is gene...
-
Macro Help In Excel COPY PASTING [Closed]
Hello, I am trying to copy data from a excell spread sheet that is actually a set template i.e. Name:John Doe Age...
-
vba - compare two sheets [Closed]
Hello everybody, I have two sheets: - sheet1 holding 3000 entries of all the guys - sheet2 holding the transferred guys i need a macro that...
-
Excel Data Reading from another Excel Shheet [Solved/Closed]
Dear People, I have a small Requirement in Excel. Can you please help me out? Problem Description: Content of Raw Material Prices are maintai...
-
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...
Subscribe To Our Newsletter!
