Office Software Forum - solved topics
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
- Solved
-
combining two separate macros into one Solved/Closed
Hello, I currently am using these two separate macros independently but would like to combine them into one with the archive one being first. I'm...
-
Date formatting in dd/mm/yyyy Solved/Closed
Hello, I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have i...
-
Macro to Search/Replace Text from another Column Solved/Closed
Hello, I didn't realize I was being rude on my previous post, that wasn't my intention. I tend to have a "too the point" personality sometimes, and...
-
Won't save passwords / usernames Solved/Closed
Hello, Computer won't save passwords / usernames, even when I ask it to and I have went into tools and everything was set as suppose to.
-
urgent ansin excel Solved/Closed
a table caring 4 rows, first row is Name, second is address, 3rd row is date, and forth row is house name. how i arrange this in excel in date wise...
-
Popup reminder based on date and additional celll values Solved/Closed
Hi, I am new to this site and have seen a lot of great information and helpful tips here. I have been trying to figure this out for a very long tim...
-
Word Markup Area Solved/Closed
Hello, How do I turn off markup area in Word? Thanks!
-
Hide rows with zero value in Multiple sheets Solved/Closed
Please help me in making a macro in the Excelsheet that: I can hide the entire rows if a cell value or (range of values) has a zero value in multiple...
-
Conditional formating Solved/Closed
I have a spreadsheet with Excel 2013 that has text drop down lists. I want to use conditional formatting to highlight with a different cell color, dep...
-
Convert a date field in excel to day of week Solved/Closed
Hello, I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the week so...
-
some help needed about IF function with dates Solved/Closed
Hello, i m making a sheet with this function =IF(H1
-
creating pdf from selected cell range Solved/Closed
Dear all, greetings. firstly , I would like to thank those who have helped me to get below code (to create pdf file for selected cell range) whic...
-
how to compare two coloumns in excel Solved/Closed
Hello,
-
microsoft office Solved/Closed
good day ! i would like to ask if how can i activate my microsoft office even though i dont have any activation code.. thank you God bless
-
Trying to write a code to insert a blank row above a cell value Solved/Closed
I am trying to write a code that will auto insert a blank row above a certain cell value ie: existing: Column G 5 10 20 22 999 2 22 55...
-
request for a formula marks of my students Solved/Closed
Hello, sir, I am a teacher. I entered marks of my students in a column in excel-2007 work sheet. I have to prepare grades from the marks. Marks from ...
-
I cant open my exel .slxs files Solved/Closed
Hello, am not able to open my exel files(office 2007) which are in .slxs formet. when am trying to open that file windows is showing this message: ...
-
Enter Time by clicking on a cell Solved/Closed
Hello, I need help setting a code in Excel. I am new to VBA but have used Excel for awhile. I would like to set Columns D & E up for time. I want...
-
Conditionally insert a duplicate row Solved/Closed
I have a table with hundreds of rows but here's a basic example: __a___b_____c____ 1 Color Dates Completed (headings) 2 red Date1 No 3 red Dat...
-
Macro Help Copy Specific Text from One cell into another Solved/Closed
Here is the scenario: I have a large excel spreadsheet and I have a column in which I only need the last ten characters of each line copied or move...
-
EXCEL - Create a bulleted list in a single cell from a list Solved/Closed
Hello, I'd greatly appreciate some help with this: I'm trying to get a list of data in cell "D5" only from cells "A1:A10" that do have informat...
-
why i cant open my pdf files even though i'm having adobe reader Solved/Closed
hai. i'm having new version of adobe reader, when I try to open my pdf files by double clinking on it it opens in word. when I try to select'open-wit...
-
Adding 1 to an existing number if criteria is matched? Solved/Closed
In column A I have a set of initials and in column C I want a number that corresponds to the number of times the initials have appeared... Column ...
-
Find the sum of data that has multiple conditions in Excel Solved/Closed
Hello, I have a large data table, and I want to find the sum for certain data that fits a few criteria. Here is a simplified example: __a_____b__...
-
Error when creating mailmessage Solved/Closed
Hello, Using Excel and Outlook 2007 I want to create an emailmessage with a Macro. But I am running into an error I can not find any "comprehensi...
-
From Excel, Open a word document and goto a page question Solved/Closed
Hello, I have an Excel document which I have inserted some VBA code to open a word document; Set WordApp = CreateObject("word.Application") Wo...
-
MAX value in one coulmn based upon another column Solved/Closed
Batch Price Column C 00015 2.75 00015 2.9995 00016 1.89 00017 0.56116 00018 0.1421 00018 0.11808 00018 0.1605 00018 0.12575 00018 0...
-
Highlighti Row/ colour fill through VB Solved/Closed
Hello, I am after a code which enables me to highlight/ colour code a row on basis of expiry date and update every time I open that exel file. f...
-
Comparing Data in Excel Solved/Closed
Hello, I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered ...
-
Re: Make a macro run when data entered in a cell -multiple event Solved/Closed
Hello, I have three macros in the module and I want each macro to runs when the user changes the values in the cell (Cell F2) to "first", "second", ...
-
conditional format Solved/Closed
Dear reader, I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel. Example. NL08569638 ...
-
Look at column and match and add this text te Solved/Closed
Hello, I am working with Excel 2003. I need the formula to look in Column 1 and look at all these names. and compares the name if it is Sally the ad...
-
convertion Number into word Solved/Closed
Sir, How can convert Number into word in excel sheet. suppose there is 253900 in cell B2 in excel sheet. How can I convert this number as Two lakh ...
-
40 % add formula in excel cell Solved/Closed
i want to increse 40% amount in my excel sheet and I have total quantity 90 can anyone like to tell me that how will I entre the 40% in excel cell tha...
-
INSERT ROW DATA INTO EVERY SECOND ROW Solved/Closed
Hi I have an excel sheet with blank rows every odd line (i.e rows 2,4,6,8...700 are empty). I have to paste a row of data (the same all the way th...
-
macro Solved/Closed
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 13/05/2013 by dhale ' ' Keyboard Shortcut: Ctrl+a ' Application.Goto Reference:="onecell" ...
-
Incoming and outgoing mail servers Solved/Closed
Hello, I am having multiple email accounts. I like to configure all my email accounts in OUTLOOK EXPRESS. I am not able to do the same in OU...
-
Greater than/Less than between 2 Dates Solved/Closed
i am trying to to populate a spreadsheet that if the date is less than 01/01/2013 then populate the cell with $500.00, if the cell is equal to or grea...
-
Macro to highlight cells. Solved/Closed
I am very new to VBA and have spent countless hours looking for help on the web. I have a worksheet with 100,000 rows(locations) and 34 columns(Cha...
-
Date change with column paste Solved/Closed
Hello, Whenever I try to paste the dates and times from one spreadsheet to another, the dates changes from 2008 to 2004. Why won't the dates just...
-
HELP ME WITH FORMULAS PLEASE? Solved/Closed
Hi all, I need a set of 3 to 4 formulas which would show a monthly grow of accrued interest on each of the new amounts eg: formula 1:Month 1- 1...
-
creating an If function using dates Solved/Closed
Hello I am trying to formulate an if function, should the date in the cell be less than six months old from today's date the font is red, should the ...
-
Outlook 2007 using Windows 7 Home Premium OS ... Solved/Closed
Hello, I've not been able to SEND e-mails, only receive them. Outlook 2007 continues to try to send an item from the 'outbox' to no avail; then iss...
-
Unable to copy selected cells after apply autofilter function Solved/Closed
Dear All, I am using excel 2007. In my dataset, I have following: Column A - Set of locations and Column B: Number of times location appears. When...
-
Num Convert to text in Excel 2007 Solved/Closed
R/Sir, As per your instruction i have done how to num convert into words.But i have face a problem when i have writeen above 99999, than num co...
-
How to conver Image to PDF File? Solved/Closed
Hello, I want to send a File to my friend which in format of Images but Images are so large and my friend want it only the format of PDF File as h...
-
VBA Code 2 import many cells not in range from many workbooks Solved/Closed
Hello, I have used some of your codes for importing data ranges from several workbooks. I am using Excel 2010. I have around 2,000 workbooks ...
-
Formula Help Solved/Closed
Hello, I think this is a simple question just not for me :) I have a simple business spreadsheet showing total project cost in Column (C.) C, T...
-
Formula not working Solved/Closed
Hello, Q16 to Q20 cells contains values from 0 to 10 (it came from LOOKUP Function). I need to get a result in D24 from the cells Q16 to Q20 as ,"...
-
import from multiple workbook to single SHEET Solved/Closed
Hi, Thank for all your wonderfull help all these days, to cut short, I am looking for a VBAcode, which can import data from multiple Workbook file...
