Office Software Forum
- Excel (9,794)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
-
Unable to open word file Closed
Hello, I recover my some deleted ms word 2007 file but it unable to open. it show the file is corrupted . i tried some method and softare but cant...
-
Transfering data from one sheet to another, but not duplicating. Closed
Good day all. Checking to see if anyone could help out, as iam very new to the excel world. I have a sheet that I am transferring data to another s...
-
file convert procedure from pdf to jpg Closed
dear sir, please give step wise procedure for converting pdf file to jpg file by return email at the earliest thanks & Regards Surekha Surve
-
Macros for formatting a data dump Closed
Hi All, I am new to macros and was looking if some 1 could help in coding a macros for formatting of the data. Below are the issues/Steps 1. Th...
-
Excel: Unique count of values in one column conditional 2nd colu Closed
Hello, Column A Column B: WEST-WARD,INC. 00015 WEST-WARD,INC. 00015 HOSPIRA 00016 ROXANE LABS. 00017 GLOBAL P...
-
Conditional Formatting in Excel Closed
I have built a GANTT chart using Excel, and have been able to create the formulae in the task bar cells that allows the proper display of those bars i...
-
Error when creating mailmessage Solved/Closed
Hello, Using Excel and Outlook 2007 I want to create an emailmessage with a Macro. But I am running into an error I can not find any "comprehensi...
-
Calculating days between clinic visits Closed
Hello, I have a database with two columns, column A is date of clinic visit, and column B is patient name. I would like to be able to calculate th...
-
Copy data to another workbook and auto fill Closed
Hello, First, I Have excel data base that he have information in 3 Column A(id numbers),B(First Name),C(last Name). I have another Excel workbook ...
-
From Excel, Open a word document and goto a page question Solved/Closed
Hello, I have an Excel document which I have inserted some VBA code to open a word document; Set WordApp = CreateObject("word.Application") Wo...
-
Activation Key Closed
Hello Guys, Since i formated my HD, my Ms Office pro plus 2010 keep displaying YOUR MS OFFICE COPY IS NOT ACTIVATED, code error 0x8007232B. who can ...
-
Outlook 2007 wont recieve mail Closed
HI, I recently changed my OS and then had to install microsoft-office, when i configured my outlook, it does not download any inboxes yet on my other...
-
error while sending mail via distribution list MS 2007 Closed
Hello, Dear All, I'm using outlook 2007 for years and my operating system is windows 7. I have created distribution lists long ago and use them almos...
-
Getting a Cell to Flash When it's Below a Value Closed
Hi I am trying to make cell B3 flash when the value in it drops below 500 and stop when it goes above it. I have this macro running but it does not...
-
Create macro to search for a cell value Closed
I have 2 separate excel (2010) workbooks I'm working with and I would like to create a macro that, when run, will copy a variable value that is in cel...
-
Making a counter in Excel.. Closed
To Whom this may concern, I have been trying to make a counter on excel. I have been reading some of your posts but they talk about counter with a...
-
MAX value in one coulmn based upon another column Solved/Closed
Batch Price Column C 00015 2.75 00015 2.9995 00016 1.89 00017 0.56116 00018 0.1421 00018 0.11808 00018 0.1605 00018 0.12575 00018 0...
-
how to extract particular data's from sheet 1 into sheet 2 Closed
Hello I have three different columns in Sheet 1 with names Number, Step Description and Results. Each column have data's up to 100 rows. I want to ...
-
Transferring data from a column into several rows Closed
I have data in a column on one sheet that needs to go into several rows in another sheet. Example: Column A has the following data (A1:A200): 1 2...
-
how to remove 0s from excel pivot (2010) Closed
Hello, Do you know guys how it is possible to remove zeroes from an excel pivot when the field is not in the report filter but in row label. I have...
-
Highlighti Row/ colour fill through VB Solved/Closed
Hello, I am after a code which enables me to highlight/ colour code a row on basis of expiry date and update every time I open that exel file. f...
-
How to do in excel Closed
Dear all, Pls suggest for my following issue related to Microsoft Excel. I created a Report in Excel having many sheets. In all sheets, Subscrip...
-
VBA - How to open a pop-up that does not stop the macro? Closed
Hi everyone, I would like to add a pop-up (like MsgBox) but I don't want the macro to wait for the user to click on any button. This mean a MsgBox sa...
-
Number of decimals in a conditional format Closed
Dear reader, I need to highlight a cell that contains more than 2 decimals. ex. 2,89 is good and should not be highlighted 2,899 is wrong a...
-
Comparing Data in Excel Solved/Closed
Hello, I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered ...
-
multiple functions in single cell Closed
Hello, I want to put following 2 functions in single cell ROUND((C365*0.9144),2) CEILING((D365),0.05) Pls advise
-
Conditional Formatting Excel 2010 based on content in other cell Closed
Hello, I have a conditional formatting issue - and I think maybe the cause is that outcome is already a formula? In cell U5 I have the following...
-
Re: Make a macro run when data entered in a cell -multiple event Solved/Closed
Hello, I have three macros in the module and I want each macro to runs when the user changes the values in the cell (Cell F2) to "first", "second", ...
-
compare columns match and insert data from another column Closed
Hello, have a sheet with following info A B C D E F G H I J date-sum-item percentage- date sum item now i need to match the date su...
-
Daily attendance sheet that calculates monthly percentage Closed
I am trying to design a daily attendance sheet that students sign in on via computer, but I need it to also have a column that shows their attendance ...
-
conditional format Solved/Closed
Dear reader, I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel. Example. NL08569638 ...
-
Comparing Data Closed
I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered into any ce...
-
excel Closed
Within an entire excel sheet, I would like the entire row to turn into red font when I type the number 10 into any cell in column H. For example, ...
-
Look at column and match and add this text te Solved/Closed
Hello, I am working with Excel 2003. I need the formula to look in Column 1 and look at all these names. and compares the name if it is Sally the ad...
-
How to print data in multiple excel sheets Closed
Dear All, I am new to excel coding. I need help regarding the below issue The below sub routine is the first sub routine. It gets the details fr...
-
Copying Excel Formula in different ranges Closed
I want to copy a formula using different data ranges. The formula can't take dynamic range once copied. Example I want to use sumif formula from...
-
Excel Macro - Selection of data from column using flag (0 or 1) Closed
Hi, In Excel, I have a column of data and corresponding flags (either 0 or 1) in another column. I want to copy only those data which correspond ...
-
convertion Number into word Solved/Closed
Sir, How can convert Number into word in excel sheet. suppose there is 253900 in cell B2 in excel sheet. How can I convert this number as Two lakh ...
-
40 % add formula in excel cell Solved/Closed
i want to increse 40% amount in my excel sheet and I have total quantity 90 can anyone like to tell me that how will I entre the 40% in excel cell tha...
-
How to Remove Background of an Image using PowerPoint 2010 Closed
Usually, only a graphic designer is skilled to modify images. However, with Microsoft PowerPoint 2010 users can do simple artwork such as removing the...
-
INSERT ROW DATA INTO EVERY SECOND ROW Solved/Closed
Hi I have an excel sheet with blank rows every odd line (i.e rows 2,4,6,8...700 are empty). I have to paste a row of data (the same all the way th...
-
macro Solved/Closed
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 13/05/2013 by dhale ' ' Keyboard Shortcut: Ctrl+a ' Application.Goto Reference:="onecell" ...
-
Incoming and outgoing mail servers Solved/Closed
Hello, I am having multiple email accounts. I like to configure all my email accounts in OUTLOOK EXPRESS. I am not able to do the same in OU...
-
Macro VBA message run-time error '1040'/ I am getting this messa Closed
I akeep getting error message any time a try to test the Ctrl code. Please help. b PrintChart() ' ' PrintChart Macro ' Created 5/7/2013. Macro...
-
Multiple If Statement not returning numbers - returning words Closed
Okay now I need the column to say if the amount in c18 is 500.00 then put 20.00, but if c18 is 38.46 then put 38.46. When I enter the formula below, ...
-
graphic will only move up- all arrows nudge it up Closed
After copying an image into word, I'll set it to be behind or in front of text and try to position it exactly where I want by clicking and dragging it...
-
PDF won't open Closed
Emailed attachment in PDF won't open in my windows XP. After double clicking the file it asks for ... tried all the selection (as I don't know what to...
-
How to find out two words matching with one additional Number Closed
Hi.. Please tell me how to find out matching two words with only one differnce. If Two Columns of Excel contains Data like Vehcile Numbers MH01A123 an...
-
Greater than/Less than between 2 Dates Solved/Closed
i am trying to to populate a spreadsheet that if the date is less than 01/01/2013 then populate the cell with $500.00, if the cell is equal to or grea...
-
Macro to highlight cells. Solved/Closed
I am very new to VBA and have spent countless hours looking for help on the web. I have a worksheet with 100,000 rows(locations) and 34 columns(Cha...
