The discussions
Macro code for making a graph in excel
Hello, I would like to create a graph from a macro. Here is what I have got so far. Charts.Add ActiveChart.ChartType = xlXYScatterLinesN...
Macro regarding the cell color
Hi I would like to have a macro for the following when i type "red" in a cell the whole cell turns red when i type "orange" in a cell the whole ...
Extract info from excel
Hello, I wonder if you could please help me. I thought this would be something simple but after an exhaustive search and using filters and Vllookup I...
Excel less than but greater than
SolvedHello, How would I get into L2 if J2=>10 then "lates", if J2=
Excel-extracting names into seperate elements
Hello, I have several hundred names in an excel file written like this Doe, John A and I want to seperate them into 2 columns with first names in ...
Password change
Hello, I have samsun SGH-A877 and I forgot my password to unlock some of my applications. Can you help please? Configuration: Windows XP / Int...
Excel 2007 date 20100915 without formatting
Hello, I have a column of dates (around 800 rows) with dates entered in as 2010/09/15 as date format. I need to convert these to GENERAL format an...
Sd card recovery of password
Hello, i have forgot my sd card password in nokia 2690 mobile .. plz tell me hoe to recover it?? Configuration: Windows 7 / Internet Explor...
Administrative password
Hello, the compaq presario asks for an administrative password when you go into system recovery how do you get that? Please help me. Configura...
Need to show calculation in time
Hello, Can you help? If I work 104 hours and sell to 38 customers the answer is 2.74 however I need that answer to read in hours and minutes. Pleas...
Vlookup sample problem
SolvedHello, I'm trying to learn vlookup and I made this sample problem and I'm not sure how I could get the formula done correctly to get the value I n...
Find and replace in excel
Hello, all i have been suffering to find a solution for a problem which is : I have three categories which I call region (Central, Northern and ...
Find and replace in drop down list
Hello, Column A Column D Dog animals are nice Nice cat animals are nice Nice sheep not nice ...
How to add count to a column w/ 3000+ rows?
Hello, I have a column with numbers in them (1) Column, over 3000+ rows. How can I simply add the 'COUNT' text in each cell without having to ent...
Highlight max/min in excel 2007, vba
Hello, I'm quite new to Excel VBA and need some help doing the following. I have a lot of data and need to highlight (or change the background ...
Macro - check name and then insert blank row
Hello, Would appreciate any help on below. I need a macro that would insert a blank row after each unique entry. To illustrate imagine follo...
Excel formula to populate fields
Hello, I have a spreadsheet with Employee names (A2...A150) & one of 5 Divisions that they work for (B2...B150). What I am trying to do is put the...
Copy 5 columns and paste to next 5 columns
Hello, I have to run daily reports where I have to add new day data to the right end of the spreadsheet. Example is below. I want to create a macr...
How to copy sheet1, sheet 2, sheet3 in sheet4
Hello, How to copy sheet1, sheet2, sheet3 and Sheet 4 in Sheet 5(same excel workbook) using macro? I want to copy columns A-W The rows will ...
How to do in excel
Hello, I've four columns: A (with Names), B (with date of birth), C(random name of column A) and D (the result i want automatically). What formul...
Drop down list and find and place
Hello, all Is it possible to combine a find and insert with drop down list. I mean A1 is drop down list which allows the user to enter T1 or T2 or...
Forgot admin system password/no cd drive
SolvedHello, i have sony vaio PCG-R505TFP (with no CD -drive),how i can log-in to my system?? please help. all the solutions available on internet inc...
How to add iferror to formula
SolvedDear all i have an excel database which search for a word in a cell and if it finds it, it puts it in another cell. The problem is the sell contain...
Trouble with vlookup
Hello, I have two worksheets. The first contains a series of Divisions, Regions and Areas Division Region Area Jonestown Alpine West Spri...
Not able to change default password
Hello, I am not able to change default password (factory set password). Even I do not know that password. Can any tell me what would be default pa...
How do i put a picture in a table in word?
Hello, I'm producing a catalogue for a charity auction. I'm using Word '97. I have laid everything out in a table, but now I want to put pictures...
If formula
I want to have IF function working for me to carry out following condition Clients Salary 0-7 Zero 8-14 ...
Cannot insert text in my pdf file
Hello, i got adobe reader and also its proffesional version. but when i open it with my proffesional one i can insert text in it but as it is ...
How can i paste the results
Hello, How can I paste the results (complete row) of following find command to another blank file? Cells.Find(What:="abcd", After:=ActiveCell, ...
Color change macro
HI All, I need an excel macro where i require to do the following things: if i type RED then the cell in which i type RED turns red, SImilarl...
Cannot see watermark
Hello, A watermark is embedded in a document but it is so faint I cannot see it, which leads to printing errors. The documents come in like ...
Excel if function
SolvedHello, Could someone please help me with the following problem. I want to know how to do a if function in vba to search for a value (output), a...
Forgot password
Hello, sir me mohit i have a nokia 2690 cell. i forgot my kingston sd memory card password. plz help me Configuration: Windows XP / Opera 9.80
Excecl range name to import a csv file
Hello, For those who remember Lotus, it was possible to use file import numbers into a spreadsheet using a range name. For example, Cell A1 is na...
How to get a value in a cell n times
Hello, I have an issue in creating a data sheet. I read all the forums but unable to find the solution. I want a macro/ formula leting my job get ...
Lookup name & return column value
SolvedHello, I am looking for assitance with a formula and all help would really be appreciated. I have 2 sheets sheet 1&2,on Sht1 is cells J2 & K2 w...
Macro to find and copy all columns
Dear all, I've searched online for 2hours but still unable to find suitable threads, please direct me to the information or help me out with the fo...
Do a favour please. its about if function
Hello, I am trying to write an IF() function with more than 8 conditions (to be exact I will almost have 50) I understand that excel 2007 allows f...
Excel macro assistance please.
Hello, I am trying to write a simple Macro which would look at a corporate organizational chart in Excel. The Macro would list the company name an...
Excel macro, time input button
Hello, Excel Macro Help PLEASEE!!!? Ideally i want a time in and a time out button, so that when workers sign in they click the timein button a...
Excel hide column formula
Hello, I'm trying to find a way to hide a colum in my excel workbook when I would select one of 3 drop down menu items. The drop down list is lo...
Let text in one cell overwrite the next cell
Hi, Does anyone know of a way to let the text in one cell overwrite the content of the cell to the right? Explanation: When you have text in one...
Copy between workbooks from a third workbook.
SolvedHello, I would like to make an excel macro that will sit in a stand alone workbook (Workbook1). This macro would select a single user-defined works...
Copy paste multiple rows - incrementing issue
Hello, I'm having a problem, I have 9 rows of data that contain formulas that pick up data from other worksheets. When I copy and paste to the nex...
Excel: don't print when cell value is 0
Hello, Please, I have an excel file with several worksheets. I made a macro that when I click a button, the worksheets are printed. There are sev...
Formulas in conditional formatting
SolvedHello, In Excel 2010, I'm trying to color entire rows in a spreadsheet based on values in a certain column. I have been able to do this for numbe...
Memory card password has been forgotten.
Hello, my transcend 4gb memory card is locked with password. As I had forgotten the password I want to unlock it. Because I had many important files...
Memory card forgot password
Hello, am forgot my password.please send the information how can i remove my password in my memory card. Configuration: Windows XP ...
Filter problem in excel 2007
Hello, Im Xishan, using excel 2007 & facing problem while delteing rows of filtered data. When i delete filtered rows, other rows(unfiltered ones) ...
Help! trying to copy rows of data via macro
Hello, I could really use some help. Here is what I am trying to do.I have a mound of data that i want to break up into different sheets. I want to u...
