Office Software Forum
- Excel (9,853)
- Open Office (117)
- Outlook (652)
- PDF (334)
- PowerPoint (185)
- Word (2,189)
-
Rating from Parameter Lookup Solved/Closed
Hi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is the e...
-
Free Publisher Closed
During installation the message for product key appears and the text is in French, even though it says English on the webpage which has the downloade ...
-
Nesting if() functions? Solved/Closed
Hey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are either la...
-
Excel macro create new sheet copy & paste cells Closed
Dear Sir I need help in a macro to create a new sheets with colum A name and copy row cells to the new sheet. Name Age Gender XX 25 M ...
-
i'm not able to send emails Closed
Hello, i use bsnl broadband at home. should i reconfigure my account settings to send emails if my broadband provider initially was different from...
-
Word & Excel error Closed
Hello, In my system some of word & Excel file automatically renamed as some other format (Eg: SUPPORT.XLSX.gsjwsuk). If am open through again ...
-
automiatic email Closed
Hi all, I have used excel for years but never at an expert level. I am currently in a position where I need to view multiple tabs of data daily to...
-
outlook e mails Closed
Hello, Cannot send messages but receive. Get message when sending. 0x80042109 Thank you Adriaan Configuration: Windows / Mozilla 11.0
-
I'd like to change a PDF file to word, excel and PowerPoint Closed
To whom it may concern I'd like to change a PDF document to excel, word and power point. Please help me soon as this is as a matter of urgency. ...
-
Number of Days between 2 dates Closed
Hello, i am trying to calculate the number of days between 2 dates i,e 09/08/1965-05/02/2007= 41 years and 181 days which is 15146 days Whe...
-
transfer data Closed
I am working on a spreadsheet and I need to transfer the ending balance on one page to beginning balance on another page, for the entire tenant list. ...
-
Copy data from one workbook to another workbook using vba Closed
Hello, Good Afternoon, I need some help to be able to complete the below task. I need to be able to copy data for 2 different tabs in an wo...
-
Outlook e mail problems Closed
I have a problem with my outlook e mail. Cannot send mails but receive mails. I receive the following message: 0x80042109
-
HELP HELP HELP Excel Formula Closed
Hello, I really need help trying to figure out this formula, as I have tried so many different formulas and can't seem to find one that works. I nee...
-
Due Date Reminder With An Email to the filtered list Closed
Hello, Here I have a filtered list from Master Sheet to DueReminder Sheet In which column I represents Email address Now my motive is to se...
-
Why dbx files do not opened Solved/Closed
As soon as I have not tried to open the file through Outlook. Out - walked into account. Downloaded the new version - nothing helped. Outlook does not...
-
Change date format using Excel Macro Closed
Hello, In SAP BI I have created a BEx Query. We can see BEx reports in MS Excel. Date format in the report is DD/MM/YYYY and I want it to be displa...
-
Comparing Excel sheets with only a few overlapping records Closed
Hello, I have two worksheets (1 & 2) that have different info, with not many duplicate records. I need to identify the duplicate records. I can ...
-
Mtch formula required Closed
Hello, In one column - A i have name for eg -Anuj Muchhala and another column B - Anuj & column C - Muchala - I want to know how to match maximum ...
-
How to make a cell flash using Excel 2011 for Mac Closed
Hello, I have Excel 2011 for Mac. Is it possible to make a cell flash using the Mac version of Excel 2011? If so, how is it done? I would apprec...
-
Find, copy, create a row under, paste, loop. Closed
Hello, I would like to ask for a macro (as I was unfortunate to experiment with a lot of them and none of them worked as I'd like). What it sho...
-
Excel - Merge several worksheets into a single one Closed
I use Excel to store information about several users and their cars information and have a different worksheet for each month. How to merge all these...
-
Major problems images into Word Closed
Hi all, At the moment I am having major issues with inserted images into word. Background: it concerns my PhD thesis of about 140 pages. In this do...
-
Cannot open PDF while Word docume Closed
Hi all, I have a problem with opening PDF files. If Word is closed, no problem. When Word is open and I click on a PDF file, it opens the document ...
-
I am looking for Outlook Express fix tool Solved/Closed
Hello everyone...How can i restore damaged .DBX file of OE? I am not able to see the mails. My 4 Gb data in inbox.dbx is corrupted of .dbx files by u...
-
Replace cell content in Excel 2007 Closed
Hello, I've two columns like below and i'd like to replace the one in 1st column with the one in column B in another table. Name_A Name_B Joe ...
-
macros or vba for data validation Closed
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybo...
-
1 time data entry Solved/Closed
Hello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i enter...
-
Add an X to cell if other conditions met Closed
Hello, I've got a list of products for an e-commerce site. What I'm trying to do in Excel is flag any items that have a quantity of zero AND are i...
-
convert numbers to words in excel Closed
please clarify my problem "convert numbers to words in excel"
-
mm/dd/yy AND dd/mm/yy AND mm-dd-yy AND dd-mm-yy in one column Closed
Hello, I have the problem of having all the 4 date formats in the very same column: mm/dd/yyyy dd/mm/yyyy mm-dd-yyyy dd-mm-yyyy I would nee...
-
transferring data Closed
Hello, Dear to whom it may concern, I want the data in sheet 1 to automatically export the data in sheet 3 and when the row is empty in sheet 1 th...
-
Replacing duplicates Closed
Hello Trowa Sorry to bother you again but a problem has arisen. Everything was working OK until I tested "Pair names 4" Column Q. When I ran the code...
-
Notification popup every time a cell to change certain color. Closed
Hello, my English is not good, so I'm using google translator, sorry about that. I am creating a spreadsheet where is the organizational chart of...
-
DUE DATE REMINDER IN EXCEL TO NEW SHEET? Solved/Closed
Hello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE COLUM...
-
Compare two sheets and copy cell if match found. Closed
Hi guys. I have two sheets and would like to compare sheet2 with data in sheet1 and copy a cell data from sheet1 to sheet2. Eg: SHEET1 A ...
-
Copying a row to another sheet with a trigger Closed
Hi All, I was preparing an excel workbook, based on the sales pipeline. To simpify, The first sheet has company name and contact column. Titled "...
-
To create new sheet every time new information is added Closed
I am currently creating a wage calculation template in excel. There are 3 sheets currently in my file. First is "employee information". Second is "emp...
-
Excel transfer of comments Closed
from excel file to excel file, how can I get comments updated automatically, similar to vlookup or hlookup? i.e. comment in cell c4 of file abc.xls...
-
different colour for each formula result obtain in one cell Closed
Hello, In Excel , I want different format for formula result in one cell. A1=0 & A2 = THANKYOU =if(A1=0,"OK","NOT OK")&RIGHT(A2,5) ----...
-
Format based on another cell with a letter. Closed
Hello, I would like to know if there is a way to apply a format formula to a cell but to use a letter as criteria instead of a number? Example:...
-
Copy the whole column on to the another column master sheet Closed
Please help. I want to make an excel sheet in which i can copy one whole column onto the another column in all my sheets of master sheet. For exampl...
-
Regarding Pivot Solved/Closed
Hi I am doing Pivot for multplie data . In the Value field ( bottom right ) , I need SUM as default instead of count . I have to drag multiple ...
-
Colouring the rows if some conditions are meeting Closed
I am trying to create a macro of some sort to do some checks to make sure everything is populated correctly. Here is an example of the spreadsheet... ...
-
Paste at end of data Closed
Hello, I'm trying to write something that will copy and paste cells AC10:AQ15 from a sheet called "Format" to the end of column AC on the sheet ca...
-
Need macro code Closed
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybod...
-
Counting Words, Names as Number Values Closed
Hi, Ive been searching for a way to count a list of names as a number. I currently have to place a 1 in a column next to the list of names. And have ...
-
Find the first available (empty) cell on a worksheet. Solved/Closed
As a newbee to VBA, my boss has given me an impossible task ... Basically I need to be able to enter one cell worth of data from one sheet of a wor...
-
function for finding unique data in one spreadsheet to a second Closed
Hello, I have a spreadsheet of 500 rows. Each row contains on unique "item Number". I am looking for function that will locate the unique number i...
-
Trying to see if I can even create a Macro! Please help! Closed
I want to know if its even possible to create a Macro whenever I copy/paste information that is provided to me weekly, which in this case is in th...