Office Software Forum
- Excel (9,843)
- Open Office (114)
- Outlook (647)
- PDF (334)
- PowerPoint (184)
- Word (2,189)
-
copy many columns and past it in one single column Closed
Hello, I am trying to copy many columns C,D, and G and paste them into on column B in the first blank cell in the same sheet and I will need to do the...
-
convertion of numeric to text Closed
Hello, I have used your program for converting numeric to text in excel but there is problem regarding when we are entering greater than 100000 (o...
-
Search for a text in a column when found copy cell above it Closed
Hello, Boy Results Ttstm063 Mark Earned Points Earned Boy Results Ttstm063 Mark Earned Points Earned Boy Results Boy Results Ttstm063 ...
-
Aline data horizontally in excel using vba or vbs Closed
Hello, ...
-
If and logic Closed
Hello, I am trying to write an Excel formula where i have a condition statement that varies result. For example if my target figure is > 30 but le...
-
All permissions in protected and shared workbook disabled autom Closed
hello friends, Version: Excel 2007 OS: Windows 7 Professional Situation: I have a 1000 rows X 50 columns of data. Filters are applied on th...
-
Copy from one excel sheet to another Closed
Hello, I am trying to figure out if it is possible to copy from one sheet to another. Not the whole sheet, but rather I would like to put cells f...
-
how to send emails Solved/Closed
Hello, Please tell me how to get the blank form up to type & send an email on OE Configuration: iPhone / Safari 4.0
-
Short cut to merge cells Solved/Closed
Hello, If there a short cut on the key board to merge cells in excel?
-
Macro to connect to Paste All Clipboard Excel 2007 Closed
hello, I wish to make a macro that will paste All from the clipboard Excel 2007 ( do the same as the Paste All Clipboard button ) The cell is A1 sh...
-
How can I lock the column in excel Closed
Hello, If I have a table or Excel sheet and I made a function in a cell A2 and drag this function to be coped in all column A and finally I wan...
-
Macro to sort clipboard Paste all function Closed
WINDOWS 7 EXCEL 2007 Hello, I would like to make a macro that would convert the data below to (See-Below) LIFETIME RECORD STARTS WINS 2NDS 3R...
-
How to convert a numeric value into eng. word Solved/Closed
Hello, How to convert a numeric value into English words in Excel plz show that formula
-
Find and replace underlined words for a blank. Closed
Hello, This is my very first forum joined. I am on a quest to find the if there is a way to search and replace underlined words and replace them w...
-
Updating Excel that has Macros Closed
Hello, How can you easily update an Excel workbook that already is using Macros? I need to insert two columns but once I do, I receive errors. T...
-
Vlookup ? Closed
Hello, I have list of 1000 company names in col A and in col B 20,000 company names. I would like to know if the company in A appears anywhere in ...
-
Convert numbers to text format: Closed
Hello, i got a problem in my data. there are many soluations already available for converting text format to number. But how can number format ca...
-
Formating Date Solved/Closed
Hello, I have date in a cell now i want to see the next cell red color if the next cell is not filled up by the next 10 days from 1st cells date. ...
-
Help with comparing/deleting columns Closed
Hello, I will be eternally grateful if anyone can help me with the following scenario. I have 4 columns Vendor_Name Vender_Code In...
-
Formulas Closed
Hello, I ve forgotten some formulas used in excel. Please someone should with this formula used to set ranks eg, first, second, etc. Configur...
-
cpoying data from one sheet to another Closed
Hello, i have a excel file. in sheet on i have some data like sr no........name...........father's name.........roll no........ 1..............raj...
-
How to recover deleted .ost and .pst files Solved/Closed
Hello friends, Outlook.pst file deleted. Now I am unable to configure outlook now.... Pls suggest...how to do now...? How to recover dele...
-
product key for ms publisher just downloaded Solved/Closed
Hello, Configuration: Windows XP / Chrome 23.0.1271.95 how do I get the product key after down loading MS Publisher from your web site(X16-32...
-
Match barcode between 2 sheets Solved/Closed
Hello, I have two diffrent sheets. One sheets has tens thausand lines with barcode value,description and quantity of product. another one has 2...
-
Excel multiple function Closed
Hello, I need to put multiple functions into a one cell result in Excel. The result of one function (result A), squared (result B) and that numb...
-
i want to extract specific data from microsoft excell cell Closed
Hello, i want to extract the following details into another collumn (bold ) from data in collumn B1 into C1. The information i want begins with 3 di...
-
Office Publisher Closed
Hello, I have downloaded Office Publisher Free. while installing, it requires a CD Key. Where to get it from. Thanks
-
Deleting a progress bar from PowerPoint presentation Solved/Closed
Hello, I used the following method to add a progress bar to my PowerPoint presentation - now I don't like it. https://ccm.net/faq/937-insert-pr...
-
How can I eliminate #VALUE in calculated cells Solved/Closed
Hello, I am building an Excel calculation sheet for cookeries for christmas. In cell H$7 I have the input for how many times I would like to ...
-
Excel/Toshiba problem Closed
Hello, having a problem in Excel. my arrow keys seem to work spontaneously and are continuously scrolling me across the screen - makes it difficul...
-
How to find missing numbers in a seperate column from 2 columns Closed
Hello, I have data in 2 columns (given below) and want to compare both the columns and want to get the missing numbers in seperate column. e.g ...
-
Convert number into words in excel 2007 Solved/Closed
Hello, i'm trying to convert number into words in excel 2007. i've written coding in VB module. But I don't know how to get it in my function list...
-
convert currency (Indian) into words Closed
Hello, daer Sir, i need to convert currency (Indian) into words while working on my excell work sheet,as in Excell there is no farmula availab...
-
How you can get an atomatic serial number in a particular column Closed
Hello, Suppose A1 is serial, B1 persons name, C1 amount due, D1 amount paid, E1 invoice number, F1 is invoice date and so on, that is A2, B2, C2........
-
Excel Macro Sort and Data series Closed
I'm looking for a macro that will accomplish 2 things: first I want to sort a range called "data" primary key is "com", secondary key is "cvt", next ...
-
my office is not opening Closed
Hello, actually bymistake i delete some files, which was related with office 2003. now what happ one message keep flashing on my screen, which say y...
-
Conditional Formatting Highlight Entire Row Based on Date Closed
Hello, I'm trying to highlight an entire row in excel if the date in column B is later than today. Can you help? Please. Configuration: Window...
-
Help with a VBA code Closed
Hello, I'm trying to configure the DEL key to clear the contents and Unlocked the cell (if Locked). I create the module: Public Sub MyDelKey() ...
-
converting number into words (Excel) Solved/Closed
Dear friend, Pl.provide me a formulla which can translate currency number into words i.e. 12,34,56,78,910.91 into Twelve Arab,Thirty Four ...
-
Look for values from a different sheet and return it Closed
Hello, So I am working with a file that has 2 sheets. Sheet 1 has columns A,B,C,D Sheet 2 has Column. A B C D For both sheets, column A= ...
-
Macro Help Closed
Hello, I wrote the below macro but my problem is the number of rows change each month so i would like to have an autofill the formula from column ...
-
copy range depending on a cell values Closed
Hello, i am looking for a script that gives me the following : column A to D contains my data that I want to copy to another sheet, E/F contai...
-
Help with VBA Solved/Closed
Hello, I'm trying to program a macro in Excell 2010. What I need it to do is look in a Range for the NotEmptyCells and change their property fro...
-
Copy data into next empty cell in new sheet Solved/Closed
Hello, I am trying to make a 2 sheet workbook which has the input details in Sheet1 A1 and this is changed weekly but the info in this cell shoul...
-
Copy rows a set number of times Closed
Hello, I have a delivery manifest that shows the amount of products coming in, descriptions etc. that we use to produce barcode labels. Unfortunat...
-
Organizing data Closed
Hello, This is not as clear as it could be but I will try. I have a spreadsheet that has two columns. The left column (A) is populated by 8-Digit ...
-
Excel VBA/Macro for Keyword based search on listed URLs. Closed
Greetings respected team, Kindly advise if it is possible to create an Excel based VBA or Macro that helps search predefined keywords in predefined...
-
macro to create sales report Closed
Hello, i have a set of invoice] in excel formats in a folder. I need to generate a sales report for this. sales report should contain bill no, dat...
-
Worksheet Columns added into one worksheet Closed
Good Day! I need to take Column/Row: M18 from worksheets 05202011 thru 12302011 (example: sheet 14 thru sheet 46), add and enter in to blank/anothe...
-
Auto filter problem Solved/Closed
Hello, when i am filtering any item for adding value in that item, it will gets filter but the blank cell coming at last is much further behind th...