Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
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...
-
userform populate combobox2 based on combobox1 selection Closed
Hello, I have a userform with 2 comboboxes both work fine and they both get the items to select from the same column they each populate pulling uniq...
-
Cannot insert pages in Word 2015 for mac Closed
Hello, Please help, I cannot add pages for the MS word 2015 for mac, When i insert pages it just shows {page} instead of numbers Pleas...
-
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...
-
need to find a data in a column and copy below cell data or add Closed
column A column B column c 1......................... .........2 2.............. 23 3 2............... 25 5 want to use a excel function...
-
Error Closed
Hello, I have written macro which have sheets 6 and when file which i get have sheet 2 only,when i run maco on file having sheet two i get error a...
-
Accounting Closed
How do I create client data base for my small business
-
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...
-
Save data to different sheet by clicking a button (LibreOffice) Closed
Hi Everyone, I have a attendance record sheet that employees enter in the hours they worked each day for that pay period, which is a two week perio...
-
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...
-
Excel question Closed
I have an excel spreadsheet that I enter data on all month. At the end of the month I must extract that data and break it down into totals and put it ...
-
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
-
simple way in Excel to copy data Closed
Greetings, Can anyone help me. I am working on a huge project and looking for a simple way in Excel to copy data. If I have a master document w...
-
Copy rows from sheet 1 to sheet 2 if rule is met Solved/Closed
Hi I have a contact list I need to extract data from. Full contact list is sheet 1 Names are in A2:A12948 Internal phone numbers in B2:B12948 ...
-
VSB error autogenerate worksheet from list Closed
Hello, So I have an excel that has mutiple worksheets "2016 Census" "Tracker Template" What I did was use a code to automatically pull data f...
-
how do io open 2 different excel sheets simultaneously Closed
Hello, How do I open 2 different excel sheets simultaneously. Thanks
-
How to sort product by keyword in description then add a prefix Closed
Hello, I have thousands of products that I have to sort by category then assign a number prefix to its item ID. I was wondering if there was a way...
-
adding a value to a cell that contains text Closed
Hello, Can someone please help me? I want my cell to have the word FREE written in it BUT I also want that cell to represent 0.00$ when I add it to ...
-
Compare two spreadsheets to return a single value Closed
Hello, I'm comparing two spreadsheets and I want to see if items appears on both spreadsheets. I've tried index match but I none of my columns hav...
-
Only partial return of search for copy and paste rows Closed
Hello, I have a workbook with multiple worksheets with same format that has data in A4:K15 that I would like to search by any field and have the r...
-
copy paste cells to another sheet when criteria met Closed
Hello, I'm new to Macros and can't figure this one out. The data (numbers) read top to bottom, left to right, row by row. Some of the cells are h...
-
Activate Cells after Data Entry @A1 or Cell 1 Closed
Hello Guys, Would you mind to help me on how to disable the rest of the cells unless upon inputting data on the first blank cell. (e.g., I input cha...
-
VBA Color cell in workbook based on value in other workbook Closed
Hello everyone I needed a little help with a VBA macro. I have multiple sheets with data and I was wondering if a Macro could be written to pick up...
-
VBA Macro Help Closed
So i have multiple sheets with data and i was wondering if a Macro could be written to pick up values from one excel file and color the cell in anothe...
-
outlook repair tool for .pst files Solved/Closed
Hello everyone, I'm not really sure what happened, but this morning, one of my pst-files was missing and for another I got the error: "Errors have ...
-
Damaged .pst file, how to repair??? Closed
Hi everyone, Does anyone know the best way of repairing a 0.5GB .pst file? I had tried the normal ways through outlook and was just wondering if anyb...
-
Create Macro to insert the editor's name, date and time Closed
Hello, I would like seek some advise from expert to do the following: To create a macro box in excel. While I click on the box, the specific ce...
-
Search workbook and copy row results to worksheet Closed
Hi, brand new to the site, but saw multiple posts that seem very close to what I am looking for. I have a workbook with 31 sheets that contain info i...
-
If a cell A contains X then display cell B value Closed
Hello, 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 blank or ...
