Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Autopopulate sheets from summary page Closed
Hi, I know this question has been asked in varying forms on here and I tried to modify the macros presented to work for my particular spreadsheet b...
-
Make a shared file that can store data for the whole year Closed
how can I make a shared file that can store data for the whole year and you can select the file for a specific month, day, and year? Using Macros. or ...
-
Find out values difference between 2 excel sheet Closed
Hello, Dear Friends, I have facing a big problem in my generate billing per month because i have 2 excel sheet 1st one create manually (Manua...
-
Removing " false" value in "IF" Solved
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C11="Evening",200,IF(C11="Gaze...
-
How to set up multiple taxes inclusive formula in Excel Closed
I have a reverse calculation problem- Lets say the price of an item is $10.00 with two taxes @ 10% and 20%. Now to calculate the inclusive tax amoun...
-
excel error Closed
Hello, hi, This is dinesh from axis bank employee i get the result when type for date formet like 5-june in 20206 somebody help me. Syst...
-
Workbook to track subcontractor invoices and payments Closed
Hi i need some help with a workbook im working on and i cant figure out how or if what i want to do can be done. the workbook is to track subcontra...
-
Missing Word program imported from old MS onto Mac. after 2years Closed
Hello, I have a Mac & Word has been imported from old MS. Out of the blue W icon has gone & all searches fail. Can you help? System Configu...
-
How to convert tamil bahmini font word document into pdf file. Closed
hi, how to convert tamil bahmini font word document into pdf file.
-
creating 1 list from 2 others Closed
I have 2 lists of content (previous and current) where some entries are duplicated. I need to pull together a list of entries in the previous content ...
-
Formula Solved/Closed
I am trying to find a formula that will add up all blank fields in a range of cells. For example, if cell 1,2,3 have data and 4,5 are blank I want the...
-
Compare data between sheets and highlight identical (Mac) Closed
Hi, Macros aren't my specialty and I need to Highlight on sheet 1 all the identical products that sits on sheet 2. i.e. : Sheet 1 Product A Pro...
-
Outlook 2016 stopped working message Closed
Keep getting messages 'stopped working', tried the support and recovery assistant of 365, short version and the online that reloaded 2016 and still h...
-
Compare two Excel sheets. Closed
Dear Sir, i have worked in excel 2007 facing a big problem, actually i have 2 excel sheet which on generated billing software n other one maintain m...
-
Transferring data into a new worksheet when it meets a criteria Closed
I have a worksheet where we track whether a job is late or not. If it is late, one of the cells is "TRUE." I want all the "TRUE" rows to transfer into...
-
Lost Quickbooks 2010 licence and product key Closed
i have lost my quickbooks2010 licence and product key help me
-
Problem with formula Closed
I have a record in cell A, I want to find it in a range of records in cell b, if found then I want to look at column c for this record, if column c i...
-
Automatic copy of rows from either of two sheets to a third Closed
Greetings, I have taken over as Treasurer for a small non-profit organization and have inherited a rudimentary spreadsheet system for tracking thei...
-
Return text with text colour Closed
Hi Is there a way of doing the following for example? In cell B1 for example, I would like whatever is in A1, but with the same text colour. ...
-
Show text in one cell upon drop down list selection in another Closed
Hello, I am trying to get text to change in one column based on text selected from list in another; example in D2 I have a drop down list represent...
-
Convert date of birth in word Solved/Closed
Hello, pls tell me formula for convert date of birth in word in excel
-
How to use match function in Excel Closed
HI I have two excel files .want to know how to compare the data in those excel files
-
word documents automatically converting to a pdf document Closed
how can I stop all of my word documents from being converted to a pdf document in windows 10. if I open from e-mail, it is being converted to a pdf, i...
-
Comparing values of two Excel sheets Solved/Closed
Hello, I have two excel sheets with IP Codes. I need to find which IP Codes are not available in Sheet#1 and highlight them, i.e. Sheet#1 Column ...
-
the formula should be simple A+B=C,true or false but nope? Closed
Hello, i need formula help please! i am working with three columns of data. if: cell A1=B9904 cell B2=A2399B then cell C2 needs to =B9904 A2...
-
Automatically populating other sheets based on a certain range Closed
Hello, I'm making an Inventory workbook for a small manufacturing company I am assisting over the summer, and I've run into a problem. On the fi...
-
Copy/paste a range 'n' times. Solved/Closed
Hello, I have a highlighted portion and I want to copy and paste it 200 times. Is there a code or formula to do this automatically? Or must I hit ...
-
Same coloumns in different sheets Closed
Hello, I am trying to make an excel sheet for school to enter their different classes data base. I want to to create a templet table or colou...
-
Macro to create, and connect to, individual sheets. Closed
Hello, I'm trying to create a macro that I can run that will create a new sheet based on a row. The new sheet will have all of the column headings A-Q...
-
Conditional Format Solved/Closed
Hello, I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell $AI2 has
-
Comparing 2 Excel spreadsheets Closed
I have a giant master list of addresses. I have a second much smaller list of addresses in a specific radius. I want to compare the data in giant li...
-
Issues in writing multiple if conditions inside vlookup Closed
Hello, I have two sheets. 1st sheet has an unique information in the first two columns about bike and its repair date (DD/MM/YYYY) format. 2...
-
Pivot table Code Troubleshooting Closed
Hello, I am trying to create an auto pivot table using some data that I have. However after repeated attempts at troubleshooting, I am unable ...
-
expenditure reports for every quarter automation Closed
I have an excel workbook that contains expenditure reports for every quarter, I want to automate this data and create a report in a required format. A...
-
Vlook up Solved/Closed
Hello, I have 2 columns A & B in sheet1 and i want to Return Yes if either A or B value mactches with Coulmn A in Sheet 2. Please help
-
Populating Sheets based on value in other sheet Closed
Hello, I am trying to set up a worksheet so that when specific values are in a column, the entire row would copy onto another sheet with the same ...
-
Outlook mail is not working properly Closed
Hello, My outlook mail is not sending mail to some people but some people received my mail can you tell me what is the problem behind it. S...
-
how to auto fil 2 differand cells have same value Closed
2 different cell have same value , I need to be Auto filled same value in between the all cells
-
Automatically transfer data between worksheets Closed
Hii I'm currently trying to make my work life a little easier and have created an excel spreadsheet of all the incoming paperwork we have for stude...
-
numbers into words Closed
Hello, this function is used for once, i.e., if we close the excel and we open it , it again asking to copy the formula ...how to save it permanent ...
-
Macro to paste a unique count number of times Closed
Hi everyone, I am trying to create Macro to paste a unique count number of times in excel for E.g John 2 Steve 5 Matthew 3...
-
Unable to Change the date format Closed
Hello, I need to change the date format from Apr 2, 2017 01:39 PM to dd/mm/yyyy hh:mm but still not successful. Kindy assist. System Con...
-
Repeat value certain number of times Closed
Hi Guys! I'm having a hard time creating a formula to extract data based from this. This is what's showing in one of the sheets: 8:30 PM 4.00...
-
Macro to automatically insert rows Closed
Hello, I am building a training worksheet, with 1 main data tab that has all the company names that we work with in column A and their associated ...
-
excel conditional formatting Closed
How do change the color of one cell if another cell contains a text. For example: If B3 contains any text then I want A3 to change color.
-
Excel formula to handle duplicate records Closed
Hello, Thank you so much for taking the time to assist in resolving this for me. Column A, Column B 30001234, 587 30001234, 586 3000123...
-
I need to upgrade older version Closed
I want to know how to download Office 2010 free version
-
data needs to be added to another sheet Closed
hello i need my data needs to be added to another sheet at field of column 1st but column is not empty then add to another column. pls help
-
Spreadsheets viewing formulas Solved/Closed
How do I view hidden formulas on spreadsheet
-
VBA send email via Outlook using loop; No response when run Solved/Closed
Hello, the above code is not functional as described. Is there a way to check what is wrong? the screen does not show anything upon clicking the r...