Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
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...
-
Macro VBA message run-time error '1040'/ I am getting this messa Closed
I akeep getting error message any time a try to test the Ctrl code. Please help. b PrintChart() ' ' PrintChart Macro ' Created 5/7/2013. Macro...
-
Multiple If Statement not returning numbers - returning words Closed
Okay now I need the column to say if the amount in c18 is 500.00 then put 20.00, but if c18 is 38.46 then put 38.46. When I enter the formula below, ...
-
graphic will only move up- all arrows nudge it up Closed
After copying an image into word, I'll set it to be behind or in front of text and try to position it exactly where I want by clicking and dragging it...
-
PDF won't open Closed
Emailed attachment in PDF won't open in my windows XP. After double clicking the file it asks for ... tried all the selection (as I don't know what to...
-
How to find out two words matching with one additional Number Closed
Hi.. Please tell me how to find out matching two words with only one differnce. If Two Columns of Excel contains Data like Vehcile Numbers MH01A123 an...
-
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...
-
Lookup/Index data with multiple match Closed
Hi, I am not an expert in excel but have some experience. Could some find me some excel formula or VBA code preferably for my data: 01/03/2013 C...
-
Macro to go into a series of Excel workbooks to make a change Closed
Hi, I recently got some help to create a Macro to go into a series of workbooks saved in a certain forder to extract a range of information and creat...
-
button to delete a row Closed
Hello, i'm trying to create a comand button on excel to delete a slected row, using vb, i need to know the whole procedure and the code appreciat...
-
Ms Excel found a problem and has to be finished Closed
Hello, XP, Excel 2002 I have a data sheet with a Line-gragh and scroll bars (up/down) The scroll bar shut increase/decrease a cell value. Done b...
-
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...
-
I want to put a date in B1 when I enter A1 Closed
Hello, I have a scanner that reads barcodes and when I read a barcode is there any way for it to put the date in B1 and the time in C1? I want ...
-
Conditional Formatting VB Closed
Hello, I wonder if you can help me please? I have an excel 2003 document which requires more than 3 conditional formats, i am using this piece of...
-
Macro Closed
Hello, I need to insert a multiple rows according to the count mentioned in column d. for example column A,B,C,D contains the data in Column D...
-
Excel Macro To Create New Worksheet Closed
I have a invoice tracking spreadsheet, which I would like to update to highlight overdue payments in a new worksheet. I would like the spreadsheet to ...
-
How to work with empty cells in Excel Macro Closed
Hello, I want to send email to list of users which are stored in Excel from A1 to A10. But if suppose if any of the cells from A1 to A10 is empty...
-
Inserting pictures into Excel based on file name Closed
Hi, I found the below macro on another thread and used it successfully to insert pictures into Column A based on file names in Column B. Howeve...
-
Searching and copying Closed
Hello, I am working on patent data and now I need a macro to transform the text to table. There are 30267 patent and it cannot be done by hand. One...
-
Replace charecter string with leading character Closed
Hello, I'm working on an extremely large catalog project where I'm basically taking one column of text and breaking it up into several different c...
-
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 ...
-
extract data from other spreadsheets in the same document Closed
Hello, I have about 100 sheets with different names in my excel document. I am trying to extract two numbers for each sheet into a summary sheet....
-
copy data from one sheet to another sheet in excel Closed
Hello i am having data in sheet one against date in column A1 and i want to paste date in sheet 2 against same date after this i want to change d...
-
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 send email. Outlook 10. Closed
Hello, Suddenly unable to send emails from either of my two computers for two days now (Outlook 10). Sitting in my outbox and cannot get them to mov...
-
Sum numbers in a column by corresponding number Closed
Hi there My question basically boils down to payment / invoice match. In one column I have amounts (paid or invoice - often one payment will inclu...
-
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...
-
Spellnumber for Excel
Hello, Good day to all. I have this problem about supplying automatic spell number in writing checks. Actually, I already have seen so many ways ...
-
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...
-
Warn the User of empty cell and indicate the location based on v Closed
Hello, I am new to VBA. I have a problem which I believe is very simple, but I am failing foolishly. I have to generate a MsgBox warning the user t...
-
Calculate average $/HR by pulling data from two workbooks Closed
Hi, I have been researching trying to figure out how to do some data manipulation with VBA, I have been going nuts trying and failing at making this w...
-
Problem Sending emails from Outlook Closed
Sometimes I live in the UK and sometimes in France. When working in the UK, using a landline wireless network Outlook works fine. When in France, I...
-
Search for text in multiple tabs and copy result Closed
Hi. Help needed please. I have a 2010 workbook which tracks income and expenditure, by month, for a small voluntary organisation. I want to be able...
-
Need help sending automated email in excel Closed
Hello, I need help. I am a rookie to excel and I would like excel to send an email everytime there is a change made to the drop down cell of my ex...
-
how to add day automatically after giving the date Closed
Hello, Please tell me the formula that i want that days are automatic displayed when enter any specifica date. For example if i write in excel...
-
How to insert result of =SUMIF on next free row Closed
I want to create an =sumif query on a new tab, which looks at all 12 tabs in an annual accounts workbook, either month by month or all 12 months at on...
-
Create new sheet,rename and allow duplicates numbering them sequ Closed
I have a workbook with 3 worksheets. 1) MENU 2) Arrears Report 3) NEW ACC and a button on the menu sheet with the following macro below The pro...
-
Sum a range of values only if it has certain value Closed
Hi, I need a formula to sum the values in a column but only for the cells in the next column that have a specific value. In my case I have range o...
-
looking for formula. Closed
hi looking for a formula to combine two worksheets in one both have 3 columns. if i copy the both worksheet in one than i have 6 columns like this. ...
-
while pasting the Un protected Cells became Protected an locked Closed
Hello, I made A excel work book called (Customer Daily balance) to be used by my Employees(users), this sheet is calculating the recent balance o...
-
Data Validation w/ Sum in Excel Closed
Hello All, I just found out about the drop down menu (Data Validation) feature, but I have a question in regard to it. I am trying to create a l...
-
Date format Closed
In Excel sheet i can't change date format. I tried to change usual. But nothing is happened. One format showing Standard. Please give the Solution.
-
Need to download Word to my new computer... Closed
I just bought a new computer and need to download MS Word to my computer. I have a MS World Product ID off my old computer. What is the proper way to ...
-
Help on..Calculating number of weeks between week numbers.. Closed
Hello everyone, I would like some help please.. :) I would like to calculate the weeks between week numbers. i.e Start Date: 04/03/2013 Week 10...
-
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 ...
-
wanted the microsoft windows pack for xp Closed
Hello, I am Shivam wanted to know about my Microsoft office tools such as Word,Excel,Powerpoint for xp.I wanted the site or url from where I can dow...
