Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
how find out similar book name from the list Closed
Hello, I have a catalog in xlsx format in which there are many book name which are similar to each other i want to find out the book names which s...
-
How to transfer a block of data between to workbook Closed
Dear Sir, Please help me how to transfer block of data between two workbooks. Thanks in advance
-
macro to merge multiple files to one for selected column only Closed
Hi, I have hundreds of excel files that I want to combine into one file. The problem is that these files contain hundreds of columns of extra data th...
-
add new data from another workbook in excel vba Closed
Hi All, I have a problem with excel vba as below that need your help: I have 2 workbook (wb1, wb2). What I want is to loop through data in collu...
-
MS Office 2010 Save as message shows Closed
Hello, When working on a network shared file in MS Office 2010 , file opens quickly but when saving file shows Saving as massage comes & takes 40-50...
-
Conditional Formatting a cell based on an entire row. Closed
I'm trying to set up a sheet where I have field names in column A, rows 2-20, and dates in row 1 from column B to CD. This format works great for wha...
-
excel formula Solved/Closed
hello, hope you can help! working on an excel spreadsheet and require a formula: If cell a > 0 then cell b should equal the value in cell c thanks ...
-
COUNTA and COUNTIF IN SAME FORMULA Closed
So what I am trying to accomplish is this: I want to count the text in Range (B1:b5) excluding duplicates, however only if the text in range(a1:a5...
-
I need a macro that can extract data Closed
Hello, I need help with creating a macro that can automatically copy data from different worksheets and put it into a master worksheet for a repor...
-
Recover deleted emails in Outlook Express... Solved/Closed
Hi! Prompt please... Is there any way to recover deleted e-mail messages in Outlook Express? An important message was accidentally deleted from the...
-
Formula to extract data if found in another cel Closed
Hello, I have a large excel spreadsheet and need a formula that can extract data from one cell if that same data is found in another cell. So, for...
-
Code Visual Basic Solved/Closed
Hello, I've been unable to copy data from one sheet to another, based on selecting multiple criteria. I've been able to use the string below t...
-
Copy multiple rows depending on value of cell. Closed
Hello, I'm working on a excel-book where it is 3 sheets of data. In the 3rd sheet I want to be able to type in e.g. Ior and then get all the rows ...
-
compare range of cells and get the result of a third cell Closed
Hello, i have a file with 3 columns, i need to compare each cell of the first 2 columns and of it match print the data that in the third column th...
-
Copying a Conditional Format to other cells... Closed
Hello, I have set a formula to calculate how many days between two dates i.e. Date in A5 - date in A4 +1 = number of days in A6. Pretty simple ok....
-
Excell 2013 - conditional formatting using a formula- apply rule Solved/Closed
Hello, I am trying to do the following : A1:A100 ==> dates B2:B100 ==> dates 1) apply conditional formatting to columns C1:BB1 if the containe...
-
Excel Formula Display in Cell Solved/Closed
Hello, Apologize if the question is too stupid. In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to display the formula in cell A6 for this...
-
About open office Closed
Hello! How I,m donwloading full version Open office
-
Deadline alert Closed
Hello, I would like to change the colour of a date cell (target date) to yellow when it is 3 days away from the target date and remain yellow only u...
-
Copy multi data (range) from a set of excel files inside a folde Closed
Hello, It's my first post in this forum after a lot of visits that i`ve done in the past and really helped me a lot. Well the situation is this: ...
-
gorandhaka Closed
Hello, i want to open new account Configuration: Windows 7 / Chrome 41.0.2272.101
-
Day of week and date in same cell, autofill rest of month? Closed
Hello, Is it possible to put day of week and date in the same cell in Excel 2004, and then autofill down for the rest of the month? I have tried ...
-
How to open a PRN file in Office/Word 2010 Solved/Closed
Hello, How do you open a PRN file to see how it converted? I only want to open the document to see how it converted, not print it. I used Window...
-
categorise my customers into C0,C1,C2,C3 based upon there last s Closed
Hello, i want to categorise my customers into C0,C1,C2,C3 based upon there last service date & Date of Delivery. C0 are the customers who are not ...
-
Visual Basic Closed
I've been able to use the string below to copy rows to sheet 2 by selecting value ("5064") in Column G, sheet 1. I need to select more than one value...
-
Sending Emails Closed
Hello, I'm having trouble with sending. I am receiving like normal but my emails will confirm that they were sent but the person i sent them to do no...
-
Macro code to copy and past in new sheet last row of data Closed
Hello, I'm trying to write a simple macro to copy in one sheet a selected amount of column data (which varies by size each time) and then paste the...
-
Formula to find/replace if same data is contained in another cel Closed
I have a large excel spreadsheet and need a formula that can extract data from one cell if that same data is found in another cell. So, for example: ...
-
Convert to mm/dd/yy to dd/mm/yyy Closed
Hello, Pls help how to change mm/dd/yyy to dd/mm/yy in excel. Configuration: Windows / Chrome 41.0.2272.101
-
Day of week and date in the same cell, then autofill rest of mon Closed
Hello, I would like to know how to put the weekday and date into one cell, as in: Wednesday, 4/1. Then I want autofill to fill the rest of ...
-
Find and replace a specific number Closed
Hi All, I am new to this, so I hope somebody can help. I have a code CF|0612|1-12 in cell A1. That code is the code for an apartment block we...
-
Macro for Extracting Data Closed
I need helping writing a macro to extract data from column A and input into column B. Example data = 13A:123456789:V1 and what I need is the data betw...
-
cell color Closed
Hello, I have a worksheet with various dollar values in it. I want to write a formula to add all the cells that are a certain color (green or yel...
-
Some cell Date Could not change Solved/Closed
Hello, I was having the same problem and this solution worked But Some cell Date Could not change Configuration: Windows XP / Firefox 36.0
-
show formula with example Closed
Hello, hi sir/madam...i am doing some work with the students result in excel...but i faced a problem..it is simple but i havn't got that in my mind....
-
Pop-Up Closed
Hello, I want to know, how to set Pop-Up in excel, Suppose I will have make on payment on 30th March 15 so pop-up will alert me on 28th March 1...
-
Use information in one excel to update another Closed
Hello, I am trying to track batches being completed. We have different process steps. When these are finished, this is updated in individual excel...
-
Comparing data in 3 columns on a Microsoft Excel spreadsheet Solved/Closed
Would be really grateful for some help. I have 3 columns of different lengths with email addresses in them and I want to see all instances where th...
-
formula which calculates the percentage of these cells Closed
I was wondering if anyone could help me with a formula for some work I am currently doing. I have a set of data (numbers ranging from -0.8 to + 0.7) w...
-
Macro VB for Reconciliation Closed
Is it possible to write an excel macro that can do a simple recon for me, I intend to do as described below: If information in a selected column i...
-
Excel 2013 Formula - maybe IF formula? Solved/Closed
I have a list of names in Excel and I need to put their supervisor name in the cell to the right of each name. I would like to find a formula that wi...
-
epson t13 ink pads end Closed
The printers ink pads are at the end of thier service life. please contact epson support
-
Copying Data based on number from one sheet to another Closed
Hello, I would really like a VBA CODE which would help me to copy Data based on number from one sheet to another: So I have 5 projects(sheet1,s...
-
Call Equation According to choice Closed
Hello, When choosing from a data validation list, i want some cells to import specified equations according to the choice selected from the list ...
-
compare sheet 1 and 2 and copy to sheet 3 Closed
Hi, I got this code which compare sheet 1 and 2 and copy to sheet 3 data with similar data from 1 and 2. Now what i need is to cell from sheet 2 t...
-
Date Formulas Closed
I am wanting to know how to make a copy of the same spreadsheet many times and when I do I want the date on the spreadsheet to change automatically ea...
-
Need Help in Excel Closed
Hello, I have sheet which have 100 records of students obtained marks and I want top 20 students list on another sheet. Configuration: Windows ...
-
transfer certain data entered to another sheet auto Closed
Hello, I work for a restoration company. We often enter a list of what was done on the job during the day by employee into a spreadsheet. For exa...
-
Jen Closed
Hello, I have a document and want page numbers on all pages. After page 22 the page number do not show up. If I double click in the footer the pag...
-
Auto generate a list of items from another worksheet in excel Closed
Hello, I am trying to have an automatic list generated from a worksheet as I type in my products, some will be listed twice and I only want it to ...