Office Software Forum - solved topics
- Excel (9,843)
- Open Office (114)
- Outlook (647)
- PDF (334)
- PowerPoint (183)
- Word (2,189)
- Solved
-
Best MBOX conversion software Solved/Closed
Last few days I have suffered to the conversion of MBOX files. Can anyone suggest the best way of MBOX conversion? Which is easier and Saves my all MB...
-
Conditioning one Calc cell on another Solved/Closed
Hello, does anyone know a way to make it so that a cell in Open Office Calc cannot be left empty, or at least that there will be an error message if ...
-
VBA Function code to highlight Odd and Even numbers Solved/Closed
Hello, I am trying to write a VBA Function code to highlight Odd and Even numbers. But not having much luck. Can anyone help me, please? I would ...
-
Help: Need formula to find missing text comparing 2 cells Solved/Closed
Hello guys I have the same issue. A2: The price includes VAT B2: The price In the next column, I want the following value (the text difference...
-
VBA: Color cells in table based on multiple condition Solved/Closed
hello i do code by loop but it doesn't completely work i appreciate if somebody help me why it occurred and give me the alternative ok let'...
-
How to specify macro for current active sheet Solved/Closed
Hello, this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is selecte...
-
How do I scan and then search a document Solved/Closed
I would like to scan the table of contents from a large number of magazines. What format should I use to save this document? What software will allo...
-
Excel make cell flash red Solved/Closed
Hello, In Excel I can make cell red when formula is greater than 4 but how do I GET CELL TO FLASH Office 2003 And can you in same spreadsheet li...
-
inserted row should paste in 7times in next sheet based on the date Solved/Closed
Hello, i have a template and from client a workbook will i should compare and paste the data if any new row der i should insert in template file an...
-
VBA to reference newest sheet Solved/Closed
Hello, Im a complete beginner in excel and the vba process. I'm trying to make a macro create a new sheet, copy the style/structure from a pre-det...
-
Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes Solved/Closed
Hello All, I have been struggling to find a code that allows me to select multiple columns by name to then delete duplicates in those specific colu...
-
Macro to compare 2 sheets and copy differences Solved/Closed
Hello, I’ve been working with this macro to compare two worksheets and copy the matches to a third sheet. Not knowing vb very well can someone show...
-
Combine Cell Text Solved/Closed
Hi, I am after an easy way to combine text in several rows into one cell. The number of rows that need combining will vary from 2- 10 (Would be...
-
Copying data from one Excel sheet to another. Solved/Closed
Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy the da...
-
Copy rows from Excel to another sheet once a date in a specific field is filled Solved/Closed
I have a current spreadsheet that lists our customers, job names, and delivery dates for the materials. I would like to have those lines copy automati...
-
Cells copying and pasting in a empty cell of another sheet Solved/Closed
Hello, One Excel file has 2 Sheets. First sheet called "source" and second one called "Bestand" In sheet "source" one cell (a1 for example) must...
-
Punching Time Solved/Closed
Hi again! I have this task ofcalculating the punching time of our agents. I have 4 sheets in one excel. "Deliveroo Data" This is where the orders ...
-
Yahoomail ADS Solved/Closed
If I follow these instructions, will I still see the yahoo ads and "news"? I was planning to open an Outlook account and just forward Yahoomail to it...
-
Date Am and PM but need the date to change Solved/Closed
Hello, I have 12 workbooks, what I am trying to figure out is I have the date and time in one cell. But I has it 1/1/2020 00:00 then them next lin...
-
Copy x rows y times and then insert customer ID on each set of x rows Solved/Closed
Hello, I have a set of criteria, 56 criteria as of now, and I have to check how many criteria each customer meets. In one tab I have the list of the ...
-
Transferring data autonomously to another sheet with certain text Solved/Closed
Hello, I want to copy the words "Pending" and "Candidates" from my main sheet called 'Test Project' to my new sheet called 'Pending Test'. Bot...
-
Populate data from a column in one worksheet to a cell in multiple other sheets Solved/Closed
In a workbook, I want to be able to copy all the cells in column B of sheet "Raw Data" into multiple copies of an existing template sheet correspondin...
-
Using IF to compare time values Solved/Closed
Hello, So basically I have a huge column of time values (00-00-00 format) and I am trying to write a code that takes the time in one cell (B) an...
-
Find out date filling cells Solved/Closed
Hi, First of all thanks for your help I have a big excel file which I have been filling it for the last 2 years. There is a way to find out the da...
-
Microsoft Word icon changed to unknown program Solved/Closed
Hello, Recently my microsoft word (program) icon changed from the classic picture to the unknown programs icon. I wanted to know how to get the re...
-
Convert Tamil PDF document to Word Solved/Closed
Hello, how to convert a tamil font pdf file to word file with tamil font Still problem exists when i convert a word file the letter are not ...
-
How to hide text in a Excel cell and display it when needed Solved/Closed
Hi friends I have doubt in excel. I have a column called 'Status' and want to show the text either as 'Pending' or 'Completed' depending on the ...
-
Seperating time from text Solved/Closed
Hello, I have a task in my office that i can't get done and it is very impossible to finish within 1 week as these are 14,000+ orders. The sheet ...
-
VBA: Delete empty rows based on value of cells Solved/Closed
Hello, my code works transfer my invoice from sheet1 to sheet 2 but my problem i would adjusted my code to become delete rows from a19: e32 i...
-
How to simply this Excel formula Solved/Closed
Is there a way to make this formula simpler? =IF($K9=0,"",SUM($L9*$L11)/R9+IF($K9=0,"",SUM($M9*$M11)/$R9+IF($K9=0,"",SUM($N9*$N11)/$R9+IF($K9=0,"",...
-
How to check if a cell contains "%" and calculate accordingly. Solved/Closed
I am wondering how to do that? I learnt no basics, just went on by myself trying to figure out things and so here is what I am trying to do.. Ba...
-
VBA Copy/Paste fixed range a number of times Solved/Closed
Hello Team, I'm looking for a VBA code to copy the three rows and with input box paste based on the times, I entered in the input box. FOr ex...
-
Excel - IF function with multiple words Solved
Hi I'm trying to write a formula to produce a yes/no answer depending on whether the data in a previous cell in the same row contains any of the wo...
-
Find a date in a range of dates Solved/Closed
Hi All. Another silly Macro question that I cant seem to find an answer for ... As my wife does silly shift at work I have developed an excel sp...
-
Unable to change date format in Excel Solved/Closed
Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I doubl...
-
IF statement Solved/Closed
Hello, I am really struggling to get the correct formula for below situation: example: Cell A2 is a "due date" Cell B2 is a "completion date" ...
-
How to find the latest time per name in a table with names and times Solved/Closed
Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have sev...
-
INTEREST ON TERM LOAN AND WORKING CAPITAL Solved/Closed
Dear CCM, I dont know "interest on term loan and working capital, profit before taxes and profit after taxes""..etc anybody can help me to solve...
-
Summarise hours incurred by month based on multiple criteria Solved/Closed
Hi, I want to summarise hours incurred mthly (from the time_converted column) based on the grade and agency but can't seem to get the below formula...
-
Open Office page numbering - start numbering on page 3 Solved/Closed
I would like to know how to start the page numbering on page 3 instead of 1.
-
Message to appear when 5 cells uncolored cells contain values. Solved/Closed
Hello, A macro using excel that can return a message when 5 uncolored cells that are in a range of colored and uncolored cells contain values. The ...
-
Code to move rows into another sheet based on certain values Solved/Closed
Hello, I'm having trouble figuring out how to do something! I have a sheet (Design) with work order details on it (columns A-J will have data in). ...
-
Inserting an image without the white background Solved
Hello, I have an image that I have vectorized... or so I think I have.... and I when I try to insert it into a document this white square appears ...
-
Auto-populate a sheet with data from different other sheets Solved/Closed
Hello, I have been having problems with having a general data sheet in my workbook. My problem is as follows: I have 3 different sheets, all of w...
-
Copy rows to other sheets based on value in column Solved/Closed
Hello, I have copy and pasted the code used to solve the problem for the question which began this thread. I have 6 tabs into which I want to...
-
Replace 'sheet' reference in a formula (not copy data, but get averages) Solved/Closed
Hello, I'm working with a precipitation data base of multiple sheets. Each sheet is a year of measurements. The thing is that I'm trying to ge...
-
MS Word not displaying page numbers, images Solved/Closed
Hello, So far MS word worked fine. But now it is not showing up images. Also not even page numbers. Instead showing up {Page}. Please let me know...
-
Am not too good on percentage calculation Solved/Closed
Hello please what is the 10 percent of,7200000000
-
Why do my PDF documents open in Word? Solved/Closed
Hello, I can't figure out why my PDFs always get open in Word but not the Adobe program? Does anyone have a quick answer? Thank you so much! ...
-
Macro to copy/paste down X times (where X is the number of rows) Solved/Closed
Hello, I could sure use some help on a Macro. I need to copy the value in E1 and paste down to all cells in column E (E2 to E??) The issue ...