The discussions
Calculate average $/hr by pulling data from two workbooks
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
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
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
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
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...
Create new sheet,rename and allow duplicates numbering them sequ
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
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.
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
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
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
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...
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..
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/ClosedHello, 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
SolvedHello, 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
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...
Change date format
Hello, I want change date formula to "sep 10 2013" in 10-9-2013 plz give me detail Configuration: Windows XP / Internet Explorer 8.0
Excel macro to insert the same 120 rows between 1000 unique rows
Hello, I'm creating a product catalog database in Excel. I have 1000 unique product lines (rows). Each of those 1000 products is offered in 120 col...
How can i change date figure into english words
Hello, i want to change a date written in figure in excel sheet in words. eg 6-4-2013 into Sixth april Two thousand thirteen please help me
Formula help
SolvedHello, 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...
Macro for fill color alternative rows
Hello, I want a macro for fill color alternative rows in excel selected table (only visible rows), anyone can you please help me.
Formula not working
SolvedHello, 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
SolvedHi, 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...
Compare 2 sheets
Hi, I have two excel sheets that i need to compare. The problem is that the column headers of sheet 1 doesn't match with the column headers of shee...
Macro to delete a certain worksheet...
Hello, I was previously helped out with the following macro: https://ccm.net/forum/affich-689536-generate-excel-workbooks-based-on-excel-list ...
Forgot the password
ClosedHello, I forgot the password for Folder lock 7 Kindly give the solution Configuration: Windows XP / Firefox 20.0
How to get the last digit of a value of a cell to other in vba ?
Hello, I am trying with vba excel that how to get the last digit of a value in one cell to other.suppose I am trying to the get last digit of 9928...
Comparing two columns of names in excel
Solved/ClosedHello, I have one excel sheet. column A has a list of names formated as follows: Last name, First name Column B has a much longer list o nam...
Need help with excel formula
I am having trouble figuring out a formula when figuring angles. I will write what I need (very simply) so you understand what I am trying to do. ...
Get excel 2010 to send auto e-mail
Hello, I have a spreadsheet that i track my vendors certificate of insuranse expiration dates on. i am wanting excel to send me an automatic e-mai...
What is the shortcut key to drag down in excel to create series
What is the shortcut key to drag down in excel to create series of numbers from 1 to 10.
Issue with v-lookup and possibly pasting data from the web?
Hi, I'm hoping someone can help me. Using windows 2010, I'm using data from 500 alphanumeric codes that I copied-and-pasted from the net into a pr...
Spreadsheet data
SolvedHi everybody. I am trying to develop a large data input spreadsheet which will have circa 20 operators data input on a daily basis. (approx 150 ent...
Microsoft office excel is trying to recover your information
Hello Please Help Me for the below given problem recently my system was formatted due to virus problem and I reinstall the Windows8 and Office2...
Finding values from 2 worksheets where item matches
Hi, I have just start my new role where I am stuck some where I have got 1 Order form where SUPLIER NAME|SUPPLIER CODE |SUPLIER ITEM CODE|REF N...
Attendance sheet
SolvedHi, i want to make attendance sheet in Microsoft Excel 2007 with alphabetical words like P for Present, A for Absent, L for Late, H for Holiday wit...
Excel vba to open other screen
Solved/ClosedHello, We are working on dual screens. I am writing a macro program in VBA. I need to open an existing excel file/workbook in a new excel application...
How do i get excel file ( no formula) from another one ( with fo
SolvedHello, I have a big excel file with lots of formula and link. now can I export these data only( no link or formula) to another excel file? Thank yo...
Exclude "0" values from string: =h2&";"&i2&"
Hello, I'm using the following string in excel. =H2&";"&I2&";"&J2&";"&K2&";"&L2&";"&M2&";"&N2&";"&O2&";"&P2&";"&Q2 It will concatenate serveral ...
How to check two fields in excel and act by that?
SolvedHello, Can anybody help? I would need very simple macro to check two cells. A1 will be name A2 A3 will be second namew A4 Does A2=A4 ...
Using if for data validation
Would like to seek your assistance. I trying to make a condition using data validation. this is the scenario: for column C8 (this is the dropdown l...
Conditional formatting in excel 2003(more than 3)
Hello all, Excel 2003 novice here trying to teach myself. I am trying to make some fields turn a certain colour depending on the number of...
Conditional formatting
SolvedI am trying to maintain three lines of accounting on one spreadsheet. Basically, I have an order amount (C3) . I want to take that total from one of...
Count when a range of cells contains a certain word or phrase
Hello, I have a spreadsheet which I am trying to summarise information from. We receive enquiries from many different properties we manage, and I'...
How to convert a numeric value into eng. word by rm
Hello, please help me this, Convert a numeric value to Ringgit Malaysia Thanks. Configuration: Windows 7 / Chrome 25.0.1364.97
Copy data from one wb to another
Hello. I'm hoping I can describe my problem/question in a way that makes sense... Here goes: At my work, we have a program that will create an exce...
Macro for inserting missing monthly rows
Hello, Can someone please help me with writing up a macro which inserts rows, which contain missing monthly dates within a data set? I basicall...
Copy data from one workbook to other----help
Write macro to copy data from Source File to assignment-2 file. Make sure you take care of following conditions * Book with same name should...
Microsoft word macros
Hello Friends, Please suggest me links from which I can find/download many useful macros for Microsoft Word. Regards GN Jha Configura...
Pivot table
Hello Friends, I have 3 concerns related to Microsoft Excel which are as following. Pls help me for all these 3 individually.: 1. Suggest me...