The discussions
Excel data validation
SolvedHello, I have a master spreadsheet to collate data from spreadsheets filled in by my colleagues. Column b is 'Transaction Type' and I want to pro...
Vlook up fails!
SolvedHello, this is the code that i have: =VLOOKUP(C2,'sport'!I:L,1,FALSE) Where C2 can be varied, depends on user input. the column containin...
Vb excel 2010 - loop until can't find
SolvedHello, We are trying to manipulate data from a very old DOS program. We have a lengthy macro that works well until the end where it seaches for s...
Excel: locate value in one list & copy
SolvedHello, I need some help with Exel. I have two lists: List one contains two coulmns: ID numbers and age. List two contains also two coulms: ID ...
Copy if condition range is met
Solvedhey guys i tried hard, altered other peoples codes but i cant figure it out for the life of me all im trying to do is copy from sheet to anot...
Data reshuffling of cells
SolvedHello, Dear Friends, I need your help to solve the following problem. I have few files containing data of more than 50,000 records. Some rec...
Find word within certain lookup reference
SolvedHello, I need help to solve this problem. Example : Cell A1 : "cost of electricity" Cell B1 : "$100" Cell A2 : "telephone charges" Cell B2 :...
Combining values using if/then search
SolvedHello, I am trying to combine two worksheets that have some similar data points but not all. Example: Sheet 1 has columns: Name, Age, Class She...
How to make more color
SolvedHello, all expert, I am using the Excel 2003 worksheet to make a project. But due to the limintation for the conditional formatting for the color ...
Copy and paste/transpose each row by n times
SolvedHello, To get my data in to an Enterprise program, I need to have my data like the following: Col A Col B Col C Bank A 2010 1 Bank A...
Change adobe reader from default application
SolvedHello, How do I change my settings so that Adobe Reader is NOT the default application used when downloading a JPEG image? Everytime is save a JP...
Excel macro copy to cell based on criteria
Solvedhey everyone, I'm stuck. I hope someone can help me out today. I have an excel spreadsheet with 1400 rows. The first 3 rows are irrelevant (headi...
Excel vb script to notify/popup
SolvedHello, I want to have different cells in the worksheet have pop up messages/notifications when the date or deadline is reached. so when the 1 june 2...
How to match the 1st left word on diff sheet
SolvedHello, I'm trying to match the exact first words from sheet 1 to sheet 2. (like the way we get the match for Vlookup formula) I have a file which...
Ms office problem
SolvedHello, i am still using 2007 office but my some excel files in 2003 office format so pls suggested me now how to opned my old file in 2007 offic...
Yes or no return on a comparison of two colum
SolvedHello, Column A contains 80 cells with numbers such as this, not in sequential order: 3-1705578711 Column B contains 50 cells with numbers simila...
Excel macro for deleting rows if cells not...
SolvedHello, I need help to create a Excel macro. Basicly what I have is a sheet full with information about different departments and what I want to do...
Ms word 2007 field codes are shown
SolvedHello, I'm working on a long word document and all of a sudden field codes are displayed instead of references, page numbers etc. I followed what s...
If a1 contains the a word, then show b2 in c2
SolvedHello, I'm trying to create a formula to display the contents of B2 in C2 if cell A2 has a certain word. ex. =IF(ISNUMBER(SEARCH("BACH",B13)),"=C1...
Excel - select last 25 records
SolvedHi I have a spreadsheet that is entered into daily a list of actions taken in a department. This needs to be printed weekly and displayed. Obviously t...
Excel - removing different rows in 2 sheets
SolvedHello, I have two worksheets containing a different number of rows. I want to delete all rows in sheet 1 that have a value in column A that c...
Compare columns and copy
SolvedHello, I need a Macro to do next : i have 2 sheets Sheet1 and Sheet2. In Sheet1 column A has a variable range of values i.e. A2 : A... Column B is e...
Creation of dropdown from dynamic list in vba
SolvedHello, I have been trying to make a Macro that can create a dropdown list from a dynamic list in column A. So far I've come up with the followin...
Avg multiple cells in multiple sheets - excel
SolvedHello, I need to average multiple cells across multiple sheets, but not all are in the same column/number. I need to average B35,D35,F35 in Sheet 1...
Macro to insert data to changing cells
SolvedHello, I'm trying to write a macro in excel for inserting input text to a specified cell. I have already an InputBox specifying the text to be put...
Excel merge text files
SolvedDear Forum Members, As I am not a VB expert I have copied some codes and edited to suit for my purpose. My idea is to combine many .pyc files in a f...
How to remove powor on password of my g five
SolvedHello, How to remove powor on password of my g five mobile,plz help me. Configuration: Windows XP / Internet Explorer 8.0
Compare two excel columns of differant size
SolvedHello, i am having two excel columns of differant size..Both the columns contain mobile numbers..i have columns A containing all the mobile numbe...
Copy paste rows in excel across worksheets
SolvedHello, I'm trying to create an excel macro that will copy a sequence of rows from 2 different worksheets and paste them in a third worksheet using t...
Word files converted into pdf, cannot be open
SolvedHi, Many of my word files have converted into PDF file. On the other hand those files cannot be opened /viewed. What can I do now to convert those fi...
Excel if formula text vs numbers
SolvedHello, I am trying to run an If formula that if the cell range contain text then use Counta but if cells contain number use Sum. At present I'm us...
Seach for all worksheet and copy the name
SolvedHello, I'm trying to see if anyone can help me with this, I do have a master excel file that get info from other excel files, currently I have to d...
Ms excel 2007 - quick function question
SolvedHi Guys, So say you have 3 cells. A, B, and C. I'm trying to come up with a function to put in C that erases/blanks A if B is #N/A (IsError?). Can ...
I have forgoten password of my samsung i900
SolvedHello, i have forgoten password of my samsung omnia i900. it is a windows mobile6.1 .please help me. please help me to open it .. god may help ...
Complicated table question.
SolvedHello, I have just started a new job and i was asked to do the following. Please help me as I dont know how to do it. System ID Clien...
Copy and paste certain columns based on dates
SolvedHello, I am trying to create a macro that will look at a list of dates in column B then copy and paste the data in column C and D to another sheet...
Searching for a word in table
SolvedHello, In excel, I have 5 columns of words (5 undividual word lists) and a row at the top that gives information on that word list. I want to use a ...
Mobile tracker password forgot
Solved/ClosedHello, i reset the mobile tracker password and forgot the password, I kindly request you to suggest me a solution to reset the password for the Samsu...
Auto filter depend in droplist value
SolvedHello, I'm wondering if anyone knows some formula to filter data depend in dropdown list My spreadsheet has a column with the order status ...
Why doesn't this simple vb code work?
SolvedHello, What I want to do is the following: When a cell in column AH is selected move to the next sheet and select the cell in column C same row. ...
Hide columns
SolvedHello, I recorded a macro to hide some columns (says, column M to O). However, when I tried to run the macro again, the macro hide all the columns f...
Forgot my phone password
SolvedHello, i forgot ma phone password......n nw i cant put a new pass word wat sud i do plz help me..... Configuration: Windows 7 / Safari 535.1
How to find a number from the list
SolvedCan u please help me in writing a macro in excel as below: 1) When we click on the command button, it should prompt for entering the number in the ...
Vb code for drop-list menu width
SolvedHello, If any one can help me. In one excel sheet I made list of names and defined that list as "Names", then in another excel sheet in column ...
Hide unhide column with clickbox and password
SolvedHello, All Please can you help, is there a way that you can hide/unhide colmns with a click box, I have the code to group ungroup when the sheet a...
Copying a row based on part of a field
SolvedHello, I am trying to get an excel macro to do a search of Sheet1 that will go through each row in column E and copy any row that contains a X or ...
Conditionalformating: if cell a1 = 0% to 50%
SolvedHello, Hope someone can help? I want to format a cell that changes % from a formula. A1= 0-50% format B1 to green, and if A1= 50-100% format...
Transfer of excel data from a row to another
SolvedHello, I have this excel sheet with numerous rows having columns A,B,C,D &E.column A is numbers & other columns hav data in text.I want to transfer...
Vlookup picture
SolvedDear Sir, In $F$8 i have inserted the data validation list Where the name of Pic is to be select. I want to know how to call a picture in excel 200...
Macro to copy and paste
SolvedHello, I would greatly appreciate any assistance with creating an Excel macro that will copy information from cells A1, B11:D11, A13, B23:D23, et...
