Excel Forum
-
Pop up message stating empty cells Solved/Closed
Hello, I am relatively new to VB and I am trying to help a friend build an application form for work. Basically what I am trying to do is, there ...
-
getting and error msg "The file you are trying to open "xxx.xls" Closed
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... Solved/Closed
Hello, 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 Closed
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 Closed
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. Solved/Closed
Hello, 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) Solved/Closed
Hello, 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 Closed
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 Solved/Closed
Hello, 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 Closed
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 Solved/Closed
Hello, 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 Closed
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/Closed
We 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 Solved/Closed
Hello, 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 Closed
Hello, l try to add up figures with vat but l coudn't get de total thanks. Configuration: Windows 7 / Firefox 19.0
-
Inventory Solved/Closed
Hello, Can you pls help me with the following: I have Inventory Workbook, and Invoices. Every time I open new Invoice and entering Quantities of...
-
import photos from path Closed
I want 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 to the photo as:...
-
VBA how to create new worksheet and move value Solved/Closed
Hello 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 Closed
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 Closed
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? Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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/Closed
Hello, 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 Solved/Closed
Hello 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 Solved/Closed
Hello, 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 Closed
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 Closed
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 Closed
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...
-
excel question nt answered by kioskea Closed
Hello, you have no answer of my question . Configuration: Windows 7 / Internet Explorer 9.0
-
summary of two or more excel sheets Closed
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 Closed
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 Closed
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 Closed
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... Closed
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 Closed
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 Closed
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 Solved/Closed
Hello, 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 Closed
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 Closed
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 Closed
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 Solved/Closed
Hello 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 Solved/Closed
Hello, 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? Closed
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 Closed
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 Closed
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 Closed
Hello, I am having data like whi below: A B 1. customer1 TV Fridge ...
