The discussions
To compare substrings of two columns
Hello, I was looking to compare corresponding cells of two columns for match in substrings of both the columns in Excel 2010.My data looks as Col...
Problem in excel
dear sir, i have a problem in excel In column A have 50000 data including 9 digits . and in Column B I have 25000 data with 9 digit number. most o...
Excel: matching/sorting
Hello, I'm dumb, lazy, and having trouble finding an efficient way to complete a price list for my store. Here's what I need to do. I have two fi...
Compare 2 sheets - output in sheet 3 - excel
Hello, I have 2 sheets. For example: Sheet 1: A2 = 777 B2 = 5 A3 = 438 B3 = 4 A4 = 555 B4 = 3 Sheet 2: A60 = 777 ...
How to do if statements in excel
SolvedHello, I am having a problem trying to get an if formula right. If fig1 is +- 10% of fig2 I want it to say Fail If fig1 is within 10% of fig...
To compare cells of two columns
Hello, I need to compare corresponding cells of two columns of same worksheet and find if it is exactly matched and also if partially matched.For e...
Excel 2007 dropdown error in excel 2010
Hello, In excel 2007, I used Data validation list (drop down list) which retrieved data from another sheet and it works fine in excel 2007. Howev...
Excel help with macro
Hello, guys i am trying to copy the same cells B3,C3,D3,E3,F3 from 100 worksheets to a master one. So what i need is a macro that will copy the cel...
Not changeable cell in excel
Hello, I want to apply not changeable cell in excel. how to do that plz help me Regards & Thanks Bijal
Summary sheet
SolvedHello Sir, I Have 30 Data Sheets Of Individual Date & 1 Summary Sheet. The Example Of Those 30 Sheets Are: A1------------B1------------------...
Vba display in selected cell
Hello, Can somebody help me out with this objective.I would like to have the Staff Number which I'd search and found base on the code below to hav...
Excel calculations on dates
Hello, I have following: a start date, an end date. Difference can be 1 day up to 10 years. I need to calcuate the numbers of days represent...
Comparing two worksheets
Hello, I have two worksheets containing financial accounts and their YTD values in exact same formats. One worksheet is for 2009 and one is 2010....
How to copy data row form one sheet to anothe
Hello, Please help me how to copy one data row from one sheet to another. Here's the link of the screenshot: http://fc02.deviantart.net/fs7...
Excel how do i...
Hello, i'm interested in creating an excel sheet to reflect my workout routine. i know what i want but i'm not sure how to implement it. any advic...
How to convert vba macros to openoffice macro
Hi, I created few macros in Microsoft office by using vba,now I want same macros in open office, I tried to run same macros in open office but I wa...
Found cell color and worksheet viewing
SolvedHello, The code below had cause the found value cell color to remain there even after I closed the Input Box.I would like to have the color to be re...
Vb macro for serching wild card in entire sheet
Hello, In my excel I have colunms with column headings to it. I want to format them based on their identification. For eg. in case I have column n...
Macro doubt: look for a specific value
Hello, Thank you for helping me with this!! I am looking for help to write a macro that looks for a specific value in a given worksheet column,...
Vba to change found cell color
Hello, I would like to have the active cell to change color to yellow when a search value in a worksheet is located.The code I'm applying(below) see...
How to add a macro in vba
Hello, Friends I want to add some macros to my excel sheet. Suppose Cell "A1" is formatted in validation ( list drop down) which contains Contracto...
Macro copy & paste and if functions??
Hello, Configuration: Windows XP / Safari 534.16 I am a COMPLETE BEGINNER when it comes to macros. I get the basic idea though. I hav...
Vba if statement help!
Hello, I need some help with doing the following in vba: If column F has a date which equals zero then delete. If column F has a date which ...
How to run macros in other systems
Hi, I Created few macros in my system,now i want to deliver those macros to user,how i will give...? anybody help me please.Macros created in one s...
If cndition for activecell.value in excel macro
Hello, I need a query for excel macro ... If I click on empty cell it has to display "no job" If I click on any valued cell No function is oc...
Macro to find a value in a worksheet
Hello, I am new with excel macro and VBA codes.Can someone out there help me with the macro and VBA code to create an input boxes to seacrh and fi...
Macro to define a interval
SolvedHello, i have a excel sheet of details of employee of the organisation. in that sheet I have a column D of age. I have to define age interval f...
Repeating formulas in excel
Hello, I want to extend a formula to about 20,000 rows, so holding the fill handle will take too long. Is there any I can specify a number of rows?...
Copy rows based on a condition...revisited
Hello, This question was asked and answered by HELPER. (I'll attach it below as I cannot find a reference number) My addendum to the question is;...
Excel macro to find perticular column name
Hello, Ii have excel having column names in row#1. I want to write excel macro that will look for column name anything that had 'ID' or 'AMT' i...
Merge more rows into one
Hello, i want to combine more rows into one based on the same first cell which contains the same number ex : 529251 0 2456018 6 529251 0 2456019 ...
Compare sheet 1 & sheet 2 pull any items that
Hello, I saw this posted earlier... did you ever respond to this? +++ Your macro has been a great help to identify the matching records- th...
Macro to format cells
Hello, I hava excel data exported from a community page whihc will look like ttetetert -Row 1 yyyyyy Row 2 ...
Run a macro on another open application
Hello, I have a list of account numbers which needs to be keyed on another application named CBS - "Core Banking System.WS - [24 x 80]" I had r...
Excel help formula which capture this as prod
Hello, Can you please help me on this: The below data is in sheet 1: Products DATES VALUE A 2-Jan 1 B 2-J...
Excel count if
Hello, I am a school teacher that give "Marks" to students. The "marks" are leveled from 1 to 3. I have been inputting students into a spread shee...
Copy data from one spreadsheet to another
Hello, Can someone please help? ABC spreadsheet will copy the data to 123 spreadsheet, if there is no match find on Project ID, Name and Part. If ...
Help with excel 2007 charts macros
Hello, I have a macro that creates 3 charts. One is a simple bar chart and the other is actually two I've combined so that I have a bar and li...
Adding new data sets to multiple worksheets
SolvedHello, I am creating a spreadsheet database for data to determine the best vendor to use. I have multiple vendors on different worksheets and the...
Macro to copy rows from one worksheet to anot
SolvedHi , I'd like to know if there's a macro that can be run to check one worksheet. In this worksheet there is a column where the value should be "true"...
Copy rows from one worksheet to another works
Hi , I'd like to know if there's a macro that can be run to check one worksheet. In this worksheet there is a column where the value should be "true...
One button to execute two macros
SolvedHello, I got one macro in Sheet1 and another macro in sheet2 under the same workbook.I want to assign a button in sheet1 so it can execute both the ...
Excel formula a+b=c with the following except
SolvedHello, I really could use some help please. I am working on an 2010 excel spreadsheet. Would anyone know if there is a formula to do the following....
Use excel vba to create an e-mail w reminder
SolvedHello, I create a file in Excel that does some calculations based on a small database and some user input. I then added a button to open an e-mail...
Excel - if cell = "xxx" then email me@me.com
Hi there, Is there a code that can automatically send me an email if result = to something even when excel is not running but PC is on? Tks in ...
Comparing cells in excel
Hello, I am working on a formula in excel. I want to compare values on 4 different cells and return a value. When the values on columns A, B, C & ...
Excel query a sheet of raw data and return
Hello , I hope you're all having a good day so far. I however am not, I'm trying to pull certain data from a spreadsheet of raw data. It's an inves...
Link excel file to ms access and generate rep
Hello, I have an Excel file with 1000 lines of Information. I would like to link this file to MS Access and have one windows wherein it will ask u...
Excel moving data from one cell to another
Hello, Configuration: Mac OS X / Safari 533.19.4I have basic Microsoft excel skills and am making a spreadsheet for personal use. I have a li...
Combine two columns into one from two sheets
Hello, I have searched and tried some similar examples but cannot find a fit that works .I trying to combine two sheets into one .can someone plea...
