Hello, I have a excel 2003 file. My application is excel 2007. When I save the file as .xls, I lost all the format. So, I save the file as .xlsm...
Hello, i need to copy column values from 1 worksheet into another if the em id is the same in the two worksheets... that means worksheet 1 has empi...
Hi any one plzzzzzzz help me, this sheet has 5 columns column A COLUMN B COLUMN C COLUMN D COLUMN E row 1 --- vegetable,...
Hello, On two occasions in the past this community has been of incalculable help to me, and I was wondering if there might be one more assist th...
Hello, I want to connect oracle10g throw JSP code.I already implement registration page but after inserting some value when I click submission bu...
Hello, I am trying to add a new series in a graph through macro. Range of the new series is similar to the other series already plotted in the ...
Hi, I have Response XMl Schema from 2 different environment of an application in sheet1 and sheet2 on the msexcel . I have a collection of xml ta...
Hello, I have searched through many posts and it appeard everyone is very helpful. My skills in vba are ok but i lack the knowledge to solve my prob...
Hello, i have excel 2003. what i am trying to do is set up a complaint sheet for 4 different people. In total there are 5 sheets (Main, Al, Bri...
Hi, I have a list of aged debtors that is updated weekly, Im looking for a formula that will search the previous list via the invoice date and if ...
Hello, I would like to know if I can merge rows if it meets certain criteria in Excel. If Project ID on column A is matched, it will merge all the ...
Hello, We are using office 2007. My problem is, we are type 2400 or other number in my excel sheet. It hides the last to digit. It show only 24 .We ...
Hello, Hi. I am not a programmer and have not used Visual Basic before so that's probably my first problem (!) but I am trying to debug a macro in...
Hello, What I'm attempting to do is create a master list of items ordered and what they are ordered for. Sheet 1 is a list of tasks generated b...
Hi, I have 2 excel sheets namely A.XLS and B.XLS. I would like to import the data from A to B by running a command button in spread sheet B. Can an...
Hello, I'm hoping someone here might be able to help me with this. I have a spreadsheet where column A is a project name then columns B, C and D a...
Hello, Configuration: Windows XP / Internet Explorer 8.0 I have date in an excel spreadsheet that gets updated automatically every minute. ...
Hello, I have a macro which login to one of my site and download a file based on the no what the macro picks up from the excel file. While doing...
Hello, Could you please help me in downloading data's from a web page to an excel. If that web page has multiple pages ( 1,2,3,4.... ), i want all ...
Hello, I regret to say that I missed using hello and other polite words in my earlier post. I do respect the people behind the forum. I know that ...
Hello, I have an excel worksheet, which I want to make 38 copies of, and rename each copy with the initials of the person to whom it belongs. The ...
Hello, I am having two text files ( which is a comma separated file).The template of the two file is given below. SD,CurrentDate,RecordCount ...
Hello, I have a document that we adjust the master, and then each fiscal year I want on separate sheets but to be updated with the master. I linke...
Hello, All Hope you can help! I have a list of actions 1 Contacts 2 Appointments 3 Estimates 4 Sales contacts counts as 1 contact,...
Hello everyone, my macro works fine, but when i share my work book it is throwing some error, Run-time error '1004': AdvancedFilter method of R...
Hello, I'm very new to progamming kind of stuff... i need to generate a report from a excel sheet. Coloumn Q of "data" sheet has only 0 or 1, whi...
Hello, i wanted to ask if there is a method so that i can keep other excel files updated when i make some changes in a particular file.....suppos...
Hello, need help with macro to move rows to columns please E-Mail ID is removed for your security if you can help with this. thanks
Hello, I have a yes or no sheet, one column for yes and one column for no. I want the end column to calculate a 1 for yes, and 0 for no, and in s...
Hello, I'm applying this code to transfer data from sheet 1(source) to sheet 2(destination). Sub TransferData() For Each cell In Range("B...
Hello, i use a macro for filering my data into another and macro code is Sub Extract1() ' ' Extract1 Macro ' extract ' ' Keyboard S...
Hello, I am a very novice/beginner Excel user. I have a table of Company information in a vertical column which I want to convert to a horizontal...
Hello, I have a 9 digit zip code in column A. I need to phyically move the first 5 digits to column B cell by cell, i.e. A1 to B1, A2 to B2, e...
Hello, I am using Excel for inventory and invoicing. They are in different workbooks. I have to fill in the information in each workbook. My ques...
Hello, Configuration: Windows 7 / Firefox 3.6.17 Hey guys I'm doing some project on Excel for a class. When it comes to entering and crea...
Hello, I am trying to select certain rows from a very large data sheet. Ideally I would like to select every 25th row so as to get a random sample of...
Hello, I have an excel 2007 file which I wish to be able to highlight a row if the first two cells in that row equal "Large code model" in the fir...
Hello, I need to write a macro for following example (copy and paste to excel with comma separated ',' delimiter). MS start and MS end column have...
Hello Dears, If any one can help me. I have 2 excel sheets, Sheet1 "All Invoices" and sheet2 "PAID Invoices". In sheet1 I have several column...
Hello, I'm trying to create a formula to check a cell for a certain string of text, and then if it contains it, take the value of a number in that...
Hello, all. I have 2 sheets of a spreadsheets I'm looking at in Microsoft Office Excel 2007. On the first sheet: a) I have 300,000 rows of user inf...
Hi Everyone. Hope you guys can help. This is what I need I have 3 sheets in excel. Sheet 1 is my master and has products listed according t...
Hello, I have an Excel 2010 worksheet with the following data Name ID Qty Joe 123 15 Bob 456 8 Ed 234 ...
Hi I have a column (A) in excel that lists all of the staff in an organisation, and in column B is their telephone number. In column C is a list o...
Hello, I have a workbook I've created to track sales leads. I have a main sheet called "directory" and individual sheets for each business I conta...
Hello, I have recorded a macro on Excel with the function IF(OR(AND done but when I try to run the macro file in the test datafile, an error occur...
Hello, Configuration: Windows Vista / Firefox 4.0 I have an excel sheet with the data in following manner. a b c d 1 1 1 1 2 2 2 2 3 ...
Hello, I wanted to know if a macro could help me deal with the following: The data is something like this: Column Field1 Field2 Field3...
Hello, I have some data in excel, where I need to run filter option. But due to some constraints, I cannot use the manual option of filter in exce...
Hello, I am looking for a function or macros to compare two cells in two rows and return True if it has partial match. And one more condition to s...