Excel Forum
-
Create lists of columns containing a value [Closed]
I have a need to populate a column in one sheet with column headings from another sheet that contain a given value. I will illustrate better below. ...
-
Browser not loading pages [Closed]
I don't know if my Firewall is totally misconfigured or if the antivirus program that I have on my PC (Win 7) is keeping me from loading webpages. If ...
-
Coping Cells With A Loop [Solved/Closed]
Hello, I am stumped on what should be a very simple macro. I am running a macro that is using a look-up table to compare the values in column G. ...
-
freebrowsing on mtn zain both GSM and laptop [Closed]
pls guys get me free browsing on dis network mtn and zain both on phone and laptop send it here email kwada90@yahoo.com
-
Lookup a header in a table - Excel 2003 [Closed]
So HLOOKUP doesn't seem to work as well as I hoped on this one, I would like to return the text on the top of a table column by first finding some...
-
comebiine multiple cells displays formula [Closed]
Configuration: Windows XP / Firefox 3.0.18 In Excel 2007 Very basic formula but I think it is a bug. A1 has first name; B1 has last name; C1 has ...
-
Excel copy not working [Closed]
Hey, I got a code from this site and made changes to copy from a different excel file and paste to another file. I'm copying from a file Source.xls...
-
Using Excel Macro to insert jpeg from dir [Closed]
Hello, Please help. I have written a macro to pickup jpeg file from the directory and insert it into excel. I have issue with picking up jpeg ...
-
MS Excel issues :/ [Closed]
I need to replace a range of 7 cells with a choice of another several ranges, based on the valueof (yet) another cell. For example: Range a1:a7 val...
-
copying of data from one excel file to other [Closed]
Hello, I have a excel file which is having the list of filenames (eg- MEF_collection) in B column. Now i wanna open another excel file which ...
-
Lost my Huawei driver mini CD and the browsi [Closed]
I have lost my Driver CD for the modem supplied along with modem so please download the same for installin once again on my laptop after formating it,...
-
Help on Excel Formula [Solved/Closed]
I need to create a formula to give me with value and not TRUE/FALSE information. I did use the IF function, but it results in TRUE/FALSE and I need a...
-
Excel file not open in Spice QT66 [Closed]
I have Spice QT66 model. i try to open xls. file in phone but not support phone. can tell how i can view this file. Configuration: Windows Vist...
-
I need to consolidate multiple columns- macro [Closed]
I am trying to write a macro so that I can combine data from several worksheets, the data is contained in different columns in each worksheet but eac...
-
Comparing text lists in Excel [Closed]
I need to compare a text list in Excel in Column A in Sheet #1 to a text list in Column C in Sheet #2 and then print the resulting text it found in Co...
-
Excel Data Copy [Closed]
I am looking for a formula that does the following: Looks at cell values in a particular column If the cells have data it then copies that data to a...
-
create macro to copy data from rawdata file b [Closed]
Hi experts... Need a help from you to create an macro to copy the data from rawdata file by condition and paste it into another summary excell file. ...
-
critical macro to copy from rawdata to summar [Closed]
dear all, I need your kind help to create an critical macro in which i have 2 files, 1. rawdata in which i need to filter for certain conditions ...
-
help cant brows microsft webpage [Closed]
hi i run 2003 server and for sum resone i cant acces microsoft webpage but i can brows all other webpages on the net can annyone help me Configura...
-
Excel function as a quoted cell number [Closed]
Hi, I want to have a formula for the number of the row I am quoting, i.e. B[=4+4*A7], but it does not work Thank you! Elena
-
excel [Closed]
Hello, I have a 3 columns say A, B and C.. Column A has say 140 names and Column B and C have 256 names as B and C are dependent on each other. ...
-
VBA code to send a mail [Closed]
Hello, guys, im looking for a VBA code to write that so when i click upon a command button it will populate a pre ready email with a fixed list of...
-
no browser opening,internet connection presen [Closed]
Hi, I m not able to open IE or mozilla to connect internet, though I have internet connection, bcz the messengers are working fine. Please Help....
-
Identify two or more are same or not in Excel [Solved/Closed]
Hi Everyone, I have an excel formula question that someone might can help me with. A B 1
-
I need a macro created for the example HELP!! [Closed]
Hello, I have a two columns A and B as listed below: A B C Location Phone CHENNAI 4458720241 CHENNAI...
-
Copy a range of cells to another worksheet [Closed]
Hi, I have a workbook containing multiple worksheets. I enter data manually in all the worksheets except one say worksheet "X". My requirement is to p...
-
Excel: Convert rows to columns and sort by ID [Closed]
Hi, I have an Excel sheet with the data in this order: A B C D date1 / text1 / amount1 / ID1 date2 / text2 / am...
-
Moving data from one worksheet to another [Closed]
I am using a userform in excel 2003 to enter budget data onto a spreadsheet (sheet1). That data includes a cost code, date, value, order no. I want t...
-
Excel Lookup question [Closed]
Im very basic excel user, Im trying to Search a Database of 6500+ entrys, Its a basic search that i cant seem to work correctly. Basically Each ro...
-
Excel help [Closed]
hii My excel sheet contains the list of my sales to customers every month. I want a sumary sheet i want that it shouls show me what all has been s...
-
Excel- Count unique entry in different groups [Closed]
Hello, I can't figure out how to write a formula to count unique entries in different groups. My goal is to have a non-excel user to just paste ...
-
Copy Multiple Sheets to Another sheet VBA [Closed]
Hello, I want to copy data from Multiple Sheets to Another sheet is there and VBA available for it Thanks and regards, M.P.Mani
-
in excel the value of date of bitrth changes [Closed]
Configuration: Windows XP / Firefox 3.6.2in excel the value of date of birth changes, into numeric number. mostly that time when it paste them on any ...
-
Compare two columns and delete cells [Closed]
I have 3 columns in Excel 2007. The following is the sample data. Col3 is a formula that compares Col1 and Col2. If the value in the two columns ma...
-
Macro not copying correct data [Closed]
hi m trying to copy column D from one tab and pasting it in another tab. When i luk into code it shows copying (D:D) but it selects columns A-D and pa...
-
Excel 2007 - Look up a cell in a tab [Closed]
Within tab 1 I have a cell with an entry of Road 1. In the next cell I wish to go to the Road 1 tab and copy the contents of a cell. The entry Roa...
-
Using excel if function with data validation [Closed]
Hello, i am running EXCEL 2007. i am trying to make an if statement that accomplishes something like, If c1=b1 then d1 = pick a choice from the ...
-
date time picker control excel [Closed]
Hello, i have a user form with a date and time picker control on it. user selects a date and an update action updates a worksheet (called table) wi...
-
merge rows of similar data [Solved/Closed]
Hi, I am trying to merge various rows of data with a common headin in Column A. For example I have the following data: A 1 0 0 0 1 B 1 1 0 0 ...
-
excel pro [Solved/Closed]
hi , i have some data like gvn below M/C SR NO. total b4 a4 cl4 k92661400 18632 8544 544 9544 K81667500 21844 18948 1948 948 H25102020 6756 8...
-
Filter duplicate entry with condition w excel [Solved/Closed]
Hi, I've 2 columns of data. Column A are repeated Test sequence and Column B are Status (OK / Fail). I would like to extract those test sequence wi...
-
if statement for data in columns [Closed]
Hi im a little stuck I have 2 columns of data, i want to get the value of column 2 by searching data in the entire column 1. If column 1 matched w...
-
Special sort in excel [Closed]
I want to make a results sheet in excel for a competition that will create an automatically sorted list so that it can be quickly and easily uploaded ...
-
how to write excel macro to auto sorting [Closed]
hi expert, may i know how to write excel macro program to perform auto sorting of rows of data and then auto create new files for only each set of ...
-
400+ worksheet loop macro [Closed]
First off, thanks Rizvisa for your help previously creating a sucessful macro to loop through all open worksheets in the active workbook. It works pe...
-
Find Max Valu every 10 rows &mark row as keep [Solved/Closed]
Hi, I need help creating a formula in excel to Identify the Highest and Lowest values Every 10 rows THEN Identify those two rows...
-
Excel, If statement with part of text matchin [Closed]
Hi, I would like to find out an if function or VBA code that will return a certain number if parts of a cell contains the text that I'm looking for...
-
macro or vba code to found and paste [Closed]
i have two files, one is excel which contains few articles like 111230, 111412, 552136 etc and other file is notepad which contains hundreds of articl...
-
Selecting rows in excel [Closed]
Hi, Column A has several numbers ranging from single digit to seven digit ones. I am only looking for rows which have 4 digits numbers. These rows ha...
-
Compare numbers in two columns in Excel [Solved/Closed]
I appreciate any response to help me with this. I have two columns of numbers A B B.121 S.222 S.154 B.121 B.164 ...
Subscribe To Our Newsletter!
