Excel Forum
-
MS Excel 2007 won't read in 2003 [Closed]
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...
-
copy columns [Closed]
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...
-
i want to delete rows except certain values [Closed]
Hi any one plzzzzzzz help me, this sheet has 5 columns column A COLUMN B COLUMN C COLUMN D COLUMN E row 1 --- vegetable,...
-
Copy non adj. cells from two sheets into one [Closed]
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...
-
404 error in mozila firefox browser [Closed]
Hello, I want to connect oracle10g throw JSP code.I already implement registration page but after inserting some value when I click submission bu...
-
retrieve a range chart through macro [Closed]
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 ...
-
Search for a values in 2 sheets using macro [Closed]
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...
-
Inserting/Copy rows, Transpose vba HELP [Solved/Closed]
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...
-
conditional copying into different worksheets [Closed]
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...
-
Excel formula needed to look up and copy data [Closed]
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 ...
-
Merge rows if it meets criteria in Excel [Solved/Closed]
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 ...
-
excel 2007 is not working properly [Closed]
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 ...
-
Help with Excel macro [Closed]
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...
-
Pulling ordered parts from sheet 2 and insert [Closed]
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...
-
Import Data into Excel [Closed]
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...
-
Conditionally deleting rows in excel 2007 [Solved/Closed]
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...
-
excel data updation [Closed]
Hello, Configuration: Windows XP / Internet Explorer 8.0 I have date in an excel spreadsheet that gets updated automatically every minute. ...
-
Need help in saving file which macro download [Closed]
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...
-
Webpage to excel [Solved/Closed]
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 ...
-
macro to copy certain data [Closed]
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 ...
-
Copy an excel worksheet multiple times [Closed]
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 ...
-
How can i compare two excel sheets using VBA [Closed]
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 ...
-
Linking excel sheets and getting 0's all over [Closed]
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...
-
formula: to count cells and then add number. [Solved/Closed]
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,...
-
Macro not working in shared work book [Closed]
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...
-
Needed a VBA. [Solved/Closed]
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...
-
Update the value of excel files [Closed]
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...
-
move rows to columns using macro [Closed]
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
-
Excel "if" for letters to equal values [Solved/Closed]
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...
-
VBA Transfering Data To Next Sheet [Closed]
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...
-
Macro help [Closed]
Hello, i use a macro for filering my data into another and macro code is Sub Extract1() ' ' Extract1 Macro ' extract ' ' Keyboard S...
-
Excel 2007 [Closed]
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...
-
EXCEL Move A1 to A2 in a formula [Closed]
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...
-
Excel question [Closed]
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...
-
Simple Excel Formula Help [Solved/Closed]
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...
-
Excel row removal/selection [Closed]
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...
-
Excel 2007 conditional format question [Closed]
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...
-
Excel - Macro|group by|based on time interval [Closed]
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...
-
Cut Entire Row To Another Sheet Based on Cell [Closed]
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...
-
Excel: check text in cell, add values [Closed]
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...
-
Comparing & replicating data, 2 Excel sheets [Closed]
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...
-
Excel Help [Closed]
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...
-
Excel Formula to Create Rows Based on qty [Closed]
Hello, I have an Excel 2010 worksheet with the following data Name ID Qty Joe 123 15 Bob 456 8 Ed 234 ...
-
Excel name match query [Solved/Closed]
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...
-
Need Individual Sheet Data to Copy to Main Sh [Closed]
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...
-
Recording Macro with IF(OR(AND function [Closed]
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...
-
Split data into multiple sheets using macro [Solved/Closed]
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 ...
-
Inserting rows with formulae on existing data [Closed]
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...
-
Filter excel data using formula [Closed]
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...
-
Need Excel Macro [Closed]
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...
Subscribe To Our Newsletter!
