Excel Forum - solved topics
- Solved
-
Correcting VBA code in Excel Solved/Closed
Hello dears, I have the following VBA code : Private Sub Worksheet_Change(ByVal Target As Range) Dim cRow As Integer If Intersect(Target, Ra...
-
Highlight unique or duplicate on 2 sheets Solved/Closed
Hello, I have a Excel file of 2 worksheets and have a list of Usernames on column B of both worksheets. Few of the usernames appear on both sheets...
-
Excel dynamically fill cell with data Solved/Closed
Hello, I have worksheet ( AllUsers ) with two column A ( user id ) and B ( date ). Column A is a long list of user names and B is a list of dates ...
-
copy text frm a cell n append it thru macro Solved/Closed
Hello, I am trying to create a macro where I want to copy a cell content from one worksheet and append it to a cell in another worksheet of the...
-
Column comparation in different datasheet Solved/Closed
Hello, Hello, I have one excel column A in datasheet 1 which has a list of names. In Column A of datasheet 2 I have a much longer list of n...
-
VBA copy/paste cells then drop 1 row for next Solved/Closed
Hello, I am making a questionaire. When the questionaire is complete I want to copy the answers to another worksheet then reset the answers to zero...
-
How to determine cell value in Excel column Solved/Closed
Hello, Sorry the title is really vague, it's hard to describe with a limited number of characters. I have a column (C) which contains a full li...
-
Excel Macro Solved/Closed
Hello, I wonder if anyone can help me with a small (I think) problem, please? I'm trying to write a macro to manipulate a spreadsheet sent to m...
-
compare cell a1 to entire A col in sheet2 Solved/Closed
Hello, I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to ...
-
Excel problem Solved/Closed
Hello, Hello, I am hoping that someone can help with the following problem, I have a list of numbers, golf staplford scores, located in cell...
-
Excel - copy data macro Solved/Closed
Hello, I am currently learning the tricks in excel but have become stuck. I have created an expenses sheet where employees record various expenses...
-
how to move data in rows to columns Solved/Closed
The data now is in the below format 1 2 3 9 15 16 20 25 1 This has to come in this format 1 2 3 9 15 16 20 25 1 ...
-
If, then statement in Excel Solved/Closed
Hello, This formula sounds easy to come up with, but I cannot figure it out. I'm trying to figure out how to add a certain amount of days to a dat...
-
Excel: Populate data based on criteria Solved/Closed
Hello, Good day. I would like to populate data from 1 sheet to another sheet based on certain criterias. With reference to the sample data provide...
-
excel comparision Solved/Closed
hello, can any one help me solve the following comparison problem.. a(reference data) b(raw data) c(status) ab ...
-
VBA code in excel for 200 sheets Solved/Closed
Dear all who can help me. I have salary excel file. This file includes 200 sheets which are for each employee. I have the following VBA code. P...
-
Excel HELP Solved/Closed
Hello, If possible, can you help me in coding this: Collumn J will have the drop down menu of Open, In Progress, Complete [Open as default] ...
-
Excel Solved/Closed
Hello, My name is amit and i am having problem with creating a excel sheet which has three columns stating date , service and amount. and now i wan...
-
VBA code in excel Solved/Closed
Dears who can help me to write VBA code to solve the following case: I have Excel sheet to calculate overtime, includes several rows for each month...
-
Macro or VB in Excel 2007 Solved/Closed
Hi. I have next to no experience with macros & VB. But I have a problem that I need resolved. I have 11 sheets in excel. 10 sheets need to pull in...
-
To get cell contents into Excel file property Solved/Closed
Hello, Can you please kindly help me to solve the below interesting issue? (I will make my best to make myself understood, which is sometimes very ...
-
Excel Macro to insert row based on data Solved/Closed
Hello, I have a large spreadsheet w/ over 9,000 rows of data. I would like to know if a macro can be built to add a row(s) based on the month. In t...
-
Copy info from several cells into one cell Solved/Closed
Hello, Could you please help me solve my issue bellow? I have several sheets in Excel, i.e. Sheet 1, Sheet 2 and Sheet 3. I wanted that A1 cell from...
-
Excel Data Reading from another Excel Shheet Solved/Closed
Dear People, I have a small Requirement in Excel. Can you please help me out? Problem Description: Content of Raw Material Prices are maintai...
-
how to compare several columns...? Solved/Closed
Hello, could anyone help me with this. I would like to compare two columns: A B C D Peter 4 John 3 John 3 Peter 5 G...
-
How to extract info from csv files to excel Solved/Closed
Hello, I have 74,340 .csv files I need to extract information from Col. A-C & Rows 1-143 into an excel workbook, Sheet1. Every .csv file has diffe...
-
Paste to all sheets except some with criteria Solved/Closed
Hi, How can I make a macro paste copied data into some sheets of a worksheet but not other sheets. For example, I have 10 sheets in my worksheet ...
-
Formating a column using macro Solved/Closed
Sir A forum member helped me in writing a macro to copy certain data from sheet one to sheet two. I modified basic macro to suit as per my require...
-
office 2010 excel Solved/Closed
Hello, i am trying to show in cell J2 if the sum of cell I2 is more than 10 to show 10 and if the sum is les than 5 to show 0 have found how to show ...
-
copying data from worksheet 1 to worksheet 2 Solved/Closed
Hello, I am using MS Office Excel 2007 and need to know how to copy a row of data from one worksheet to another worksheet using a criteria from colum...
-
Excel - delete info from a cell found in anot Solved/Closed
Hello, Hello, I need a solution for the following situation: See attached screenshot from my Excel spreadsheet. I would like to know if the...
-
Cut &past data from sheet to shhet depending Solved/Closed
Dears, I'm a novice in M* Excel. Still, for day to day followup purpose, I need a macro and/or appropriate solution that does the following: For...
-
convert multiple rows and columns to one colu Solved/Closed
Hello, I have some data in excel sheet. Here is the example. 480,000 600,000 720,000 520,000 650,000 780,000 300,000 375,...
-
color code excel cells according to scores Solved/Closed
Hello, How do I color code cells in excel ti turn colors according to scores--such as red (0-69%), yellow 70-89%), green 90-100%)? Thank you, E....
-
Can i delete text up to a character in excel Solved/Closed
Hello, Is there a way of deleting all the text up to a certain character in excel. i im trying to import a CSV file in to exchange and need it tyding...
-
compare columns Solved/Closed
Hello, I have a situation like below. Column A Column B Column C A1 1 A2 ...
-
Excel-macro to group by column & sum value Solved/Closed
I was searching your web site for an example of how to group two columns and sum two different columns. I found an example under the question "Excel ...
-
Data Replication using macro Solved/Closed
Hello Experts, I have a requirement as follows: User data Entry: Column1 Column2 Column3 Colulmn4 TIME JAN FEB MAR INDIA Bangal...
-
Notifications on excel Solved/Closed
Hello, I would need your help to create a notification on excel. I've got a row of date's and when the date is 90 days prior to the expiry dat...
-
Unhide Tab in Excel Solved/Closed
Hello, I have a cell in excel that is either true or false. Based on that then it is linked to a check box. When ever I type the word "True" it ...
-
Macro for counting duplicates in raw Solved/Closed
Hello, I apologize in advance if even my search efforts have not found an answer to my question, believe me I've tried. Ok, I need ...
-
Match data from Excell Solved/Closed
Hello, I have information in different spreadshits which I would like to match by the name and year of a company. How can I do that? Example: ...
-
Excel/VBA2010-Select cells between 2 keywords Solved/Closed
Hi guys, Here's a tricky one. I'm trying to write a macro that starts from the active cell - goes up the column selecting say 20 cells and searches...
-
help with excel Solved/Closed
Hello, does anyone kno of a formula that will automatically input the next month. for example if I am starting with 10/28/2011 what is the formu...
-
Excel Auto Populate Solved/Closed
Hello, I've created a drop down list as B, I and A. on one sheet I need it to calculate the count automatically. The next sheet has coulmns sa...
-
Excel Charts / Graphs Solved/Closed
Hello, I need your help with regards to creating a chart on a different sheet in the same workbook. I've got employee names on top as a row , ...
-
Cells display a total or text Solved/Closed
Hello, I have an excel workbook that has cells that display a currency amount U43, U45, U47, U49, U51 and Q53. For example U43 would have $200 in...
-
Excel transfer selected rows Solved/Closed
Hello, I have in place a data validation,''list''. I want to be able to transfer selected rows with the different list names into separate worksh...
-
Excel Data Validation Solved/Closed
Hello, I have a master spreadsheet to collate data from spreadsheets filled in by my colleagues. Column b is 'Transaction Type' and I want to pro...
-
VB Excel 2010 - Loop until can't find Solved/Closed
Hello, We are trying to manipulate data from a very old DOS program. We have a lengthy macro that works well until the end where it seaches for s...