Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Count appearances of specific words in Excel Solved/Closed
Hello, 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 Closed
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 Closed
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 Closed
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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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... Closed
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 Solved/Closed
Hello, 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 Closed
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 Solved/Closed
Hello, 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 Closed
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 Closed
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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Closed
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 Closed
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 Closed
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 Solved/Closed
Hello 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?? Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Solved/Closed
Hello, 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, Closed
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 Closed
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! Closed
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 Closed
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 Closed
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...
-
Macro to find a value in a worksheet Closed
Hello, I am new with excel macro and VBA codes.Can someone out there help me with the macro and VBA code to create an input boxes to seacrh and fi...
-
Set a Harddisk password Closed
Hello, Can any one advice me !!! I have a external harddisk , I want to put security to that , Like as a Scandisk Cruzer Flash Drive. If we insert ...
-
Title...lost password Closed
Hello, i have fogotten my memory card password which is 1 gb i really don't know what to do i have tried every code that come in my head and nw i am g...
-
Macro to define a interval Solved/Closed
Hello, i have a excel sheet of details of employee of the organisation. in that sheet I have a column D of age. I have to define age interval f...
-
Outlook not sending emails but receiving Closed
Hello, OK so. This morning we had major internet problems, and basically our company internet has been switched off and the ISP will not turn it b...
-
how to make xl readonly true or false on cond Solved/Closed
Hi, I have an requirement like need to open an excle workbook and make it as readonly false then copy some rows to dat workbook then again make it ...
-
Repeating formulas in excel Closed
Hello, I want to extend a formula to about 20,000 rows, so holding the fill handle will take too long. Is there any I can specify a number of rows?...
-
Copy rows based on a condition...revisited Closed
Hello, This question was asked and answered by HELPER. (I'll attach it below as I cannot find a reference number) My addendum to the question is;...
-
Excel Macro to find perticular column name Closed
Hello, Ii have excel having column names in row#1. I want to write excel macro that will look for column name anything that had 'ID' or 'AMT' i...
-
how can find unique data Closed
Hello, I have a data from April 2008 to Feb 2011 and i have to find no. of unique member visit every month. every member having a card no. and he/...
-
merge more rows into one Closed
Hello, i want to combine more rows into one based on the same first cell which contains the same number ex : 529251 0 2456018 6 529251 0 2456019 ...
-
Compare sheet 1 & Sheet 2 pull any items that Closed
Hello, I saw this posted earlier... did you ever respond to this? +++ Your macro has been a great help to identify the matching records- th...
-
sku011.cab missing Closed
Hello, I Tried to run regedit, BUT....... I can only expand up to OFFICE, After that there is no 11.0 What can i do? THANKS Con...
-
Copy row to next available row in another wb Closed
Hello, I am trying to copy row to next available row in another wookbook. I have the follow codes, but not sure why it skips 3 rows every time, th...
-
Vlookup Solved/Closed
Hello Sir, In Sheet1 I Have Numbers Like A-----------------B------------ 4050 6080 9060 And In Sheet 2 I Have Data Like: A--------...
-
Macro to format cells Closed
Hello, I hava excel data exported from a community page whihc will look like ttetetert -Row 1 yyyyyy Row 2 ...
-
Run a macro on another open application Closed
Hello, I have a list of account numbers which needs to be keyed on another application named CBS - "Core Banking System.WS - [24 x 80]" I had r...
-
excel help formula which capture this as Prod Closed
Hello, Can you please help me on this: The below data is in sheet 1: Products DATES VALUE A 2-Jan 1 B 2-J...
-
find, select, copy, paste elsewhere in para Solved/Closed
Hello, Can anyone help in the following matter: How to find, select, copy and paste elsewhere the paragraphs containing specific terms in...
-
Excel count if Closed
Hello, I am a school teacher that give "Marks" to students. The "marks" are leveled from 1 to 3. I have been inputting students into a spread shee...
-
Copy data from one spreadsheet to another Closed
Hello, Can someone please help? ABC spreadsheet will copy the data to 123 spreadsheet, if there is no match find on Project ID, Name and Part. If ...