The discussions
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...
Comparing five column values in a row
SolvedHi All, I am new to office excel and need your expert help to resolve one issue: I have five columns in different rows with values and I need to...
How to pull content from 4 cells to 1 cell
SolvedHello, How can I pull content from 4 cells to I Cell in a specific format so that I have it displayed like this: sm=12.00/W123/F456,MD=13.00/W456/...
Vba 2010 open files in current folder loop
SolvedHello there, Think this is a relatively simple code and I've found examples but can't quite piece it all together to do what I want to do. I want t...
Convert pdf to epub on my iphone
SolvedHello! I would like to convert a PDF file to ePub format for reading it on an iPhone. Is there an online/desktop tool that will allow me to do that?...
Vba locate & delete words within a sentence
SolvedHello, I know this is probably very easy but I'm having trouble figuring it out. I'm trying to find a code that will identify key words within a s...
Vlookup not working as expected
SolvedHello, Sorry for my last post I didn't mean to be rude, just posted technical info, so can you please help me? I tried to figure out this by my...
Xl help required
SolvedHello, I need a help for one of my workbook. I have a workbook with a sheet name master and contains the below data: Nokia ...
Password issues
SolvedHello, I bought my acer aspire one zg5 model netbook from a friend and needless to say did not come with a owners manuel so I'm at a total loss when i...
Vlookup with dropdown dont popilate
SolvedHello, I have a dropdownlist lets say in A1, in B1 I have a vlookup that looks up a range from A1 in a diferent sheet (=IF(E10="","",VLOOKUP(E10,'...
Vlookup table_array parameter as a variable
SolvedHello, Configuration: Windows XP / Safari 534.30 I have this piece of code: ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-10],Position!R2C1:R5...
Releasing filter before running a macro
SolvedHello, dear all friends, good morning. I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will be able to store ...
Duplicate data
SolvedHello, all Please can you help??? I have duplicate data, lets say, Ben Ben Paul Paul Paul Ben Alan I want to lookup the Ra...
Highlight rows with conditions met
SolvedHello Friends, I desperately need a macro to Highlight /or separate rows when specific conditions met. sample file enclosed. Link http://www.spe...
Don't display zero if result is null.
SolvedHello, I'm a newbie, I can't figure out how to get Excel to put what's in a cell to another cell if the cell has a blank in it. For example, there...
I forgot my password
SolvedHello, im using samsung gt c3210 plz tell me how to unlock my mobile Configuration: Windows XP / Safari 534.30
Phone password for samsung gt 3653
SolvedHello, hi i would like ask if what is a password for samsung GT 3653? thanks!
Calculate the hours per bed in a week
SolvedHello, I need a formula to calculate the hours per bed in a week divided by average occupancy rate. Which formula I should use? Many thanks! ...
Sharepoint link to excel via a cell variable
SolvedHello, Configuration: Windows XP / Internet Explorer 7.0Hello, Wonder if any of you gurus can help with the following, as it has got me totall...
If functions with time functions
SolvedHello, I am trying to combine several IF conditions but ir appears that they are always getting an error, can someone help me? The formula is a...
Remove "calculate" from excel.
SolvedHello, When opening a saved sheet with data in excel,I get to see "calculate" mentioned on the bottom left. The problem is when this "calculate" i...
Excel/vba 2010 continue with macro
SolvedHello, Just a quick question I've got a Macro that runs perfectly except there are two times while it runs where it stops and asks you to click Ok...
Help with finding a pasword
SolvedHello, I have a Acer Extensa 5220 and my XP stops by the account and asking for repair. I can't do that because my BIOs setup ask for a password Aft...
Forgot security password
SolvedHello, Please help me i forgot security password of nokia mobile Mobile Model No: 1200. EMI No: 356816025146415. Configuration: Mac OS X ...
Vba conditional formatting excel 03
SolvedHello, How can i apply a conditional format on a certain cell but with the condition in a different cell. F.e. if a cell in range C1:D5 (f.e. C...
Conditional hide column
SolvedHello, I need someone to help me please. I want a VBA code in excel that will look to a value in specific cell (i.e: A1) in one sheet only and i...
Excel 2007 - macros
SolvedHello, I need to write a macro for following example. Item Qty c 2 B 2 b 6 C 5 c 5 a 2 Basically I want to group by Column A (i....
Forget mobile tracker password
SolvedHello, Sir *2767*3855# *2767*2878# this code not working on Samsung 3310 metro mobile..please help me..... Configuration: Windows XP /...
Highlighting and copying in excel
SolvedHello, I am just starting on visual basic and would like to record a macro whereas, once I have pressed play, Excel will select a cell 12 rows dow...
Printing excel sheet with jumbled columns
SolvedHello, Dear all, I have a typical question. I have a work sheet in excel 2007 with some headers in columns from C8 to N8 the columns C to F have t...
Excel office2007 macro
SolvedHello, I writting a macro to clean up the format of a report down loaded into excel. I'm stuff on on section. I have filter column A for blank cell...
Page numbering issue - word 2007
SolvedI am a novice at working with Word 2007. I am trying to create footer with just the page number and document name. Unfortunately, when I create a fo...
Excel - cells formatted as numer pesel ???
SolvedHello, Firstly, just a quick one: I want to use conditional formatting to check if a cell ( say A1) has a red background and if it does then re...
Deleting and combining rows in excel with con
SolvedHello, I hope someone knows the answer: I have simple table Column A: item # Column B: text example: Item # Text 2 text 1 2 t...
Compare workbooks&highlight conditional match
SolvedHello, I am having 2 works sheets. First "order" book ,which is not having Invoice no and date.( cloumn B & C) second book "invoice" havi...
Damaged pdf file
SolvedHello, I have been working on a project in photoshop and today a file I have been saving as a PDF won't open, it says it is damaged, but it has bee...
Dell studio 1555 laptop forgot password
SolvedHello, i have a dell studio 1555 laptop and I forgot my password. im at the screen where it says my name ask for the password Configuration: ...
Split worksheet
SolvedHello, Is it possible to Split one worksheet to different workbooks( files). I am having a statement to be send to 10 branch offices. sample...
Break input password
SolvedHello, plz i wanthow we can break input password i had forgetten my password plz solve my problem thanx Configuration: Windows 7 / Safari...
Acrobat reader free 9 version
SolvedHello, Configuration: Windows XP / Firefox 5.0acrobat reader free 9version
Partial match multi-sheet comparison
SolvedHello, I am trying to compare a manufacture's part number in a spread sheet with a spreadsheet that we have to match these part numbers to their U...
Hotmail password
Solvedi have forgot my password and security questios.i am affraid i have too much data in my hotmail account.i want to get my data but i did not find any i...
Inserting/copy rows, transpose vba help
SolvedHello, I have searched through many posts and it appeard everyone is very helpful. My skills in vba are ok but i lack the knowledge to solve my prob...
Merge rows if it meets criteria in excel
SolvedHello, I would like to know if I can merge rows if it meets certain criteria in Excel. If Project ID on column A is matched, it will merge all the ...
Conditionally deleting rows in excel 2007
SolvedHello, I'm hoping someone here might be able to help me with this. I have a spreadsheet where column A is a project name then columns B, C and D a...
Returning value if criteria falls w/i range
SolvedHello, I am trying to create a spreadsheet that will lookup and return the value from column C, when the given criteria falls between columns A an...
Webpage to excel
SolvedHello, Could you please help me in downloading data's from a web page to an excel. If that web page has multiple pages ( 1,2,3,4.... ), i want all ...
