Office Software Forum - solved topics
- Excel (9,851)
- Open Office (117)
- Outlook (652)
- PDF (334)
- PowerPoint (185)
- Word (2,189)
- Solved
-
Please help - run macro when switching sheets Solved/Closed
Hello, If someone could tell me how to run a macro upon switching worksheets, that would be extremely helpful. If this is not possible, perhaps ru...
-
undoing a macro to retrieve info back Solved/Closed
Hello, If I accidentally run a macro, can I (edit undo) to retrieve the information back to how it was? Configuration: Windows XP / Internet Ex...
-
macro to blank out filtered columns Solved/Closed
Hello, I have a worksheet that is filtered by a number. I would like to blank out columns M, N, S and T. (Only the filtered information) Can yo...
-
excel conditional formatting Solved/Closed
Hello, if date in cell A1 appears anywhere from B1:B30 then apply format. Configuration: Windows XP / Internet Explorer 7.0
-
Return a value from a data set Solved/Closed
The problem is I have number 1 to 10 in A2:A11 and number 10,20,30....100 in B1,C1,D1..... K1 and there are corresponding values in the cells under th...
-
default password for china moblie X.E88 mob ? Solved/Closed
Hello, i need default password for china moblie X.E88 mobile ohone.. pls some one help me..
-
3 dropdownlists Solved/Closed
Hello, Please help I want to make 3 dropdown lists in Column B2,3,4 and all must work together. In B2 i must have a selection of e.g Building,Person...
-
Code to open a tabs from combox excel Solved/Closed
Hello, I'm looking for a code, i can put in a combo box to show up different tabs located in my spreasheet. example: I have four tabs called tab1,...
-
Excel 2007 days and dates issue? Solved/Closed
Hello, I was working to have the week numbers in excel and i step into a question when i entered in cell "B1" the date 05/1/2010 and i changed the...
-
Look for a value into different ranges Solved/Closed
Hello, PLeas take a look on the following data A B C D E Range 1 Range 2 NAME 81000...
-
forget my phone password Solved/Closed
Hello, sir i forget my phone password please help me
-
Excel Formula Solved/Closed
Hello, I am looking for a formula or script that can help me with the following. I am doing a spreadsheet for 19 different offices (on seperate...
-
Matching columns Solved/Closed
Hello, I have to an issue with matching columns. Column A Column B Column C Column D Column A: This has 300 lines with account #'s Column...
-
IF Statement Required please Solved/Closed
Hello, Date 1 Date 2 Days varience Status 04/05/2010 29/04/2010 -5 On Time 04/05/2010 06/05/2010...
-
macro that takes multiple csv files and puts Solved/Closed
Hello, I need a macro that takes multiple csv files and puts them all in 1 worksheet. The csv files all have header info that i do not want copied ...
-
MS Office 2007 opens files as Read Only Solved/Closed
Hello, I installed Office 2007. Each time I open a file in Excel, it opens it as Read Only and won't let me save with the same file name and thus...
-
Excel 2007 "If....Then select Row and move&qu Solved/Closed
Hi all! I have what would appear to be a basic question, but can't seem to put my brain around the solution. I have a spreadsheet on Sheet 1. O...
-
Copying data in a dfrnt sheet w/ condition Solved/Closed
Hello, Greetings everyone... I want to copy data from one sheet to different sheet but only if a condition is true. For example, 1st Shee...
-
Label name protected Solved/Closed
Hello, I was wondering if someone can help me. I want to know in this file at this address: https://authentification.site/files/22686748/Mac...
-
5130c Forgot my Mbl memory card password Solved/Closed
Hello, Im Using 5130c.... I forgot my password.... i Cant able to enter in My Memory Card plz tel hw to solve this problem.... Configurati...
-
Excel: Find & Offset Solved/Closed
Hi can someone help me to get a macro code to make following: I have a file in which some cells having data as 10000, > 10000 and some others 10000...
-
Code for copying whole data in auto filter Solved/Closed
Hello, Configuration: Windows 2003 / Internet Explorer 6.0 i am using excel 2007. i recorded a macro to copy segregate the data from data t...
-
Autofilter tp leave out #N/A in macro Solved/Closed
Hello, I have a project id in column C , which iam checking from another source data which is there in a differenr tab .So ihave a vlookup fprmula...
-
Formula reads only till 12th on month Solved/Closed
Hello, If I run the following formulae it gives the result only from 1st to 12 of the month. Is there any thing wrong with the formula or with my Ex...
-
Writing a macro Solved/Closed
Hello, I am trying to get data whcih has been inoutted into one workksheet to copy into another worksheets when it meets a command in one of the c...
-
Excel, IF fuction with cell text values? Solved/Closed
Hello, I would like to include the text value of a cell in the statement I have for one of the IF options. So far my formula is -: =IF((B1...
-
Deleting cells based on cell value of samerow Solved/Closed
Hello, When I delete cell D4 (it's contents turn to ""), I would like cells C4, E4, F4, G4 to be deleted as well. The row must still exist, so on...
-
IF Solved/Closed
Hello, If A1 = 80 then B1 = 100 or if A1 = 50 then B1 = 90 both these formules are in the same cell, Thanks Configuration: Windows XP / Interne...
-
List 2 columns into one Solved/Closed
Hello, I hoping that someone can help me fix this. I have two columns with possible duplicate vendor name, example VendorName ...
-
Highlighting dates conditional formating Solved/Closed
Hello, How to highlight dates in "EXCEL" i mean Less than Today = RED Today = YELLOW Greater than Today = Green Please help me i've been...
-
I need a formula for excel Solved/Closed
Hello, Here is what I need and cant find anywhere: IF A12="text1 (anywhere in text)",then b2="text2" please help provide a formula that ca...
-
excel formula file linked Solved/Closed
http://wikisend.com/download/466894/Check1.xlsx Their is a description on the file about what i am trying to do. besicly check one value to a list,...
-
Macro to compare and delete rows Solved/Closed
Hello, I'm a new b when it comes to macros. I'm looking for the best way to compare data in 2 sheets. If data in column A matches on both sheets...
-
Calendar Control 10. Solved/Closed
https://authentification.site/files/22400897/Book1.xls Please view the attached link to see what i would like done. Thanks Configuration: Windo...
-
problem formatting date Solved/Closed
Hello, I'm trying to use "date" to format cells in Excel 2003. I've selected number>date>mm/dd/yy. So, for example I enter today's date as 05201...
-
Contract dates due to expire within 3 months Solved/Closed
Hello, In Excel 2003, I have a list of all contracts with expiry dates. I need to add a colum entitled Due to run out in next 3 months. How do I ...
-
Macro to send email from Vlookup cell value Solved/Closed
Hello, I am trying to create a macro that will among other things send an email to each address in a cell. The only problem is that the cell with ...
-
Adding of the int values based on condition Solved/Closed
Hello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in column D. I...
-
Addition of the int values based on condition Solved/Closed
Hello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in column ...
-
Add up the values of duplicate cells Solved/Closed
Hello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in ...
-
Column match Solved/Closed
Hello, I have two columns in excel 2007. Both columns show menu items from another computer system. So, as an example different roles in our com...
-
Getting values from other xls file Solved/Closed
Hello, I have 2 xls files (book1.xls and book2.xls). In book1.xls the first column (A1) has certain names in first 10 rows (say x1, x2, x3, x4, .....
-
micro sd memory card password is forget Solved/Closed
Hello, i use NOKIA 3110c mobile. MY micro SD memory card password is forget. how can it find give me any solution. my id is : ...
-
micro sd 1Gb password forget Solved/Closed
Hello, . now i am using nokia 6085 mobile .. i forget my possword in micro sd 1 GB memory card.. plz tell me the solution what are the steps to fo...
-
Excel - Macro copy Date for "n" month Solved/Closed
Hello, Would you please help me to create a macro for generate Date schedule to Sheet2 It just like an installment schedule. Sheet1 Col ...
-
Lookup last name in a range Solved/Closed
Hello, = LOOKUP(1E+30,Sheet3!E118:E141) I jused this formula to look up the last date of a range, but now want to change it to names but it won...
-
Counting values in Multiple ComboBox's Solved/Closed
Hello, I'm looking for some assistance with excel VBA, it would be great to gain your assistance. I've created a UserForm with 4 x ComboBox's, ...
-
What funtion/s should do I need Solved/Closed
I'm working on tool for a user to input a qty of items, then calulate the number of cartons required. The cartons come in 1, 5 & 20 unit packs. ...
-
Multipul equations resulting in 1 answer? Solved/Closed
Hi all, Recently I asked the question below: https://ccm.net/forum/affich-348337-value-error-when-sourcing-data-from That solved the pr...
-
IF CELL A1 HAVE DATA IN COPY DATE IN B2 Solved/Closed
Hello, please can you help on how the following works in excel. In excel 2007: If cell a1 are 1,2 or 3 then the current date displays in b2, or if da...
