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. ...
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 ...
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. ...
pls guys get me free browsing on dis network mtn and zain both on phone and laptop send it here email kwada90@yahoo.com
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...
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 ...
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...
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 ...
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...
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 ...
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,...
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...
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 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...
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...
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...
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. ...
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 ...
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...
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
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. ...
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...
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....
Hi Everyone, I have an excel formula question that someone might can help me with. A B 1
Hello, I have a two columns A and B as listed below: A B C Location Phone CHENNAI 4458720241 CHENNAI...
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...
Hi, I have an Excel sheet with the data in this order: A B C D date1 / text1 / amount1 / ID1 date2 / text2 / am...
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...
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...
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...
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 ...
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
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 ...
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...
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...
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...
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 ...
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...
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 ...
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...
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...
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...
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 ...
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 ...
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...
Hi, I need help creating a formula in excel to Identify the Highest and Lowest values Every 10 rows THEN Identify those two rows...
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...
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...
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...
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 ...