The discussions

Excel macro to copy text and append

 Solved

Hello, I recorded a macro in Excel where I copied the text from one cell and appended that text to the values in several other cells. The problem...

4 replies Last reply on 2 May 2011 by
RWomanizer

Cell reference to locate /store data in excel

 Solved

Hello, Hello , I am working for a newly started airline agency. I am enclosing my working file (for privacy sake , I have changed names and oth...

8 replies Last reply on 2 May 2011 by
suryam

Excel macro help

 Solved

Hi 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 ...

1 reply Last reply on 29 Apr 2011 by
venkat1926

Delete allowediteranges by vba

 Solved

Dear All, Can some-body help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRang...

3 replies Last reply on 26 Apr 2011 by
Issa

Delete allowediterange by vba command

 Solved

Dear All, Can anyone help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRange...

2 replies Last reply on 26 Apr 2011 by
Celina

Excel conditional formatting rows to columns

 Solved

Hello, 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...

2 replies Last reply on 25 Apr 2011 by
em

Help about macro copy and paste

 Solved

Hello, 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...

3 replies Last reply on 20 Apr 2011 by
venkat1926

Copy to first open cell in rowb/sheet 2

 Solved

Hello, 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...

6 replies Last reply on 20 Apr 2011 by
Stormdronk

Vba - how to replicate the value n times

 Solved

Hello, 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...

5 replies Last reply on 18 Apr 2011 by
gradelle

Help required in ms excel

 Solved

Hello, 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...

7 replies Last reply on 16 Apr 2011 by
eskagsms

How to compare columns of 2 different excel

 Solved

I want to compare column named employeeid in two different EXcel sheets and have to retrive the rows with same employeeid ex: sheet1 emp name ...

3 replies Last reply on 15 Apr 2011 by
RWomanizer

Excel if then, create a new column

 Solved

Hello, 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...

7 replies Last reply on 14 Apr 2011 by
RWomanizer

Vba to protect sheets & keep some options on

 Solved

Dears, 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...

2 replies Last reply on 13 Apr 2011 by
Issa

Indirect function on excel

 Solved

Hello, 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'!...

10 replies Last reply on 13 Apr 2011 by
tipsindeed

Searching names in drop down list in excel 07

 Solved

Hello, 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...

5 replies Last reply on 11 Apr 2011 by
RWomanizer

Excel formula problem

 Solved

Hello, 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%...

3 replies Last reply on 4 Apr 2011 by
Stormdronk

Excel: if a1 = a 4 the comy content of b1,2,3

 Solved

Hello, 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...

3 replies Last reply on 3 Apr 2011 by
rizvisa1

Excel - help!

 Solved

Hello, 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...

1 reply Last reply on 1 Apr 2011 by
TrowaD

Format using macro

 Solved

Hi I have some data in sheet1. Eg: Column A Column B Column C Column D 1 2 3 4 ...

16 replies Last reply on 29 Mar 2011 by
harry

Filter rows in one sheet

 Solved

Hello, 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 ...

5 replies Last reply on 29 Mar 2011 by
RWomanizer

Converting rows data into columns on conditon

 Solved

Hello, I have data which looks like below ColA-----------ColB-------ColC--------ColD------------ColE---------ColF-------ColG----ColH-------- AA-...

3 replies Last reply on 29 Mar 2011 by
RWomanizer

Delete cells/rows but keep row info intact

 Solved

hello, 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...

2 replies Last reply on 25 Mar 2011 by
TrowaD

Dates in excel

 Solved

Hello, 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 ...

1 reply Last reply on 24 Mar 2011 by
RWomanizer

Excel comparing 2 columns removing duplicates

 Solved

Hi, 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 ...

3 replies Last reply on 23 Mar 2011 by
rizvisa1

Excel 2007 vlookup and match problem

 Solved

Hello 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...

1 reply Last reply on 23 Mar 2011 by
Nikeyg

How to do if statements in excel

 Solved

Hello, 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...

2 replies Last reply on 18 Mar 2011 by
Emerbeamer

Summary sheet

 Solved

Hello Sir, I Have 30 Data Sheets Of Individual Date & 1 Summary Sheet. The Example Of Those 30 Sheets Are: A1------------B1------------------...

9 replies Last reply on 18 Mar 2011 by
RWomanizer

Found cell color and worksheet viewing

 Solved

Hello, 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...

2 replies Last reply on 14 Mar 2011 by
TrowaD

Macro to define a interval

 Solved

Hello, 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...

12 replies Last reply on 9 Mar 2011 by
rizvisa1

Adding new data sets to multiple worksheets

 Solved

Hello, I am creating a spreadsheet database for data to determine the best vendor to use. I have multiple vendors on different worksheets and the...

2 replies Last reply on 4 Mar 2011 by
Aaron

Macro to copy rows from one worksheet to anot

 Solved

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"...

9 replies Last reply on 4 Mar 2011 by
Gowind

One button to execute two macros

 Solved

Hello, 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 ...

4 replies Last reply on 3 Mar 2011 by
azmiismail

Excel formula a+b=c with the following except

 Solved

Hello, 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....

2 replies Last reply on 3 Mar 2011 by
Scott

Use excel vba to create an e-mail w reminder

 Solved

Hello, 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...

2 replies Last reply on 2 Mar 2011 by
Bruno

Macro to highlight a row if cells match value

 Solved

Hello, 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...

2 replies Last reply on 22 Feb 2011 by
sgriffis

Count if macro on multiple criteria

 Solved

Hello, 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....

4 replies Last reply on 22 Feb 2011 by
Wasem

Help with excel

 Solved

Hello, 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 ...

1 reply Last reply on 21 Feb 2011 by
RWomanizer

Macro not saving file in excel format

 Solved

Hello, I have a coding like this: filename = Range("B3").Value Workbooks.Add Set newwb = ActiveWorkbook ChDir "D:\P3\Jan-11\B2B" ...

4 replies Last reply on 21 Feb 2011 by
RWomanizer

If then excel entry

 Solved

Hello, 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 ...

2 replies Last reply on 18 Feb 2011 by
Jen

Conditional formatting in excel 2007

 Solved

Hello, I am trying to apply conditional formatting to a calculated cell (For ex A). Criteria: If Cell A value = Cell B or " - " then ...

17 replies Last reply on 16 Feb 2011 by
Toast

Select and copy only nonblank cells

 Solved

Hello, 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...

5 replies Last reply on 15 Feb 2011 by
Ambucias

Date diff in excel 2010

 Solved

Hello, 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...

2 replies Last reply on 14 Feb 2011 by
Mark

How to name excel sheets on values in columns

 Solved

Hello, 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...

8 replies Last reply on 14 Feb 2011 by
eskagsms

How to insert rows dynamically with in group

 Solved

Hi, 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 (...

1 reply Last reply on 9 Feb 2011 by
rizvisa1

Macro to class interval

 Solved

Hello, 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...

1 reply Last reply on 7 Feb 2011 by
TrowaD

Excel less than but greater than

 Solved

Hello, How would I get into L2 if J2=>10 then "lates", if J2=

2 replies Last reply on 3 Feb 2011 by
Welshjessy

Excel if function

 Solved

Hello, 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...

4 replies Last reply on 20 Jan 2011 by
PM

Ms excel

 Solved

Hello, 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.......? ...

1 reply Last reply on 10 Jan 2011 by
jack4rall

Button to color sertain numbers (excel)

 Solved

Hello, 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...

2 replies Last reply on 7 Jan 2011 by
Alstrom

Import excel data into mysql database

 Solved

Hello, 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....

4 replies Last reply on 5 Jan 2011 by
Er.mayank khandelwal
Results 1301 - 1350 out of a total of 1,690