The discussions
Excel macro help
SolvedHi there, I am getting an error when I try and run the following macro. I am trying to find the value in one worksheet (final) in another worksheet ...
Delete allowediteranges by vba
SolvedDear All, Can some-body help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRang...
Delete allowediterange by vba command
SolvedDear All, Can anyone help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRange...
Excel conditional formatting rows to columns
SolvedHello, I have a data set that looks like: A B 1 20 2 21 3 21 4 03 1 19 2 34 3 23 4 25 1 23 2...
Help about macro copy and paste
SolvedHello, Just want to seek help to anyone about my problem about copying and paste multple raw and column thru new sheet also with designated raw an...
Copy to first open cell in rowb/sheet 2
SolvedHello, Thanks for trying to help! I have a sheet as shown below. We do sales every day and would like the values/ estimates and sales that have...
Vba - how to replicate the value n times
SolvedHello, I have to write in VBA a macro that allows to replicate value n times (input). Let's say, I have a list one two three and I have to re...
Help required in ms excel
SolvedHello, I have a list of text strings in rows separated by blank rows. For example: Row 1: Name of the publication Row 2: Authors Row 3: Organiz...
How to compare columns of 2 different excel
SolvedI want to compare column named employeeid in two different EXcel sheets and have to retrive the rows with same employeeid ex: sheet1 emp name ...
Excel if then, create a new column
SolvedHello, I'm trying to write a VBA code, because I have too many factors to create a nested function. I can do it fine if there were less than 7 variab...
Vba to protect sheets & keep some options on
SolvedDears, I will be very grateful if some one can help me. I have excel file include 50 sheets, so I made one sheet that include all the basis info fo...
Indirect function on excel
SolvedHello, I need to know how I can add the following to an exsiting cell reference in a whole column. ='Sheet1'!A2 to show =INDIRECT("'Sheet1'!...
Searching names in drop down list in excel 07
SolvedHello, I have placed a drop down listbox in my excel 2007 work sheet and selected the range of names which are in the same sheet. In the list I hav...
Excel formula problem
SolvedHello, Please Help =IF(V12=1,2*(R12*50%)) I have a problem with this formula: What I need, is if v12 = 1, 2, 3, or 4 count R12 times 50%...
Excel: if a1 = a 4 the comy content of b1,2,3
SolvedHello, Please help! If A1 = a 4 the comy content of b1,2,3,4,5 to c1,2,3,4,5 The 4 in a1 are generated by a formula. Thanks Confi...
Excel - help!
SolvedHello, I require a formula which will recognise months in a column and select taht value from a different cell on the same row. The data is the...
Format using macro
SolvedHi I have some data in sheet1. Eg: Column A Column B Column C Column D 1 2 3 4 ...
Filter rows in one sheet
SolvedHello, I have large amounts of data in one work sheet(say it as Sheet1) and another worksheet(sheet2) has few records(100) which are also present ...
Converting rows data into columns on conditon
SolvedHello, I have data which looks like below ColA-----------ColB-------ColC--------ColD------------ColE---------ColF-------ColG----ColH-------- AA-...
Delete cells/rows but keep row info intact
Solvedhello, I am trying to import data from an excel spread sheet to access. I want to clean up my excel report before I import the date. In my report...
Dates in excel
SolvedHello, I have a list of people's birthdays in a list in Excel. I want to retain only the day and month of the birthday and get rid of the year. For ...
Excel comparing 2 columns removing duplicates
SolvedHi, I would like to cmpare 2 columns in an Excel spreadsheet & remove duplicates from Column B if any matching fields are found e.g. A B 1 ...
Excel 2007 vlookup and match problem
SolvedHello Long time lurker, first time poster. I'm having an issue with a Vlookup and match function. I have a set of data that is organised and sorted...
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...
Summary sheet
SolvedHello Sir, I Have 30 Data Sheets Of Individual Date & 1 Summary Sheet. The Example Of Those 30 Sheets Are: A1------------B1------------------...
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...
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...
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"...
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...
Macro to highlight a row if cells match value
SolvedHello, I sorry but I am very new to macros and trying to create one in Office 2003. I need to bold a row if for example column E is greater than a...
Count if macro on multiple criteria
SolvedHello, Could someone please help me out with a count-if macro on multiple criteria. I have attached a sample file in the below link http://ww1....
Help with excel
SolvedHello, i have two speadsheets. the first sheet contains a total column EX: in C4 =SUM(E4+G4+I4+K4+M4) Value of C4 = (339816) on the ...
Macro not saving file in excel format
SolvedHello, I have a coding like this: filename = Range("B3").Value Workbooks.Add Set newwb = ActiveWorkbook ChDir "D:\P3\Jan-11\B2B" ...
If then excel entry
SolvedHello, In excel, I have a row where hours worked is entered. Directly underneath that row is another row where allotted break time needs to be ...
Conditional formatting in excel 2007
SolvedHello, I am trying to apply conditional formatting to a calculated cell (For ex A). Criteria: If Cell A value = Cell B or " - " then ...
Select and copy only nonblank cells
SolvedHello, many thanks in advance for any responses I get here, I have toiled in vain on this for hours now. At first it was acceptable to simply c...
Date diff in excel 2010
SolvedHello, So I want to figure out how to write a formula for a difference in days on a "visit log". I want excel to look in multiple cells. (basicall...
How to name excel sheets on values in columns
SolvedHello, I have a list of people names in a column in one sheet with additional cells in each row for adding data. I want to create separate excel s...
How to insert rows dynamically with in group
SolvedHi, currently I am creating a macro, in to that I have data for row and columns. now I want to count the product in column A, with formula =counta (...
Macro to class interval
SolvedHello, I have a workbook of employee data and at dth column i have ages of employee. in eth column i have to define age interval like. 18-25...
Excel less than but greater than
SolvedHello, How would I get into L2 if J2=>10 then "lates", if J2=
Excel if function
SolvedHello, Could someone please help me with the following problem. I want to know how to do a if function in vba to search for a value (output), a...
Ms excel
SolvedHello, I want to use ms excel but i am not getting any option of ms excel in my computer how can i use ms excel when i don't have it.......? ...
Button to color sertain numbers (excel)
SolvedHello, Im looking for a way to make a button color all numers equal to the the number on the button.. as an eksample, lets say i have a row of...
Import excel data into mysql database
SolvedHello, This is Nischala .Can any one suggest me wheather we can import excel sheet data into mysql database using .net application(vb.net or asp....
If-then statement to copy rows
SolvedHello, I am wondering if there is a way to copy a specific row from one worksheet to another in the same workbook based on an IF-Then statement. ...
Excel macro assistance
SolvedHello, I have a macro running a process of performing a couple of formulas in a workbook that uses VLookup. Every week I have to re-edit the r...
