The discussions
Getting and error msg "the file you are trying to open "xxx.xls"
Hi folks, getting and error msg "The file you are trying to open "xxxxx.xls" is in a differernt format than specified by the file extension. Verify...
Dates change when copying...
SolvedHello, Thanks to this kind of forum, I've been able to deal with issues around the date systems 1900 vs 1904. It remains a problem though since ...
Need a macro which copy values from rows and paste into a table
Hello, Actually I have a payroll in Excel. Each employee's salary detail is in a row. eg S# Name Basic Allo1 ...
Copy row based on value of cell, and update row data back
Hello, I have 3 sheets, "WHOLESALE", WEB SALES" & "ORDERS". If "WHOLESALE" or "WEBSALES" have a value "SPECIAL" in Column "A", it must copy th...
I would like to compare 2 columns.
SolvedHello, I would like to compare 2 columns A to F, if the value is the same I would like to populate the value of column C with the value from Colum...
How to do an automation for copy paste, added new row (macro)
SolvedHello, I have attached file http://www.sendspace.com/file/wjh0oe I want to automated a some step (tab table Z) Thus, for example, that in X 201...
Kindly request for excel help in cell formating
Hello, Configuration: Dell laptop with vista If you have some time, can you please try to help me, I would greatly appreciate any help ...
Formula help needed
SolvedHello, I am in need of a formula. I own a business in which I receive payments from my clients in various ways. I also have multiple locations...
Updating multiple sheets from a master sheet
Hello, Please, how do I create a mapping between multiple sheets and a master sheet all in the same workbook? I have at least 400 sheets and ther...
Entering value for column at once, displaying in all sheets
SolvedHello, I have a workbook with multiple sheets(1,2,3) , each sheet has list of items randomly placed, the same items are repeated in other sheets ran...
Import files into excell 2003 from path
Hello, I would like to import a long list of photos into a spread sheet using excell 2003 to make a product catalog. in column F I have the path t...
Help combining worksheets in excel 2007
Solved/ClosedWe use excel 2007 to store information about our products and have a different worksheet for each range. Is there any way of combining all these wo...
Conditional formatting
SolvedHello, I need a help on Conditional formatting: I have a data in A2:E5 (Sheet 1), and in Sheet 2 i have reference data in Column A. i need to...
Use of formula
Hello, l try to add up figures with vat but l coudn't get de total thanks. Configuration: Windows 7 / Firefox 19.0
Inventory
SolvedHello, Can you pls help me with the following: I have Inventory Workbook, and Invoices. Every time I open new Invoice and entering Quantities of...
Vba how to create new worksheet and move value
SolvedHello there, I am zero in vba, can anyone please assist me what code to be used given following conditon Given,(I have data converted from csv t...
Have to update data from one sheet to other sheet automatically
Hello, I have four excel sheets , in which some field names are similar. When i update a common field in one sheet i want other sheets to update ...
Format range of cells based off another range of cells
Hello, I have a set of values in column $A. I want to format cells in columns $B:$Z to be red if any of their values are equal to any values in co...
Excel, if / then or is there a better way?
Hello, I have a spreadsheet that lists each kid in my class. I have entered the answer they gave for each and every question on a 40 quesiton test....
Password macro help
Hello, I have a code that unlocks sheets I need to use that are password protected but I have other code I used to combine the worksheets into 1 w...
Vb how execute code for each file open & open multiple files
Hello, The top half is code for opening my file. I tried opening multiple which seems to open but not execute the code I want ran for each file. I'm...
Facing difficulties in implementing charts
I have file1, file2, file3 and I want to have a chart with each's G column from 2 to final and each's I column from 2 to final. G in X axes and I i...
Excel macro
Hello, I need a help in using the excel macro I have designed the Userform for searching the particular value from the excel.By typing the valu...
Compare two columns in different sheet and retrive corrspo value
Hello, How to compare two columns in one sheet with that of two columns in other sheet and retrive the corresponding Key value of the third column...
Excel macro; adding password
Solved/ClosedHello, Hope you anyone can help me with this... I need to create a macro that unlocks a password-protected sheet with password "password", do so...
Summing up data from groups & pasting it another column
SolvedHello there, I need to write a macro for the following example: A 2 A 3 A 3 B 4 B 1 B 4 C 7 D 3 D 8 Etc. Basicallly i ne...
Special sum of a column
SolvedHello, In have some columns with plenty of data. And I need to make a column which will have ... D2=C2 D3=C2+C3 D4=C2+C3+C4 ....................
Number to word
Hello, i want to covert number in to word like 1000(one thousands) 100 (one hundred) Plz help me to convert number to word in this format Conf...
Comparing data in multiple excel worksheets
Hello, For work, I was given an excel document with a different worksheet for each month in 2012. Clients can come to our food pantry one time in ...
Calculation of time
Hello friends Pls help me to calculate time in excel. Time value is A1 is 15:25. I have to subtract 11:30 hrs from A1 and doing calculation lik...
Summary of two or more excel sheets
Hello, i want to do summary of two or more worksheets in a single worksheet to review the data and anlysis. is there any method to do this. pl...
Formula for identifying letter with sum value
Hello, I am new to Excel and know very basic formulas. I have made a spreadsheet and have everything pretty much ok except for one part I need ...
Macro code for sum of 3 rows
Hello, I have a problem. I have a data in which there is only 1 column but 1000 rows. I need a macro to get sum of 3 rows. can anyone help me...
Office excel & outlook
Hello jim, "I have a Excel Sheet in which details of member are recorded with there Date of Birth and e-mail id. and I want to wish them on there ...
Problems with if-function...
Hello, I'm using Excel 2003 (yes, still) and I'm having trouble with the IF function. I have a 13-digit number in E2, and in F2 I want the funct...
Column addition automatically
Hello, I get raw data base from client, My first work is to insert two new columns in Column 6 & 7.....Is it possible to do it through macro ?...
Excel formatting
Hello, I am having trouble with a formula in Excel. I have 600 rows of financial data. Column A has numbers 1 thru 6, which correspond with differe...
Need help with percentage please
SolvedHello, I am new to excel and I am not very good at it so any help would be greatly appreciated. I know anyone out there is helping for no reason o...
How to get the data while entering in the other cell
Hello, Thanks for your reply. But what i need is if i enter a student ID in a cell in sheet 1 it must open the student details of concerned id in...
How to find the data by entering the data in one cell
Hello, we are dealing with projects of different colleges. there is a data of more than 1000 students. each time i have to click on the respective...
Copy rows to different spreadsheets based on 1 column
Hello, I have a spreadsheet where I track open orders for my company. We track this by multiple metrics and values. I currently manually copy and ...
Populate data in excel according with n
SolvedHello all, My intention is populate an Excel sheet with a variable number of rows according with a number inserted on a fixed column. co...
Conditional formatting using dates in different cells
SolvedHello, I need help with a problem that is driving me insane. I have column A, B, and C A is date started B is date finished C is days it to...
Percentage formula?
Hello, I have a column in a Micosoft Excel spreadsheet that contains Yes & No answers. Can anyone please tell me how do I find out how many Ye...
Compare and count two columns
Hello, I am struggling with a fairly basic excely problem. I have 2 colums Feb 2012 and Feb 2013 each have a number of different crime types...
Comparing data in two columns and setting a value
Hello, I'm comparing data in a very big database. and want to assign a value to matching data. For example A B ...
Excel search words from a cell and assign txt in another cell
Hello, I am having data like whi below: A B 1. customer1 TV Fridge ...
Macro - copy speciffic columns when value is x
Hello everyone, I've been having a problem for a while and seem to be unable to solve it. I am now trying to get it done with Macro's but run...
Percentage formula
ClosedHello, I have a column in a Micosoft Excel spreadsheet that contains Yes & No answers. How do I find out how many Yes answers I have compared a...
Excel macro copy/paste and insert rows
Hello, I am trying to write a macro that takes data from a filter and copy and pastes it into a template to create a standardized set of reports. ...
