The discussions
Excel: matching/sorting
Hello, I'm dumb, lazy, and having trouble finding an efficient way to complete a price list for my store. Here's what I need to do. I have two fi...
I need to apply conditional formatting
Hello, Example: if the value in cell B3 is between 120% and 129% value of cell F3, then highlight yellow. If the value is greater than 129% highlig...
Pie chart comparison
SolvedHello, I have made a number of different pie charts & want to compare them with each other. Each pie chart is comparing the same thing but the ...
I forgot my login password for my compaq cq60
SolvedHello, i forgot my login password on my compaq CQ60 laptop, i just recently changed it and now i can't remember it. Can i please get a reply ASAP
Compare 2 sheets - output in sheet 3 - excel
Hello, I have 2 sheets. For example: Sheet 1: A2 = 777 B2 = 5 A3 = 438 B3 = 4 A4 = 555 B4 = 3 Sheet 2: A60 = 777 ...
Micro sd card forgot password
Hello, Configuration: Windows 7 / Firefox 3.6.13 i have a micro sd card for my phone 6300 and its password protected and i forgot password i...
Copy row if condition is met
Hello, I am new to using excel and vba, but below is what I am trying to do. I want to know if I can copy a row from one sheet to another if a ...
Last transaction date
Hello, I have some inventory data. in which column are as item_code purchase_date quantity amount in another sheet i have item code an...
How to do if statements in excel
SolvedHello, I am having a problem trying to get an if formula right. If fig1 is +- 10% of fig2 I want it to say Fail If fig1 is within 10% of fig...
Data linking
Hello, Hi I have some data in my excel like customer details I want whenever I put unique m\c serial no in sheet 2 autotactically other details ap...
To compare cells of two columns
Hello, I need to compare corresponding cells of two columns of same worksheet and find if it is exactly matched and also if partially matched.For e...
How to take the value of the same date
Hello, I am getting problem to select a cell value with reference to date range. Eg: for preparation of DPR, i need to put date of DPR. i w...
Excel 2007 dropdown error in excel 2010
Hello, In excel 2007, I used Data validation list (drop down list) which retrieved data from another sheet and it works fine in excel 2007. Howev...
Excel help with macro
Hello, guys i am trying to copy the same cells B3,C3,D3,E3,F3 from 100 worksheets to a master one. So what i need is a macro that will copy the cel...
Not changeable cell in excel
Hello, I want to apply not changeable cell in excel. how to do that plz help me Regards & Thanks Bijal
Summary sheet
SolvedHello Sir, I Have 30 Data Sheets Of Individual Date & 1 Summary Sheet. The Example Of Those 30 Sheets Are: A1------------B1------------------...
Vba display in selected cell
Hello, Can somebody help me out with this objective.I would like to have the Staff Number which I'd search and found base on the code below to hav...
Assign a value depending on the font color
SolvedHello, Can someone help me with this. I have a column with some text in each cell of that column. The text font is in either red or black co...
Excel calculations on dates
Hello, I have following: a start date, an end date. Difference can be 1 day up to 10 years. I need to calcuate the numbers of days represent...
Office serial
Hi, I reinstalled office in my laptop but the serial key is not valid as before its a 2007 version which my dad purchased for me as i needed it for...
Searching a column for a list of values
SolvedHello, I am using a macro to search for a list of values that i want to be written into the macro (Permanently). currently i am looping after each s...
Count appearances of specific words in excel
SolvedHello, I have a spread sheet with names of countries in the first column and over 1300 lines of text in the second column. I want to count number of t...
Comparing two worksheets
Hello, I have two worksheets containing financial accounts and their YTD values in exact same formats. One worksheet is for 2009 and one is 2010....
How to copy data row form one sheet to anothe
Hello, Please help me how to copy one data row from one sheet to another. Here's the link of the screenshot: http://fc02.deviantart.net/fs7...
Forgot my password for acer aspire l3600
Hello, I have not used my PC for a while, and have forgotten my password to log into my personal screen after it boots up. Can anyone help? By t...
Regarding samsung sgh-m20 slider password
SolvedHello, please help me to reset the password for my mobile samsung sgh-m20, whose password has been forgotten by me. regards rajesh
Bar and stacked bar graph in single graph
SolvedHello, hi i have to make chart using three field month wise. and i want to make bar for first field and stacked bar for next two within same graph...
Excel how do i...
Hello, i'm interested in creating an excel sheet to reflect my workout routine. i know what i want but i'm not sure how to implement it. any advic...
Dell latitude d-505 config password lost
SolvedHello, Dear I have forgot the Confiq password of my Dell latitude D-505, which tag No. is 52MSW41 PLZ do help to reset or deactivate the said p...
How to convert vba macros to openoffice macro
Hi, I created few macros in Microsoft office by using vba,now I want same macros in open office, I tried to run same macros in open office but I wa...
Found cell color and worksheet viewing
SolvedHello, The code below had cause the found value cell color to remain there even after I closed the Input Box.I would like to have the color to be re...
Vb macro for serching wild card in entire sheet
Hello, In my excel I have colunms with column headings to it. I want to format them based on their identification. For eg. in case I have column n...
Macro doubt: look for a specific value
Hello, Thank you for helping me with this!! I am looking for help to write a macro that looks for a specific value in a given worksheet column,...
Compare the values and multiply the greater
SolvedHello, A B 58.85 503.171 I want to compare the values in Column A and Column B and then multiply the greater with nu...
Startup password
SolvedHello, I just purchased a d260 mini secondhand and I stupidly thought I could change the administrator name, but of course it would not let me cha...
Title... memory card password
Hello, i have forget my 5130 memory card no. If u can help so please i live at bhopal in india Configuration: / Opera 9.80
Vba to change found cell color
Hello, I would like to have the active cell to change color to yellow when a search value in a worksheet is located.The code I'm applying(below) see...
How to add a macro in vba
Hello, Friends I want to add some macros to my excel sheet. Suppose Cell "A1" is formatted in validation ( list drop down) which contains Contracto...
Remaining retirement calculation
SolvedHello Sir, I Wanna Calculate Few Things A1 Is My Date Of Birth A2 Is My Date Of Joining I Want Few Formulas Using These Two. First Thin...
Macro copy & paste and if functions??
Hello, Configuration: Windows XP / Safari 534.16 I am a COMPLETE BEGINNER when it comes to macros. I get the basic idea though. I hav...
Look up for a value left to the lookupvalue
Hello, As we know that for using vlookup, the reference value should be in right of the lookup value. but how can i look up for a value which i...
Mirco sd card password
Hello, pls give me ans in my problem.. my hendset is nokia c3 and msd card is 1GB. after handset firmware upgrade, i faceing problem is Micr...
Outlook 2010 can send emails but cannot recei
Hello, I just installed in Outlook 2010 on Windows 7. I can send emails but cannot receive. Plus, when I hit the send/receive the pop up doesn'...
Lookup error in code
Hello, Hi i am using this code for lookup dim b , n as long b = Cells(2,1 ).Value n =LOOKUP(b,{25000,50000,100000;1,2,3}) it doesnot ...
Lost password -sa6 pink
SolvedHello, My grand kids changed the password on her laptop cannot rember the pasword i need a disk.Thanks Configuration: Windows Vista / Internet ...
I want to use the excel data in word,
Hello every Body, I want to add excel data in Ms word, for example i have the name of customer in ms excel and i want to write a letter to all of ...
How to add new data if not existing already
Hello, I have data of all transaction of some members by their id in sheet1 and member id in sheet2. I have to add data of new transaction in ...
Vba if statement help!
Hello, I need some help with doing the following in vba: If column F has a date which equals zero then delete. If column F has a date which ...
How to run macros in other systems
Hi, I Created few macros in my system,now i want to deliver those macros to user,how i will give...? anybody help me please.Macros created in one s...
If cndition for activecell.value in excel macro
Hello, I need a query for excel macro ... If I click on empty cell it has to display "no job" If I click on any valued cell No function is oc...
