Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Dynacom Renconciliation Closed
Hi, i am using Dynacom. my previous months reconciliation were all balanced, but all of the sudden, without changing the cash account, they all becam...
-
Macro to rearrange data in excel- merge 3 cells and move sheets Closed
I am just starting to use macros and am lost on figuring this out. Inventory comes in a 9x9 box with position 1,1 (rows, columns) in the bottom lef...
-
macro to delete rows matching certain column criteria Closed
site: https://ccm.net/faq/6261-excel-a-macro-to-delete-rows-with-specific-values I have reviewed this VBA code and it keeps getting stuck when it ...
-
How to reference Excel information onto other sheets Closed
Hi, I have imputed all the information onto excel sheet 1, now I need to consolidate all the information from this sheet onto another excel sheet 2...
-
Help. Difficulty with adding a new row Closed
Hello, so I am working on a payroll excel sheet which pretty much tallies up the number of hours that each employee does bi-weekly. On my first worksh...
-
Opening Word 2007 docs with Word 2010 Solved/Closed
So I installed Office 2010, and removed Office 2007 from my computer (I had lost the product key, so it was in view-only mode, it's a long story) - ob...
-
Macros for counting the record count of each sheet Closed
Hi , Anybody plz help me in writing macros to prepare summary of records i will be uploading txt files into excel each file will have header and...
-
Conditional Formatting as a text Closed
I'm trying to create a conditional formatting to come up as a text. For example I want an if then statement... if the cell = 7, I want a text to com...
-
Macro with variable rows Closed
Hi I am very new to macros and trying to record (rather than write through vba) a macro that can be used each week. The purpose of the macro is to f...
-
cell blocking Closed
Hello, i need to block the cell after entering data to it which means i need each cell to accept entry one time only note.the worksheet must be pr...
-
What to do about messages about corrupt tables in Microsoft word Closed
Hello, I am receiving message that I can't create or save tables in ms Word 2003. Many different messages. Intermittent problem but I can't count...
-
Change date format Closed
Hello, I want to change date format from D/MM/YYYY (as it's being downloaded from a google form) into YYYY/MM/DD but I can't get it to work. A...
-
Table relation Closed
Hello, Ok This is the scenario, I've a excel sheet, with inside 2 sheet. In sheet1 i've a table with some some datas. In the collum B there ...
-
Coping one cell values into different excel sheets by different Closed
I have one cell vales. I want to store that value into different cell in different sheet. Suppose I have 10 in cell A1 from sheet 1 today which will ...
-
VBA for copy/paste a tutor perhaps.... Closed
First of all, Excel is not new to me, and although I am not fluid on creating pivot tables, I can create some pretty awesome formulas on my own...and ...
-
Comparing sales of Mondays Closed
We have an excel spreadsheet of sales for the year. The headings are Monday thru Friday. The rows are labeled for different categories. We would li...
-
Convert mm/dd or mm/dd/yy or mm/dd/yyyy to Excel internal format Solved/Closed
I have looked at dozens of articles, but they all talk about converting different forms of mm/dd... etc. to other similar forms. I want to chart bloo...
-
Ôter la protection Closed
Bonjour tout le monde, j'ai un problème qui me bloque depuis un bout de temps, je veux ôter la protection des structures et fenêtres pour un classeur ...
-
Macro Closed
Hi Team, I wanted to create macro which can select some data from cell A1 (not whole cell) eg if i have 10 characters in cell A1 i want select only 5...
-
How do I lookup a value in say column and in returning the found Closed
Hello, How do I lookup a value in say column and in returning the found value replace the it with a typed value. An example is; a b ...
-
Unable to send email with outlook 2010 Closed
Hello, i cant send email on outlook 2010 my web mail is binsowaidan.ae Configuration: Windows / Chrome 45.0.2454.85
-
Google sheet Help required Closed
Hello, i want to print some 18 document in Google sheet as a PDF format. i want to create a formula, by which. If i enter the default value in ma...
-
=IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>" Solved/Closed
Hello, I am at the crossroads with this functions string (doesn't work) any help will be much appreciated... =IF(F21="CTF",I21*15,IF(L21="CTF",O21*...
-
Convert numbers to Word format in Rial Omani currency Closed
Hello, I like to Convert numbers to Word format in Rial Omani currency, say for example - 8,823.200 should be written as Rial Omani Eight Thousand...
-
Sheet1 value in Sheet 2 Closed
Hello, I have different DATA in a ROW of various Column of sheet1 (for specific date). Now in Sheet2, I have to use these DATA in various places. ...
-
how sum the total for paticular value Closed
Hello, we have the stated contains as below Region product amount sales Chennai apple 1,854.00 * Delhi apple 4...
-
IF function for "specific date" + 15 calendar days Solved/Closed
Hello, maybe you can help with the following... I am looking for an IF function that alerts me to "PAY NOW" or to "HOLD" as follows; PRODUCT ENTRY ...
-
My compliments, great altruism everybody! Great forum! Solved/Closed
Hello, everybody in the forum! My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated! A big hello, especially t...
-
translate spanish to english of a pdf file Closed
I need to know how I can translate a large PDF file from Spanish to English
-
forgot password on locked folder Closed
Hello, hi i forget my locked folder pass. i have the file with me. but i tried to open with the pass i always use but cant open. i need the date in...
-
Macro copying data to another workbook Closed
Hello, After running the macro, WB2 doesn't have 6 7 8 9 0 1 2 3 4 5 WB2 has 1 2 3 4 5 http://ccm.net/faq/7565-excel-macro-to-copy-d...
-
=IF(F9:F46="CTF",I9,"") Solved/Closed
Hello, I would appreciate any help regarding the above formula - =IF(F9:F46="CTF",I9,"") - I am trying to compute a scheme where if any cell betwe...
-
Conditional Cells Filing Solved/Closed
Hello guys :), I use Excel 12. What I need help with is a conditional filling of cells, based on values in different cells/in the certain row. I l...
-
how to use a single part of a cell's date Solved/Closed
So that's the scenario, I've a date in a Cell (D4) in the format 02/02/2008. I need to compare only the year of the date (2008) and if it's true re...
-
Find Number (1), in like 12,15,31 Ans.should be 3 Closed
Hello, Find Number (1), in like 12,15,31 Ans.should be 3 Any formula to count number Configuration: Windows / Chrome 45.0.2454.85
-
Conditional Formatting for dates Closed
Hello, Hey there, so what I am trying to do is: I have a range of fruits that we grow. All of the fruits have to be tested at certain times. A ...
-
How do i recover an outlook calendar Closed
I lost the motherboard on my computer and could not purchase a replacement board so i purchade an other computer and i installed my existing disk as a...
-
Help in Merging Codes Solved/Closed
Hi I need help in the following VBA (Macro Codes) in Excel 2013 Code 1: Private Sub Worksheet_Change(ByVal Target As Range) Dim Inva...
-
Help Please For Auto Fill Closed
Hello, Hi I have one sheet with 100 row and every row have 3 cell i want crate auto sheet with copy in first sheet set a1 from row 1 cell 1 a2 c...
-
Function has too many arguments... Solved/Closed
Why is excel telling me that this formula has too many arguments? =IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID")) I am stationed on ...
-
Search for multiple substrings and return different values Solved/Closed
I have a cell I2 which contains long string. I want to find out the following: If string in I2 contains "month", then return "Monthly", If string ...
-
Need help with data sorting Closed
I have 2 columns , one which contains values ( the invoice amount) i send.. The other column will have another list of values ( funds credited to me)....
-
Outlook 7 not sending mails Closed
Hello sir, I use outlook 7.but when i send message enter network password dilogbox box appear and message not send what should i do give suggestion....
-
Search for multiple substrings and return different values Closed
I have a cell I2 which contains long string. I want to find out the following: If string in I2 contains "month", then return "Monthly", If string in...
-
Spreadsheet Data Closed
Hello, I would like to know how to set up a formula so when I enter a certain value or text into a cell i.e "C" all of the information in that row ...
-
If condition Closed
Hi I need to do use IF condition for multiple cell check in a column E.g, of my data as below . I need the answer in Column Z like if the data ...
-
view in browser Closed
Hello,
-
comparing sheets Closed
Hello, I need help comparing data in Excel 2007. Here is the situation, I'm using an aging report and in sheet 1 column A I have the invoice numbe...
-
Filers Closed
Hello, I added filters to my excel spreadsheet and saved, however, when other people open it sometimes the filters are no longer there. What could ...
-
Deleting tables with macros Closed
Hello, I've got a long dataset. At some point in the sheet there are tales that start with a row with a text in the first cell "Please specify"...
