Forum
Office Software
- Excel (9,564)
- Open Office (109)
- Outlook (615)
- PDF (320)
- PowerPoint (164)
- Word (2,154)
- Solved
-
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...
-
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...
-
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...
-
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]
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...
-
Summarise hours incurred by month based on multiple criteria [Solved]
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...
-
Open Office page numbering - start numbering on page 3 [Solved]
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]
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....
-
Code to move rows into another sheet based on certain values [Solved]
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...
-
Inserting an image without the white background [Solved/Closed]
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...
-
Auto-populate a sheet with data from different other sheets [Solved]
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...
-
Copy rows to other sheets based on value in column [Solved]
Hello, System Configuration: Windows / Chrome 75.0.3770.142 I have copy and pasted the code used to solve the problem for the question which...
-
Replace 'sheet' reference in a formula (not copy data, but get averages) [Solved]
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...
-
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...
-
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...
-
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...
-
Inserting day of week along with date [Solved/Closed]
Hello, I am currently working on a spreadsheet and trying to set the cell format so that it displays the day of te week alongside the date eg...
-
Not able to send mail from the Gmail outlook [Solved/Closed]
Hello, I had configured Gmail in Outlook 2007. I am able to recieve all the mails. But the problem is not able to send mail from outlook. I had...
-
Send mail if today is the birthday. [Solved/Closed]
Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 ...
-
Comparing Two Excel Sheets and copying like data to third sheet [Solved/Closed]
Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1...
-
Using a Named Field for Autofill [Solved]
I am performing an Autofill using a macro. Is there a way to enter the ranges using a "Named Field" in the macro without having to hardcode them...
-
Excel Macro - Set and autofill a range? [Solved/Closed]
Hello, I am creating an excel macro to reformat a CSV file. In doing this, I need to select a column (F) and replace the values in that column...
-
Excel autofilter stops filtering [Solved/Closed]
Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file, which has about 19,000 rows,...
-
Word 2007 blank page displaying square boxes [Solved/Closed]
Hello, Please can anyone help me. I was typing in english and then I wanted to change to chinese. I pressed shift and alt and immediately struck...
-
If a cell contains any text then add a value [Solved/Closed]
I hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need...
-
Formula in Excel to turn numbers into text [Solved/Closed]
Hello, I found formula but sir I want at last as per below. As per formula =words(1234) = one thousand two hundred thirty four But sir I...
-
Mail.com POP (IMAP) settings outlook [Solved/Closed]
I got my mail.com email working using the following settings: Account type: Choose IMAP Incoming mail server: pop.mail.com Outgoing mail...
-
Automatically update a cell with last modified date and time [Solved]
I am maintaining a Test Environment Catalogue, with various users editing it. It is change controlled in SharePoint, however, I'd like to insert a...
DON'T MISS
- Sign Up for a Free Netflix Trial
- Reverse Image Search with Google
- Writing Professional Emails in English
- Get the Transcript of a YouTube Video
- No Sound from Headphone Jack
- How to Download Instagram Videos
- GTA Vice City Cheat Codes
- How to Block Private Numbers
- Credit Score
- Facebook Confirmation Code Text Not Received
-
Grammarly Keyboard
-
Amazon Fire TV
-
OnLog
-
Tricount
-
Citymapper
-
YAZIO
-
Candy Crush for PC
-
CallApp
-
Garena Free Fire: Spooky Night
-
30 Day Fitness Challenge-Workout at Home
-
Pokémon Masters