Office Software Forum
- Excel (9,746)
- Open Office (113)
- Outlook (639)
- PDF (334)
- PowerPoint (174)
- Word (2,185)
-
I forgot my gmail password Closed
Please I need help I forgot my Gmail password
-
How format a cell that changes to "Complete" or "Incomplete" Closed
Hello, How can I format a cell that changes to "Complete" or "Incomplete" when another cell linked to it has a specific text written on it i.e. Y...
-
Excel macro Closed
Hello, I'm also very new to macro, so I don't know what I'm supposed to be adjusting! My main sheet is titled "Project Timeline" and my other s...
-
Copy hyperlink in another sheet when using vlookup Closed
Hello guya please help. I have little knowledge in vba. i have an employee details in sheet 1 and i have a vlookup fromula in sheet 2 to show th...
-
Randbetween function error Closed
Hello, Iam using randbetween function. Since is it automatically changing the value, I want to copy and paste value if one condition is satisfied....
-
Macro that copies format in Sheet 1 to multiple sheets Closed
Hello guys, I need help with the creation of a Macro that is doing my head... Let me try to resume so it is super clear for everyone : SHEET ...
-
Search for input criteria, return designated cells. Solved/Closed
Hey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches the ...
-
Inserting and formating date with userform Closed
Hello, I am trying to Insert a date with a Textbox in a Userform. It should have this format: Friday, 18.08.2017. This entered Date is used...
-
Adobe Acrobat Reader 0:104 error message Closed
Hello, I re-installed Acrobat DC on a user's machine yesterday after encountering error messages. It worked. Adobe then updated and the error me...
-
MS Outlook can't access my mail Closed
I like to use MS Outlook 2007. For me it is the best. But some hours ago something bad happened with .pst file. All my email aren't accessed. I have t...
-
Free MS Office Download Closed
I just bought an HP Pav laptop and I have noticed that no MS Office is installed. Do you know where I can download the full version for free, I badly ...
-
Copying dates to another worksheet. Solved/Closed
Hello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...
-
How to convert numeric into words in Excel Closed
What is the formula to convert numeric in words?
-
Excel formula - Add days to date based on drop down selection Solved/Closed
I want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...
-
Comparing Two Excel Sheets and copying like data to third sheet Closed
Hi, In your below coding, I can copy paste the alike data from sheet 1 only, I need to copy paste both from sheet 1 and sheet 2 line by line matchi...
-
I AM FACING PROBLEM AFTER DOWNLOAD THE MS OFFICE 2010 Closed
hi ,, I am having a problem after download the ms office 2010.. it is not opening .. please tell me the solution .. ASAP
-
VBA: Cell Range Closed
Hello, I am a beginner with VBA and I have a question that might sounds stupid to some. I have created a function of IfElseIf and I want to run it...
-
Search for text , cut and paste into new work sheet Closed
Hi , can anyone help me with the below vba code : Logic Find text If next row starts with number Then - cut 1 row above text and 3 rows below ...
-
Dropdown menu disappears quickly before you can even choose Closed
My excel has been acting weird lately. All dropdown menu disappears quickly before you can even choose your choices. This happens in Data Filter fun...
-
Transfer data from one sheet to another Closed
Hello, i have started an inventory sheet on excel what I want to do is take the list of inventory and when it is sold, have it transfer to the second ...
-
How to compare two excel sheets and combine matching data Closed
Hello, I'm looking for a macro that will match data in column A from sheet 1 to the data in column A from sheet 2 and copy the corresponding rows f...
-
Trouble sending email from Outlook Closed
Hello I am trying to send email from my out look and it won't allow me. System Configuration: Windows / Chrome 60.0.3112.90
-
Generate new workbooks based on column value from multiple works Closed
I am a beginner in VBA. Basically I need a code that generates a new workbook for each specific column value in multiple sheets. The key in each sheet...
-
How to auto-populate values from certain cells into a new sheet Solved/Closed
Hello guys, Hope everyones doing okay. I've been working on a billing sheet for a company with multiple product codes and rates etc to be pulled f...
-
Copy and Paste entire row if a specific cell agrees with if cond Closed
Hello guys! I have been writing a vba code for a while and I cant find the mistake that I am making... I have a big table and I am comparing the va...
-
Date entered wrongly Closed
Hello, I entered dates as 'Apr 24' wherein I meant 24th of April..Excel has taken it to be '01 April 2024'..how do I correct all such entries, if ...
-
How to highlight a row when I enter a date in column I Closed
Hello, I am trying to highlight a row when I enter a date in column I. How is this achieved?
-
Copy Specific number of rows and insert n time after 3 rows Closed
Hello, Please help I want to Select & copy 35 rows data and after 3 rows I want to insert the copied rows n number of times. I need the Row widt...
-
Transfer data Closed
I have an excel spread sheet that has columns for last name, first name, office locations, and date. I may have 10 items listed in the column locatio...
-
Highlight only one column which has greater value Solved/Closed
Hello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...
-
Office 2007 files will not open Solved/Closed
Hi.. I am Dipu Michael from India. I am using the software office2007 in windows7.For the checking purpose I installed 0ffice 2003 in my system. Afte...
-
Using macro beta Closed
Hello All, Looking for a help here. Below is the data I am putting for understanding-- Column- A B C D E F G Row 1 - ...
-
Spellling error in Excel Closed
Hi Friends 1st, i want to say sorry for my broken english 2nd Did any one noticed what is resulf if you have only 00.50 Cent and your Spell num co...
-
Multiple data types in Excel Closed
Hello, I had a group of members contains in 4 fields and all these are enter into one simple format (example certificates) which is seperate works...
-
Date conversion in Excel Closed
Hello, how to convert birth date in word in MIcrosoft excel
-
Consolidate data from multiple sheets to one sheet. Closed
Hello, I have a workbook containing customer data (name, contact #s, addresses, etc.). The workbook is broken down into sheets according to which ...
-
Microsoft publisher 2010 ask product key, Closed
I downloaded microsoft Publiser 2010 but now they ask product key, where can I find
-
Unprotect VBA project with a macro Closed
How can I unprotect a Excel Book VbaProject with code VBA (I know the protection password)
-
Auto update hyperlink on the other sheet Closed
Hello guys =) Please help... I have a sheet with names and IDs which are in hyperlink and the same data i have also in the other sheet. If the I...
-
Automate transfer data from masterfile to another sheet Closed
Dear All, Hope you guys are doing well. I am not an expect in excel, I really hope you guys can provide me some sort helps/advise/how to automat...
-
Transfer rows to another sheet via color or letters of row Closed
the Excel sheet has information pertaining to record numbers. I check numeric record from a database and see if they are correct. if the information i...
-
Formula cell value change Closed
Hello, I have 2 columns..... say A & B If I type "Approved" in Column B1, then A1 should automatically change to "COMPLETED" If I type any ...
-
Replace 2007 Office Word Closed
Hello, I have received an e-mail that my Office 2007 is being retired and I will need a new key. My computer is a Microsoft 10 system. Do you have a...
-
Reminder by cell flashing /blinking Closed
Hello, Hi! I have a trouble call log. This is what I want to do.... Have a cell (or row of cells) flash or blink at a specific time from when...
-
Excel if statement with multiple text values in a column Closed
Hello, I am using excel 2017. I am trying to use this if statement to give me a value of 1 or 0. =IF((CQ2="Computer");1;0) The problem i...
-
Changing format of date in Excel Closed
Hello, Good morning, please I have a question. Question: Want to make use of a function such that with a date ( e.g 2/1/2017 formatted to b...
-
Excel 2016 filters do not work Closed
Hello, My filter stopped working in 2016. It is completely inactive - doesn't show any other option only the one it froze on. In the menu the filt...
-
Auto populate cells to one sheet from sub-sheets in Excel Closed
Hello, I am currently working with a spreadsheet that already has 7 worksheets total with a table on each. 6 of them have identical Table Columns ...
-
VBA code to range of days Closed
Hello, Please help guys... I have a code below: Sub Auto_Open() Dim r As Long For r = 2 To 53 If Range("I" & r).Value = Range("I...
-
Enter current time in a cell by clicking it Solved/Closed
Hello, I'm trying to minimize the effort to input data in a sheet I've built for recording time for dispatched workers I need to find a way to fil...
