Office Software Forum
- Excel (9,813)
- Open Office (114)
- Outlook (643)
- PDF (334)
- PowerPoint (181)
- Word (2,187)
-
Transferring data from one worksheet into another Closed
Hello, VERY new with Excel and have a question I'm sure you'll find basic. I have two worksheets. In one worksheet, column G has text in it and in...
-
How can decimal convert 0.50+ paise into re 1 in spellnumber Closed
Hello, i'm very much satisfied with given solution of amount convert into words. But I'hv question that, how can i change 0.50+ paise into re 1...
-
Autopopulating course information for a Training Log Closed
I work in EMS and organize the training for everyone in our service. I'm working on a realistic way to track main categories and sub categories for ea...
-
Macro to Create a New Spreadsheet Based on Another Closed
Hello, I have the following problem. I have a spreadsheet in which I record some information regarding an employee and all the exams he has been su...
-
How to change the date format in Excel 2007 Solved/Closed
Hello, i want to know that howcan I change the dateformat in excel 2007 worksheet if I want it like :- monday,1dec.2008 plz. answer me soon....
-
Change VBA code to get embedded image not link Closed
Hi everyone, I have a VBA code, which inserts image into excel based on the cell value entered in coloumn A. My problem is that image is a link, an...
-
Macro to Create New Workbook and Copy Data at Each Change of X Closed
Hello, I get large spreadsheets with thousands of lines with close to 200 patient names (one patient contains multiple lines for each different da...
-
How to compare column and spot the difference Closed
Hi. I really need help to solve this problem. I have few hundred data in 4 columns as below. Is there's anyway I can use excel formula to find the ...
-
Macro to create new workbook and copy data Closed
Hello, I need help to modify the code which is already by rizvisa1 in reply to this thread http://ccm.net/forum/affich-286527-macro-to-create-new...
-
Convert date into Month and Year to use > < Closed
Hello, I have two sets of dates that I need to compare using ,=. One of my dates is formatted mm/dd/yyyy. the other date is mm/yyyy. The goa...
-
Scanned PDF file problem Closed
Hello, Good Afternoon. I am using windows 10 & Nitro pro 9. I have received a pdf document of 10 pages from my friend ( he is using apple mac bo...
-
Excel macro to create new workbook and copy data Closed
In the example below, I want to create five new excel files with the same heading and the data should be copied based on the unique Line numbers (Colu...
-
Sentence peekaboo Closed
In excel. I am typing a sentence and as soon as I click in another cell half of my sentence disappears. Only to reappear when I click back into the be...
-
How to make workbook autocreate new sheet every month with data Closed
Hello, I am looking for some help, I am wanting my workbook to auto create a new sheet at the begging of every month and that when it makes the ne...
-
Button/VBA to move rows one by one in the same row Closed
Hello, I need a button or something to move rows one by one (from 13 to 50) to the row nr. 10. Every row have the same style but different dat...
-
Copy names from one worksheet to another and copy Closed
Hello, I have an issue at work that a macro, if it is possible, would be extremely useful. I have an excel file with a list of hundreds of first...
-
Excel help please! Closed
Hello, I am in the process of creating an action tracker so it has all the actions that come out of different meetings. Each meeting has a seperate...
-
Macro to transfer column to row on another excel Closed
Hi All, Was stuck on this for a few hours yesterday. Read a few threads with solutions but I kept getting a debug popup window. I'm trying to tr...
-
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 - ...
