Office Software Forum
- Excel (9,588)
- Open Office (109)
- Outlook (618)
- PDF (323)
- PowerPoint (168)
- Word (2,162)
- Solved
-
problem search data by selected combobox & datepicker tools [Solved]
hello i no know why this doesn't work this code and there is no error it should when i select from combo box it should ...
-
how can I unmerge cells, delete empty col and rows, relocate cells and combine? [Solved]
Hi dears, first of all, I have to thank every one who read this message and he try to help me. its a complicated matter to me. Actually,...
-
Is it pointless? [Solved]
When I am writing an important document, I always upload a copy to Google Drive every half an hour because I am afraid of loosing it, although...
-
How to Unlock A Password Protected Word Document [Solved/Closed]
How to Unlock A Password Protected Word Document
-
Count cells containing text per row [Solved]
Hello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each...
-
how to hide/undie picture based on a cell A1=1/0? [Solved]
Hello, can anyone help me how to hide/unhide picture 1? if A1=0 then hide picture 1 if A10 then show picture1 thanks System...
-
transpose data from vertical to horizontal [Solved]
Hello, this the code doesn't work i would transpose as what in existed in picture the result from e: h i hope ...
-
copying formula for multiple worksheets [Solved]
I use ASAP utilities to insert multiple worksheets using a template. I'd like to create a formula that automatically inserts sequencial numbers. ...
-
adjusting code divide data of table into tables in each sheet [Solved]
hi, my code really works but the problem when i add a new data it doesn't copy to the multiple sheets because the first ...
-
how can i blink data in textbox on userform based on condition [Solved]
hello i got this code from the internet about blinking in textbox by command button but i would do this without command button it's...
-
Excel - How to count numbers in Brackets [Solved]
Hello, I would like to know how to count the number of elements(digits) in the brackets after a word. exemple Bimbia(1,2,3,6,7,8). in the...
-
fixing sum an subtract among sheets [Solved]
hi, i search so much in the internet to fix my code to work but no answering so far i have 6 sheets it suppose copying data...
-
Best MBOX conversion software [Solved]
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...
-
Conditioning one Calc cell on another [Solved]
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...
-
VBA Function code to highlight Odd and Even numbers [Solved]
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...
-
Help: Need formula to find missing text comparing 2 cells [Solved]
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...
-
VBA: Color cells in table based on multiple condition [Solved]
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...
-
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...
-
How do I scan and then search a document [Solved]
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...
-
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...
-
inserted row should paste in 7times in next sheet based on the date [Solved]
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...
-
VBA to reference newest sheet [Solved]
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...
-
Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes [Solved]
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...
-
Macro to compare 2 sheets and copy differences [Solved]
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...
-
Combine Cell Text [Solved]
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-...
-
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...
-
Copy rows from Excel to another sheet once a date in a specific field is filled [Solved]
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...
-
Cells copying and pasting in a empty cell of another sheet [Solved]
Hello, One Excel file has 2 Sheets. First sheet called "source" and second one called "Bestand" In sheet "source" one cell (a1 for example)...
-
Punching Time [Solved]
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...
-
Yahoomail ADS [Solved]
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...
-
Date Am and PM but need the date to change [Solved]
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...
-
Copy x rows y times and then insert customer ID on each set of x rows [Solved]
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...
-
Transferring data autonomously to another sheet with certain text [Solved]
Hello, I want to copy the words "Pending" and "Candidates" from my main sheet called 'Test Project' to my new sheet called 'Pending Test'....
-
Populate data from a column in one worksheet to a cell in multiple other sheets [Solved]
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...
-
Using IF to compare time values [Solved]
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...
-
Find out date filling cells [Solved]
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...
-
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...
-
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...
-
How to hide text in a Excel cell and display it when needed [Solved]
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 ...
-
Seperating time from text [Solved]
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...
-
VBA: Delete empty rows based on value of cells [Solved]
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:...
-
How to simply this Excel formula [Solved]
Is there a way to make this formula...
-
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...
-
VBA Copy/Paste fixed range a number of times [Solved]
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...
-
Excel - IF function with multiple words [Solved/Closed]
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...
-
Find a date in a range of dates [Solved]
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...
-
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...
-
IF statement [Solved]
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...
-
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...
-
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...
-
Muslim Pro
-
Animal Crossing: Pocket Camp
-
Tacticool - 5v5 shooter
-
Resident Evil 3: Raccoon City Demo
-
Minecraft: Education Edition
-
Ukulele Tabs & Chords
-
Amigurumi
-
HEALTHLYNKED COVID-19 Tracker
-
COVID Symptom Tracker
-
Zoom
-
Houseparty