ms excel

<tbody> ID First Name Last Name State Reference 1 Mark Brown CA 2257849635 2 Shawn Jack CA 2245787962 3 Smith Black CA 7789654123 4 Mark Brown CA 2257849635 5 Smith Black CA 7789654123 6 Mark Brown CA 2257849635 </tbody> I have huge data (10,00,000 rows) in the above format. Need...

I want to get numbers only from a junk text field in Excel, where number length is >9 digits, if in same text have more than one number combination in a same cell so this will split in different cells Example : Cell (A2) : ABC999989898998_XYZ0998(TUV)44848333423_RKT2323_6669866666 Result ...

I need to insert data into specific cells in a word table that already exists from an excel spreadsheet. The columns will always stay the same just the rows referenced can change. I will always insert values from column A such as A3 into my first word table in the first row,second cell. Does...

How to lock certain cells to prevent editing in Excel?

Hi everyone I've created a bar chart using a data from the cells. When the cell show 18.96 on the data label it's also show 18.96 which is fine with me because that is what what it to show on the chart. But when the value is 55, 60 or even 100 it will show 55. , 60. and 100. on the data...

Hi Everyone, I'm trying to use MS query via ODBC connection to pull data from one main table while joining two tables (left joins each) to enrich the data. I know that MS query wizard only supports one outer join, but from what I've read, the correct SQL code will work. Think of it like this...

Hello Members, I got a problem like this http://imageshack.us/photo/my-images/69/twoproblem.png/ Now my query is in those two files there is a column named "Expiry Date". Now, how can I change that Month & Year also to I,II,III... with their respective names, like whichever is the nearest...

Hi all! I would like to sum the cell values from D7:M7. Initially I have unique values for those cells but I want to add those cells based on my criteria, because each cell has different conditions to satisfy. For example, D7=IF(D7<=W7,D7,W7); E7=IF(E7<=W8,E7,W8) etc., D7, E7 - cells with...

I have a templated letter in MS Word and information stored in an Excel file. I am wondering if there is a way to automatically merge certain fields in the Excel database to replace certain portions of the Word document. I also need to print an envelope for each modified letter. Does anyone...

I am a systems person and not a programmer. I need to have an MS EXCEL template that will automatically save itself every 5 minutes. If I don't get this done today, I am FIRED ! Please assist. We have two different workstations - one has MS EXCEL 2003 and the other MS EXCEL 2007 - I can...

Hi, I have 2 work sheets in the same file sheet one contains following info name, address, city, state, phone sheet 2 contains following information I downloaded form Australia Post webstite City, PostCode I want to add a extra column to sheet 1 that contains the post code for that city. I...

I am trying to write a macro that will move all duplicate rows based on column 3 into another sheet. For example: Column 3 xyz qwe abc def abc def gh The last 2 rows are to be considered as duplicate and need to be deleted from this sheet and moved to another. My knowledge in macro scripting...

hi i hv created a macro for a wrkbook involving three sheets. the first being the master sheet the second is a pivot table sheet. now by the macro i aim to automate the process of selecting the data from the pivot table sheet and copy it to the third sheet and then format this data to a preset...