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...
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...
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 ...
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 ...
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...
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...
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...
Hello, I am trying to copy data from a excell spread sheet that is actually a set template i.e. Name:John Doe Age...
Hello everybody, I have two sheets: - sheet1 holding 3000 entries of all the guys - sheet2 holding the transferred guys i need a macro that...
Dear People, I have a small Requirement in Excel. Can you please help me out? Problem Description: Content of Raw Material Prices are maintai...
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...
Hello, as the title says why excel treats same kind of formula in 2 different ways??? thanx
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 ...
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...
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. ...
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 ...
Hello, I have the following issue with data extraction with Excel. I have a list of data (barcodes) dynamically populated - which means that ever...
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...
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...
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...
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...
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...
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...
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 ...
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...
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 ...
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...
Hello, I want to copy information from one sheet to another regarding the categories. For example if I have airline company name, aircraft type, ...
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...
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 ...
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 ...
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...
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...
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...
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...
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...
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 ...
Hello, Hello, I need a solution for the following situation: See attached screenshot from my Excel spreadsheet. I would like to know if the...
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...
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...
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 ...
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...
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...
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...
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,...
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...
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...
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....
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 ...
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...