Office Software Forum
- Excel (9,871)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Publisher Closed
I downloaded Microsoft Publisher for free yesterday and do not like it. I want my old Microsoft 2007 word program back but Publisher has changed all m...
-
display a range of cells if a condition (text) is met Closed
well, i am regular for excel. now i need a help, if a cell value, is a particular text, then i want to display a range of cells at a particular loc...
-
colour changing in rows determined by text in 2 different cells Solved/Closed
Hello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the...
-
converting numbers to text Closed
hi I need to convert numbers / date of birth in excel pl suggest / advice thanks
-
date formate Closed
Hello, please help me, i have software date format {15/03/2016 5:26 PM} and i need convert to this format {Mar/14/2016} Configuration...
-
Town/City to lookup county Closed
Hello, I have a spreadsheet that what i am trying to accomplish is that when an address is typed into a column it will look up and match the town a...
-
transfer data between sheets in excel Solved/Closed
Hello, This involves an attendance sheet. A tab for each month with columns for weekly attedance and a total for the month and a summary tab contai...
-
Related to Outlook Closed
Hi, I am not able to send and receive mails on my outlook 2007.Whenever I am sending mails to anyone i received the mail from system administrator ...
-
Compare values of two separate sheets and returning value Solved/Closed
Hello, Configuration: Windows 7 / Chrome 43.0.2357.81 I'm currently working a spreadsheet trying to match values from Sheet 1 Column B with...
-
Using an IF statement to compare dates Closed
Hello, I'm trying to compare two dates by referencing two cells. I tried something like this IF(B2>C2, "past due", "on time"). I know to ...
-
How to have my results in different sheets in one workbook? Closed
Good day I trust you are well? I was hoping you can assist me with the following and will be most grateful for any help I can get: I have to cr...
-
How to invoke VLookUp function in Excel VBA. Closed
Hello, Please, I need a visual basic code that can actually invoke or call a V Lookup function in Excel to query data in two separate worksheets an...
-
Recording Macro To Duplicate Page And Rename To Numeric Value Solved/Closed
Good day I am trying to record a macro that duplicates a page and renaming it to another file name but need to follow in numeric order. I have a...
-
Need to find a data in a column and copy below cell data or add Solved/Closed
Hello , Please help me to solve this, it will be very grateful column A column B column c 1......................... .........2 2.................
-
Compare 2 worksheets and update one of them Closed
I am a beginner Excel user and I hope I can get some help here. I am about to purchase a retail business. I have a copy of the master inventory list. ...
-
Help needed on saving then clearing content except selected rows Closed
Hi I am writing a spreadsheet for my ward for TCI list which has admissions, discharges and transfers. I want to be able to save then clear the c...
-
Autopopulating data from one main sheet to multiple sheets Closed
Hello, I'm making a workbook for my coworkers to easily know what specific person they need to work with from month to month. I have created a "Mast...
-
Transfer data from multiple sheets to one sheet. Closed
Hi all, I'm kind of new to spreadsheets. I have 3 sheets each with the same columns. Column 1 has a type and column 2 has serial numbers, column 3 has...
-
Sending problems Closed
Hello, I am having a problem sending emails from my Outlook. I get it returned in my inbox with the error 554 5.7.1 and it says authentication failed ...
-
count days in excel Solved/Closed
Hello, How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days. with =NETWORKDAYS(A1,A2) not count the weekends. Thanks F...
-
Excel- How do I auto transfer rows of data to another worksheet Closed
Hello all, I am after some help with excel. I am a PE teacher and need to find a way to cut down the processing time for our athletics carnival sco...
-
combine of column Solved/Closed
Hello, How can we show value of more than two column in a single column but in two rows. please reply at the urgent.
-
Compare values in two columns and return the value from third Closed
Hello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need t...
-
Comparing two excel worksheets Solved/Closed
please, I need a macro code that can actually compare two worksheets and flag up the differences using same color to show the dissimilar rows. Be...
-
Populate 2 tables at once but one table only if text match Closed
Hello, I have 2 tables in separate sheets, I am using a userform to populate table1 and I need a formula to populate table2 as new data it's entere...
-
Date function Closed
Hello, I'm using a function =date(year(j2)+(m2),month(j2),day(j2)) BUT.. I want to be able to type in words like NIL, NO, and DEFER in to cell M2...
-
Carry forward formula Closed
Hello, I'm trying to find if there is any formula to carry forward a figure to another spreadsheet on a daily basis. the cells were not at the sam...
-
Drop Down List and Auto copy data based on date in cell to anoth Closed
Hello, I need help fast. I'm not the resident expert my boss think I am apparently. Excel 2010. I imported info from a Word Perfect document whi...
-
copy paste macro needs tweak Solved/Closed
Hello, I'm new to VBA, and would appreciate any help with this Macro. It copys the mouse input, but overwrites the last paste. I need it to (after I...
-
VBA Tricky Question Closed
Hi All, I am working on excel and I need some help with VBA/macros. Basically, I have a variable called Y and I have a table of set values, call...
-
IF column A contains ANY text OR IF column B contains ANY text.. Closed
Hello, I'd like to achieve in Open Office Calc IF column A contains ANY text then ADD "XYZ" into cell G12 OR IF column B contains ANY text t...
-
SnapShot for PDF editing Closed
Need free or Microsoft Office PDF editor
-
Compare two csv files Closed
Hello, I have two csv files which has member details. I just have to compare both the files and confirm if its similar. Any way to do it through e...
-
printing numerous copies Closed
Hello, I have a seguential numbering macro that numbers a 2 part EWO - I want to be able to run more than 1 set at a time - how do I do that? C...
-
Sending Data from one spreadsheet to multiple speadsheets Closed
Hello, I am fairly new to VBA and have been searching for a solution for my problem but as yet have not managed to find one. I wish to send da...
-
conditonal format a because of values in another cell Solved/Closed
Hello, i am trying to figure out how i can format a cell to show green when above a figure and red when below the figure simple i know but here co...
-
cursor in excel does not work Closed
I use Window 7 and Office 2010 with license. I bought in Bangkok, Thailand. This morning my cursor in excel has been changed from arrow to be thick...
-
Arrow cursor has been changed to Cross and cannot move any cell Closed
Hello, Please help me, I cannot use cursor in excel to move cell or drag. Thanks & Regards, Configuration: Windows 7 / Mozilla 11.0
-
Function Formula Date and Text Solved/Closed
Good day I am looking for help with a function formula PLEASE. Example Decleration Start Date 2016.02.17 Last inv_ Inventory_ Decl frm 1...
-
SPELLNUMBER VBA IN EXCEL Solved/Closed
Hello, I alreadly use spellnunber but the problem is it does not convert incorrect for my currency. Present Situation =SpellNumber(1,100,000) =...
-
Conditional Formatting for 2 columns Closed
Hi I am currently using conditional formatting on cells with dates, I have used cell value rules to highlight a pending date within 14 days and one...
-
If a cell A contains X then display cell B value - Please advise Closed
Hello Everyone, How to get the cell B value when Call A1 is X the display what ever is there in Cell B1 as in Cell C. If not the leave the column b...
-
How to change Oct 26,2015 to 26-10-15 Closed
Hello, Can any one help me to change Oct 26,2015 to 26-10-15 in a excel cell. Configuration: Windows 7 / Firefox 44.0
-
Conditional formatting on an entire row Solved/Closed
Hello, I want an entire row to turn red, only when one cell in that row is less than 0. I tried highlighting the whole row with the formula =A12
-
My email have been deleting without reading Solved/Closed
Hello, I keep getting emails saying that some emails have been deleted without being read. The message below is typical of what I am seeing is: ...
-
Issue with Date and Text in if formula Closed
Hello, I'm trying to write a function for a cell which refers to different descriptions in one column - where it only should combine some descript...
-
Receiving an error message for VBA Closed
Hello, I was given a workbook to fix with 5 different sheets. The Summary sheet has a button to "Refresh Equipment List" which is supposed to ...
-
error message - pdf wasn't decoded Closed
Hello, when i try to send pdf as attachment in email - when the receipt opens the mail he gets an error that pdf was not decoded. i am sending th...
-
Where is the downloaded software? Closed
Just downloaded Publisher, but can't find it.
-
How to sum row color Closed
Hello, Please help us with how to sum numbers marked in different colors. Configuration: Windows 7 / Chrome 48.0.2564.116