Office Software Forum - solved topics
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
- Solved
-
phonelock forgot the password Solved/Closed
Hello, how am I going to open again my phonelock ?? I have forgotten my password . please help . cherry mobile c2 Configuration: Windows 7 / ...
-
Sorting and extracting data... Solved/Closed
Hello, I need to extract the data from from the cells of Column "B" and placed it into cells of Columns "E" by comparing Column"A" and Column"D"....
-
IF Function Solved/Closed
Hello, I am just starting out with formulas and I need some help. What I need is: If the value in Sheet 1 B2 is found anywhere in Sheet 2 colum...
-
Cells display a total or text Solved/Closed
Hello, I have an excel workbook that has cells that display a currency amount U43, U45, U47, U49, U51 and Q53. For example U43 would have $200 in...
-
Outlook 2007 email randomly not sent Solved/Closed
Hello, the problem started a few days ago. Randomly Outlook 2007 does not send a message. Looks like it is mostly when I reply to another email. I...
-
conditional format more then 3 Solved/Closed
Hello, I have seen a solution on your web from aquarelle, but how do i put that in my excel, sorry maybe its a basic question. But i have tried i...
-
Excel transfer selected rows Solved/Closed
Hello, I have in place a data validation,''list''. I want to be able to transfer selected rows with the different list names into separate worksh...
-
Excel Data Validation Solved/Closed
Hello, 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! Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
hey 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
hey 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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... Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Dear 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi 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 Solved/Closed
Hello, 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. Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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/Closed
Hello, 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 Solved/Closed
Hello, 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? Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Can 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 ...