The discussions
Office 2010 isn't opening any files
SolvedHello, I've downloaded office 2010 - and it's not opening any files form box unless I select 'open with' for each file. I want an automatic downlo...
Letter received and dispatch system
Closedi have to convert the manual system of letters received and dispatch records to computer system.The table structures are given below Receiving regi...
Macro to find and copy cells
Hello, I have never wrote a macro using VB I normally just do simple ones step by step, could you please tell me how to do one that finds the cells ...
Copy a row to another sheet with conditions
Hello, I am very new with coding in excel. I have a sheet called AFF with rows containing different information. If a cell in column Q is not e...
Excel macro selecting column
ClosedHello, I need to select a specific column relative to the active cell in a macro. Specifically, regardless of the Active cell on a given row, I want...
One column multiple rows (data in sets)
Hello, I'd be grateful for any suggestions... So what I have is gene A 1 2 3 4 gene B 1 2 3 4 and what I would like is gene...
Macro help in excel copy pasting
Hello, I am trying to copy data from a excell spread sheet that is actually a set template i.e. Name:John Doe Age...
View 1st item in a drop down list.
Hi. I have a dropdown list with several items. When I click on the list the focus is always at the bottom rather than the top. Can you please tel...
Vba - compare two sheets
Hello everybody, I have two sheets: - sheet1 holding 3000 entries of all the guys - sheet2 holding the transferred guys i need a macro that...
Sorting and creating a new file
ClosedHello, i wanted a macro which will sort my data based on a product name in a given column say for example column a and they sort all the rows wit...
Outlook email
ClosedHello, Outlook will only allow me to send an email to myself. When sending just a test email to anyone else i get this email from system administrator...
Compaq presario f700 startup password problem
ClosedHello, I got this,compaq presario f700 from my friend! I'm not sure where did he get it but that's not the problem now! When I turn it on, It appe...
Excel data reading from another excel shheet
SolvedDear People, I have a small Requirement in Excel. Can you please help me out? Problem Description: Content of Raw Material Prices are maintai...
How to select only
Hello, this might be an easy one. If i have a long list of numbers and that list contains the same items, numbers whatever several times, how do i...
Using functions in excel, match, vlockup
Hello, I have two columns with numbers and i need to find the numbers in 1st column that apear in 2nd and vice versa. But my problem is next: when...
"">[no.]=true & ""<[no.]=false in excel ????
Hello, as the title says why excel treats same kind of formula in 2 different ways??? thanx
Percentage formula for microsoft excel
ClosedHello, Im looking for help regarding a pricing sheet im trying to create on excel.I have my list of costs ok where im adding the totals in the cells ...
How to remove a memory card pasword
Hello, how to remove a memory card pasword....please tell me how? Configuration: Windows XP / Opera 9.64
Identifiying data that does not match inexcel
ClosedHI There, I have two columns in excel, I would like to verify that the information in Column A, is the same as in Column B, and if not I would lik to...
Copy entries in list based on a cell content
ClosedHello, in sheet1 i have a list of names in column b and cities in column c..now in sheet2, after entering the city in cell B1, i would like to cop...
How to split data in phone directories
Hello, Kindly advise how should i have the raw data below being seperated to format required? The raw datas are as below:- Zexcom Sdn Bhd ...
Lookup problem from excel 2007
ClosedHello, Just want to seek for assistance about my problem for lookup data.Actually i have data as per below. PO Items Qty 0001 a 2 0001 b 10 ...
I forgot the password of my memory card
Hello, i forgot the password of my memory card and i cant access my memory card anymore.. please help me.. my phone is nokia 5130c Configuratio...
Copy row if value in column l = unpaid
Hello, I am completely lost with using macros. I can't seem to find a beginners guide for using macros on a mac. I've read several threads that ...
Excel data extraction issue
Hello, I have the following issue with data extraction with Excel. I have a list of data (barcodes) dynamically populated - which means that ever...
Unable to send from ms outlook 2010
Hello, I have any problem with my MS Outlook 2010. I could not send email but I could receive email. Everytimes, I click Send/Receive email always a...
How to compare several columns...?
SolvedHello, could anyone help me with this. I would like to compare two columns: A B C D Peter 4 John 3 John 3 Peter 5 G...
Using macro for conditional formatting
Hello, Im in desperate need of help!!! I have an excel sheet with a list of employee number,rank,primary schedule, and secondary sched, years of e...
How to extract info from csv files to excel
SolvedHello, I have 74,340 .csv files I need to extract information from Col. A-C & Rows 1-143 into an excel workbook, Sheet1. Every .csv file has diffe...
Excel vba macro
The situation is: I have a about 15000 lines of data that needs to be cleansed. I need to change the Item description from e.g Uncleansed = OFFSET...
Reg: excel query
Respected Sir/Madam, This is regarding a query that i have in MsEXCEL. I would like to know is there any formula or script so that i can get the...
Search inside an array and return a row?
SolvedHello, I have a spreadsheet of data, and I'd like to create a macro where I can input a name (from within the unique names listed in column A for exam...
Transfer data to match on excel
I have two reports. One is from 2010, the other is from 2011. Within each report is the same information...account numbers, member names, credit sco...
Search for any value within a range and copy
SolvedHello, I am a beginner with Macros and would like to find code that will allow me to do the following: 1. Look for ANY values present in colu...
Micro sd card password
i forget my micro sd card password set by nokia 5250. So,memory card doesn't support in other mobiles.please help me
Splitting similar values of column to 3 colum
Hello, I have a spreadsheet that lists employees, then it list one of three quarters, and then it list their ranking for that quarter. I need the...
Paste to all sheets except some with criteria
SolvedHi, How can I make a macro paste copied data into some sheets of a worksheet but not other sheets. For example, I have 10 sheets in my worksheet ...
Formating a column using macro
SolvedSir A forum member helped me in writing a macro to copy certain data from sheet one to sheet two. I modified basic macro to suit as per my require...
Seach for value, select entire row, copy
Hello, I have one macro that will search for a specific range in a series of workbooks and copy that range to a new workbook, and another that will ...
Excel vba user form
Hello, I am quite new to Excel VBA and I , desperately, need an expert help. am trying to create a user form that generates customer IDs made of 9 ...
Call an excel document to another sheet
Hello, Can any one suggest how to call a separate document(or) a Cell from one excel sheet to another excel sheet. For Example Book 1 got he...
Forgot password
SolvedHello, sir i have nokia2690 mobile the security code was changed onetime but the new password is forgot so please help me. Configuration: / Ope...
Compare and count
ClosedHello, I want compare the two text coloum and count them for example mumbai ok mumbai ok mumbai not ok delhi ok pune not ok bhopal ok I wa...
Plz help me reviving some deleted fb messages
Hi , i have deleted some important facebook messages accidentally... can i revive them? please help me. thanks and regards, rosie Configuration...
Automatically copy from one page to excel
Hello, I want to copy information from one sheet to another regarding the categories. For example if I have airline company name, aircraft type, ...
I forgot my password
ClosedHello, I am babu from pondicherry...........i forgot my password its not opening nearly for 1 year please help me to know my security code?????? ...
Excell conditional formatting
Hello, I have been using conditional formatting to make a cell change colors if a)greater than or b)less than, today's date; however, I don't know...
Problem in receiving same mail on 2 systems
Hello, i have created a outlook account on ms 2007 in two systems where both the systems ll receive same mails sent from outside. but the problem is o...
Office 2010 excel
SolvedHello, i am trying to show in cell J2 if the sum of cell I2 is more than 10 to show 10 and if the sum is les than 5 to show 0 have found how to show ...
Change cell color every 7 days
Hello, Is there any way to change a cell's color once a week on a certain day on a regular basis. Example, only on Wednesdays cell color changes to p...